- 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.
Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts
Section: Chapter Questions
Problem 10RA
Related questions
Question
![. 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.
●](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F971cf0c0-f175-43eb-81b0-784ad4b29e4a%2Fd776f36a-faa6-44f8-9cd5-e12ae940de6d%2F7z82qq7_processed.jpeg&w=3840&q=75)
Transcribed Image Text:. 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.
●
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)