Question: 1. Design a DM using the following Two 1 to Many relationships One Many to Many relationships Minimum of 5 tables Every table should have

1. Design a DM using the following

Two 1 to Many relationships

One Many to Many relationships

Minimum of 5 tables

Every table should have a Primary Key

Any relationships between tables should be enforced with Foreign Keys

Each table has 3 attributes (not including keys)

Follows the 8 rules around a standardized DM

ii. Write the DDL to create your DM

1.Create the tables

2.Alter the tables to have Primary Keys

3.Alter the tables to have Foreign Keys

4.Create sequences to be used for PKs

iii. Create dummy data

All tables should have a minimum of 5 records on each table

Bridge tables should have a minimum 10 records

Be careful of foreign key constraints

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!