Question 1:
The diagram below (also attached in DBST651_final_part2_ERD.pdf ) is an ERD for an order entry database for a company. A customer orders products through company employee.
Study the ERD and answer the following questions:
Identify all relationships and specify cardinality and business rules. For example: 1:M between Customer and Orders: a customer can place many orders; an order will be placed by one and only one customer.
For each entity, identify primary key and foreign key if any. For foreign key, also specify parent entity and matching attribute in parent entity.
Write SQL DDL statements to create tables in Oracle and also implement primary key, foreign key, and NOT NULL constraint. Include all columns listed with the correct data type. This step is important as in Question 2 you will run INSERT statements to populate the tables you created and then write SELECT statement to query those tables.
Write SQL statement for the following scenario:
Add a new customer John Smith with custono 1 and custzip 23456.
Save changes permanently.