Question: 7. Draw the data model for the following. Be sure to indicate the primary key and foreign keys in the model. Use visio or another

7. Draw the data model for the following. Be sure to indicate the primary key and foreign keys in the model. Use visio or another ER modeling tool to solve this problem. Copy the solution and paste it into this document. 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 customer's spouse is (if they have one), but wants to keep an individual record of the customer and the spouse. 8. Create the database designed in answer to question 7. Create the tables in the database you use and copy and paste the table creation script here. 9. Populate the tables created in question 8 with at least 3 rows per table. Copy and paste the code you used to populate the tables here. 7. Draw the data model for the following. Be sure to indicate the primary key and foreign keys in the model. Use visio or another ER modeling tool to solve this problem. Copy the solution and paste it into this document. 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 customer's spouse is (if they have one), but wants to keep an individual record of the customer and the spouse. 8. Create the database designed in answer to question 7. Create the tables in the database you use and copy and paste the table creation script here. 9. Populate the tables created in question 8 with at least 3 rows per table. Copy and paste the code you used to populate the tables here
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
