To practice modeling databases, you'll be tasked with designing an ERD for a hypothetical application. Think about what models you would need and what tables you'd create, including the associated attributes and how they would related to other tables.
Break into groups of three to create relationships in draw.io using crow's foot notation for one of the apps below.
At the end of class, we'll ask for volunteers (or pick some participants) to walk us through your thinking & explain your decisions.
Remember to consider all different angles in each of these examples. What jobs relationships exist? What people are there? What objects and intangible ideas are necessary? How would you organize it?
-
Pick one of the following in your group, design the table relationships, and draw them:
- an app to run a grocery store
- an app to run an airline
- an app to run a school
- an app to run a team of developers
An ERD diagram using draw.io of whatever app you choose. For example:
Note: this example has "Items" as placeholders for the attributes.