Populate fields into your tables. Create original and expected items for each field. Do not use generic fillers. Side: 7


Populate fields into your tables. Create original and expected items for each field. Do not use generic fillers. Side: 7 rows Entree: 5 rows Menu: 4 rows (seasonal) Zip: 4 rows (local) Address: 10 rows Menu_Dish: 5 rows Side_List: 8 rows (matching menu dishes with sides) Dish_Build: 16 rows (matching menu with menu dishes) Event_Menu: 4 rows Member: 12 rows Add rows of inserts that simulates the invitation process. Write the insert statements for 100% invitations for one event. Then, add rows of inserts that simulate the return of only 10 RSVPs. You can decide which 10 people RSVP. Of those 10 RSVPs, two are not attending. Of those attending, 50% will have guests. Also, write the inserts for those attending and their dish selection. You should be executing the entire script from the top to make sure it works. Finally, complete this query at the bottom of your database script: Write a SQL statement that gives you all the names of the people that attended one of your seasonal events and specify if they are members or guests. (Without using the wildcard (*) for the fields.)


Leave a Reply

Your email address will not be published. Required fields are marked *