Question: Q1. (25 points) Consider ER diagram below. Write one or several create table statements that implement the entity sets, relationship sets and constraints encoded by

 Q1. (25 points) Consider ER diagram below. Write one or several

Q1. (25 points) Consider ER diagram below. Write one or several create table statements that implement the entity sets, relationship sets and constraints encoded by the diagrams (a) (10 points) Assume that ssn attribute is of type integer, name attribute is of type char(32), address attribute is of type char(64) and date is of type date. date name address name ssn Chefs orks in Restaurants (b) (15 points) Assume that name attribute is of type char(20), and year attribute is of type year name year name Artists Paint Paintings. year- Owned Museum

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!