Reference: Textbook Minicase MC3, pp. 54. This is a variation of this textbook minicase with an additional constraint included in the list below. Please use the problem description below.)

Snooty Fashions is an exclusive custom fashion designer business. Using ERDplus, create the ER diagram for the Snooty Fashion Operations Database based on the following requirements. Insert the ER diagram as an image below the requirements.

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 customers 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 outfits identifier as well as the outfits 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).

For each customer, Snooty Fashions will keep track of the number of outfits that each customer buys.

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.)