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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started