Question: M 3 : Identify relationships and determine modality and cardinality of each relationshipM 3 : Draw ER - DiagramsFashion Forward is an exclusive custom fashion

M3: Identify relationships and determine modality and cardinality of each relationshipM3: Draw ER-DiagramsFashion Forward is an exclusive custom fashion designer business. Create the ER diagram for the Fashion Forward Operations Database based on the following requirements.The Fashion Forward Operations Database will keep track of the following: For each designer: a unique designer identifier and unique email address as well as the name (composed of first and last name); For each customer: a unique customers identifier as well as his or her name and multiple email addresses; 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 outfits identifier as well as the outfits planned date of completion and its price; For each fashion show: a unique show identifier as well as the date of the show, location and theme; 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 (Fashion Forward 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. Fashion Forward 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 Fashion Forward designers. (Fashion Forward will not keep track of fashion shows that do not feature Fashion Forward designers.)

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!