Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Construct a data model given the given information. I'm really curious on if the favorite drink should be a one-to-one relationship with customer or if
Construct a data model given the given information. I'm really curious on if the favorite drink should be a one-to-one relationship with customer or if it should be an attributee of customer? Like if its a one to one does that mean having separate entitites for beverage etc
The Walk-in Shop and Pub is a caf offering beverages, pastries, and sandwiches, with a tavern atmosphere at night. Kellie runs the caf and wants to be able to track customer transactions. A customer can buy many items on the menu in one transaction, yet they can only have one favorite drink. Each transaction is recorded on a given date and time and has a reference number (that's how each transaction is identified). Customers' names and email should be tracked. Also, the items purchased by customers should be tracked, along with their favorite drink and amount of money they spent at the caf. If a customer is in the database, they were involved in at least one transaction. Details about which beverages, pastries, and sandwiches are on the menu along with their descriptions and prices should also be tracked. Instructions: - Create a conceptual data model based on the above situation in MySQL Workbench. - Pay attention to entities, attributes, relationships, and data types as well as cardinality and modality. Save your model as a PNG file
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started