1. You must use Microsoft Visio! 2. Include all entities and attributes. Use the field list of...
Question:
1. You must use Microsoft Visio!
2. Include all entities and attributes. Use the field list of these instructions.
3. Include all associative (join) entities and attributes.
4. Include all relationships (make sure to add the foreign keys!).
5. Your ERD must be neat and easy to read!
Scenario: Jayhawk Wine Club You manage a small business called Jayhawk Wine Club. Your business sells individual bottles of wine to customers. Each customer can place many different orders, but each order is associated with a single customer. Each order can contain many different wines, and each wine can be purchased on many different orders. A certain wine is produced by a specific producer, and each producer can produce many different wines. Jayhawk Wine Club employs a team of salespeople. Each salesperson can take many orders, but each order is taken by a single salesperson. A specific salesperson is not assigned to each customer. Your business sells to customers in all fifty states. Many customers can live in each state, but each customer lives in only one state.
* Denotes a Required Field. WineID* WineType* WineYear* WineDescription* WinePrice WineCost ProducerID* ProducerName* ProducerPhone* ProducerSize OrderID* OrderDate* OrderDiscount OrderShipDate OrderShipMethod QuantityOrdered* CustomerID* CustomerFirstName* CustomerLastName* CustomerEmail CustomerStreet* CustomerCity* CustomerState* (the two-letter state abbreviation) CustomerZIPCode* CustomerMarketing SalespersonID* SalespersonFirstName* SalespersonLastName* SalespersonHireDate* SalespersonSalary SalespersonCommission SalespersonPicture StateAbbreviation* StateName* StateRegion
Expert Answer:
To create an EntityRelationship Diagram ERD based on the given scenario of Jayhawk Wine Club I can p... View the full answer
