Question
The gourmet food club sells select food products via home parties. Aimee runs one of these clubs and wants to be able to track who
The gourmet food club sells select food products via home parties. Aimee runs one of these clubs and wants to be able to track who has come to her parties and who has hosted a party for her. She keeps all contact information about her customers (e.g., name, phone, email, and address) and tracks the date and time of all parties she has given. A customer may attend many parties (and of course parties have many attendees) and a customer may also host many parties (but each party is only hosted by one person). Aimee also likes to keep track of who each customers spouse is (if they have one), but wants to keep an individual record of the customer and the spouse.
a. Draw a data model of this situation. Indicate primary and foreign keys
b. Create the database designed to answer part a. (Using SQL, write the code and paste it here)
c. Populate the tables created in part b with 3 rows per table. (Using SQL, write the code and paste it here)
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