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 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
Get step-by-step solutions from verified subject matter experts
