Question: 1. From the solution ERD, create a relational database schema diagram. Use the data dictionary on the last table of the solution to determine the
1. From the solution ERD, create a relational database schema diagram. Use the data dictionary on the last table of the solution to determine the column names and there types. If you add any foreign keys, use a similar naming convention as the data dictionaries. If any tables you create don't have obvious primary keys you may create an ID-number column in its place. "Obvious" means you can't tell what the primary key of a table would be. If a table has a primary key that is a composite key (consists of multiple columns) do not create an ID-number column 1. From the solution ERD, create a relational database schema diagram. Use the data dictionary on the last table of the solution to determine the column names and there types. If you add any foreign keys, use a similar naming convention as the data dictionaries. If any tables you create don't have obvious primary keys you may create an ID-number column in its place. "Obvious" means you can't tell what the primary key of a table would be. If a table has a primary key that is a composite key (consists of multiple columns) do not create an ID-number column
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
