Lab: Data Modeling in a Diagram

You've learned about the types of data you can store in a database as well as how you can represent the relationships between that data. Now it's time to revisit your original Data Model and refine it with your new knowledge.

So go find the spreadsheet you made to represent the data found in your application of choice.

Update the Data Model

At this point, your spreadsheet might have a bad representation of how entities are related. Or maybe you didn't make any relationships yet. Make some notes about new columns or tables that you will need to add.

This is also a good time to start thinking about constraints. If there is a relationship, which table needs to own the foreign key that references the other?

Create the Diagram

You can use any method you want, as long as you follow the proper conventions and keep it neat. I'd recommend drawing it on paper or using software like draw.io. Here's an example:

• All tables are represented as blocks with a heading for their name.
• All columns are listed with appropriate names and data types.
• Mark constraints like primary and foreign keys next to the column.
• Link up related tables with the correct arrows to show the right type of relationship.

Submit It

If you drew your diagram, take a photo with your phone but make sure it's legible. If you used software, export it as an image or PDF.

Upload your diagram to Slack and send it to me by the end of class.