COUNTRIES - Read the description below and identify the tables, columns, primary key, foreign keys, and composite foreign keys that would be needed to create this database system using the logical model concept. A country has several states, but a state belongs to a single country, and a state has several cities, but a city belongs to a state. Create the model using the necessary tables, columns and relationships. 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 columns that make up the composite primary key. i.e. TABLE ((column1, column2 (CPK)), column3);
COUNTRIES - 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 country has several states, but a state belongs to a single country, and a state has several cities, but a city belongs to a state. Create the model using the necessary tables, columns and relationships.
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 columns that make up the composite primary key. i.e. TABLE ((column1, column2 (CPK)), column3);
Step by step
Solved in 2 steps
