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 rowsEntree: 5 rowsMenu: 4 rows (seasonal)Zip: 4 rows (local)Address: 10 rowsMenu_Dish: 5 rowsSide_List: 8 rows (matching menu dishes with sides)Dish_Build: 16 rows (matching menu with menu dishes)Event_Menu: 4 rowsMember: 12 rowsAdd 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…

Database System Concepts

7th Edition

ISBN:9780078022159

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

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

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

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

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions