- Let's say that this restaurant only takes customers if they made a reservation, and each reservation is used to represent a party of people. Add a table to the database containing each individual food item that was ordered by a party of people. Hint: you will want to use two columns as the primary key for this table. This table should represent each food item that was ordered by a party of people. You may create a third column in this table called 'quantity', so we know how much of a food item a party of people ordered. *Enter 3-4 test records of data for each table. ● ● ● Design the database tables for the scenario described above. Think of some possible attributes for each table. Write "PK" above each column that is a Primary key and "FK" above each column that is a Foreign Key.
- Let's say that this restaurant only takes customers if they made a reservation, and each reservation is used to represent a party of people. Add a table to the database containing each individual food item that was ordered by a party of people. Hint: you will want to use two columns as the primary key for this table. This table should represent each food item that was ordered by a party of people. You may create a third column in this table called 'quantity', so we know how much of a food item a party of people ordered. *Enter 3-4 test records of data for each table. ● ● ● Design the database tables for the scenario described above. Think of some possible attributes for each table. Write "PK" above each column that is a Primary key and "FK" above each column that is a Foreign Key.
Chapter3: Table Creation And Management
Section: Chapter Questions
Problem 9RQ: What happens if you try to decrease the scale or precision of a NUMBER column to a value less than...
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
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.Recommended textbooks for you