Question

Question 1 Draw a Entity Relationship Diagram

Snooty Fashions is an exclusive custom fashion designer business.

The Snooty Fashions Operations Database will keep track of the following:

• • For each designer: a unique designer identifier and unique SSN as well as the name (composed of first and last name);
• • For each customer: a unique customer’s identifier as well as his or her name and multiple phone numbers;
• • For each tailoring technician: a unique SSN as well as his or her name (composed of first and last name);
• • For each outfit: a unique outfit’s identifier as well as the outfit’s planned date of completion and its unreasonable price;
• • For each fashion show: a unique show identifier as well as the date of the show and location;
• • Each designer designs many outfits. Each outfit has only one designer.
• • Each outfit is sold (in advance) to exactly one customer. Customers can buy one or many outfits (Snooty Fashions will not keep track of customers who have not made any purchases yet).
• • Each tailoring technician must work on at least one outfit but can work on many. Each outfit has at least one tailoring technician working on it but can have many.
• • Snooty Fashions will keep track of the date when a tailoring technician started working on a particular outfit.
• • Each designer can participate in a number of fashion shows, but does not have to participate in any. Each fashion show can feature one or two Snooty Fashions designers. (Snooty Fashions will not keep track of fashion shows that do not feature Snooty Fashions designers.

Question 2 Draw a Schema Diagram with the same information.

Answer 1

Que 1 :

ER diagram

Que 2 :

Schema diagram...