Using the 3NF tables you've formed in the Module 2 Assessment create queries to fulfill the...

 

Transcribed Image Text:

Using the 3NF tables you've formed in the Module 2 Assessment create queries to fulfill the scenarios below. 1. Create the database tables using the CREATE query w/FK references. 2. Use a join to display the orders for the main customers (Chaucer, Hemingway) 3. Use a join to display the order of all tables 3NF Reservations TableReservations Order 3NF Table Reservation id 002 003 Reservation id 002 003 Reservation id 002 002 002 003 003 003 Table 2 3 ReservationName Geoffrey Chaucer Ernest Hemingway NumberOfPeople 7 4 Order Order Caesar Salad A5 Wagyu Steak (Medium Rare) New York Cheesecake (Whole) Bread Sticks Seafood Platter Using the 3NF tables you've formed in the Module 2 Assessment create queries to fulfill the scenarios below. 1. Create the database tables using the CREATE query w/FK references. 2. Use a join to display the orders for the main customers (Chaucer, Hemingway) 3. Use a join to display the order of all tables 3NF Reservations TableReservations Order 3NF Table Reservation id 002 003 Reservation id 002 003 Reservation id 002 002 002 003 003 003 Table 2 3 ReservationName Geoffrey Chaucer Ernest Hemingway NumberOfPeople 7 4 Order Order Caesar Salad A5 Wagyu Steak (Medium Rare) New York Cheesecake (Whole) Bread Sticks Seafood Platter