Part 2: Relational data model. Take a subset of the ideas from the conceptual model you constructed in Part 1 and design a simple relationship model similar to the ones we discussed in Module 2, Video 4 Your model should have at least 5 tables You should include at least 20 attributes, or fields, in your model (20 total across all tables, not per table) Your model should be normalized Identify the primary key in each table, and state whether it is a natural or surrogate key For each relationship between tables, identify any foreign keys needed to define the relationship For each table, identify what type of system or systems you think the data might come from, like those we discussed in Module 1, Video 6.
Part 2: Relational data model. Take a subset of the ideas from the conceptual model you constructed in Part 1 and design a simple relationship model similar to the ones we discussed in Module 2, Video 4
-
Your model should have at least 5 tables
-
You should include at least 20 attributes, or fields, in your model (20 total across all tables, not per table)
-
Your model should be normalized
-
Identify the primary key in each table, and state whether it is a natural or surrogate key
-
For each relationship between tables, identify any foreign keys needed to define the relationship
-
For each table, identify what type of system or systems you think the data might come from, like those we discussed in Module 1, Video 6.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
