A$)$Draw an E$-$R data model for The Queen Anne Curiosity Shop database schema shown in Chapter $3$s The Queen Anne Curiosity Shop project questions. Use the IE Crow$$s Foot E$-$R model for your E$-$R diagrams. Justify the decisions you make regarding minimum and maximum cardinalities.

B$)$Extend and modify the E$-$R data model by adding only The Queen Anne Curiosity Shop$$s inventory system requirements. Use the IE Crow$$s Foot E$-$R model for your E$-$R diagrams. Create appropriate identifiers and attributes for each entity. Justify the decisions you make regarding minimum and maximum cardinalities.

C$)$Extend and modify the E$-$R data model by adding only The Queen Anne Curiosity Shop$$s need for more efficient storage of CUSTOMER and EMPLOYEE data. Use the IE Crow$$s Foot E$-$R model for your E$-$R diagrams. Create appropriate identifiers and attributes for each entity. Justify the decisions you make regarding minimum and maximum cardinalities.

D$)$Combine the E$-$R data models from parts B and C to meet all of The Queen Anne Curiosity Shop$$s new requirements, making additional modifications as needed. Use the IE Crow$$s Foot E$-$R model for your E$-$R diagrams.

E$)$ Describe how you would go about validating your data model in part D$.$

Use these tables:

CUSTOMER $($CustomerID$,$ LastName, FirstName, EmailAddress, EncryptedPassword, Address, City, State, ZIP, Phone, ReferredBy$)$

SALE $($SaleID$,$ CustomerID, InvoiceDate, PreTaxTotal, Tax, Total$)$

SALE$\_$ITEM $($SaleID$,$ SaleItemID, PurchaseID, SalePrice$)$

PURCHASE $($PurchaseID$,$ PurchaseItem, PurchasePrice, PurchaseDate, VendorID$)$

VENDOR $($VendorID$,$ Vendor, Phone$)$