Question

Snooty Fashions is an exclusive custom fashion designer business. Below are the Requirements of Snooty Fashions. 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 that 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)

Create an ER Diagram and a Relational Database Diagram for Snooty Fashions based on the following requirements using ERDPlus

Answer 1

This Image shows about the Relational Table Schema of Database Snooty Fashion Database as per the given attributes.

This Image shows the Entity-Relationship representation of above given Snooty Fashion Database