I need this answer in SQL. . SQL please if your going to answer it 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. 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.)

Approach:1- First, I have created a database as a user.2- After creating a database then after…

Answered: I need this answer in SQL. . SQL please if your going to answer it Populate fields into your tables. Create original and expected items for each field. Do…

Database System Concepts

7th Edition

ISBN: 9780078022159

Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher: McGraw-Hill Education

See similar textbooks

Concept explainers

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.

Question

I need this answer in SQL. . SQL please if your going to answer it

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.

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.)

Expert Solution