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