Create the model using the necessary tables, columns and relationships.
Read the description below and identify the tables, columns, primary key, foreign keys, and composite foreign keys that would be needed to create this
A company sells books on the web and can deliver them to all of North America. It needs a system to manage sales and keep track of customer information, the books the customer bought and how much each customer paid for per book. A customer can purchase multiple books in a single transaction. Create the model using the necessary tables, columns and relationships.
Tip: You need at least 4 tables for this model.
Feel free to explain or take notes on your diagram.
What matters for this question is not the number of tables and columns, but rather the logic you use when developing the model.
You must represent it by respecting the following textual notation.
Table name: is represented by the first word in capital letters in front of the parentheses. i.e. TABLE ();
Columns name: are inside the parentheses separated by commas. i.e. (column1, column2);
PK: Stay with the column which is the primary key. i.e. TABLE (column1 (PK), column2);
FK: Stay with the column which is the foreign key. i.e. TABLE (column1 (PK), column2, column3 (FK));
CPK: Stay with the column that makes up the composite primary key. i.e. TABLE ((column1, column2 (CPK)), column3);
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
