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

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

Similar questions

4 and 5
Using the Henry Books database, increase the price of book “The Fall” by 10%. You will insert 2 snips for this question.
For the database of Figure 4.12, write a query to find the ID of each employee with no manager. Note that an employee may simply have no manager listed or may have a null manager. Write your query using an outer join and then write it again using no outer join at all.
Use the given database to output the results of the following SQL queries: b.) SELECT ∗FROM course AS C INNERJOIN instructor AS I ON C.dept name = I.dept nameWHERE I.ID = 45565; c.) SELECT dept name, building, name, IDFROM department LEFTJOIN instructor ON budget = salary;
Write a SQL query that retrieves the names and email addresses of all students who are enrolled in at least one course in the "Computer Science" department and have a graduation year of 2022 or later. Include the course name and instructor name for each enrollment in the output. Schemas of the tables are below. "students" table: student_id: unique identifier for the student name: name of the student email: email address of the student major: field of study for the student graduation_year: expected year of graduation for the student "courses" table: course_id: unique identifier for the course course_name: name of the course instructor_name: name of the instructor teaching the course. department: department offering the course. course_description: description of the course "enrollments" table: enrollment_id: unique identifier for the enrollment student_id: identifier for the student enrolled in the course. course_id: identifier for the course the student is enrolled in…
Given the table PRODUCT(ProductID, ProductName, ProductClass, ProductWeight, ProductStyle, ProductColor, ProductPrice). Note: ProductWeight and ProductPrice are numeric fields, and the other attributes are character fields, i.e., store text. Write a SQL query to display the product class whose average price is at least 50
database
When constructing a table at the column level, what is the maximum number of columns that may be defined as a primary key before the table becomes too large? (See the tables in the JustLee Books database for further information.)
Project 4 : Working On University Data Set Project: Working on university dataset Industry: Education Problem Statement: How to improve the teaching process of a university Topics: In this PL SQL project you have the Student and Staff data in tables. You will create the Course table and insert data into it. Then you will join the three tables and analyze the data. This includes coming up with all the courses with corresponding students and the teachers associated. Then finally you will create a detailed report on the teaching structure and ways to improve it. Highlights Inserting data into the table and joining tables Querying the data for various conditions Prepping the data for analysis.
Use single-row subquery in a HAVING clause. List customer numbers of customers who paid total amount (sum of quantity * paideach) of their orders less than the average of total amount of orders that paid by all customers. Include the following columns in the result. a. Customer Numberb. Total AmountHint: The subquery returns the average total amount that paid by all customers. We need to join two tables in this subquery and use group function to find average of total amount based on the number of customers.
Using the Henry Books database,Henry Books no longer carries books written by Barbara Owen. Delete this author from the authors table. You will insert 2 snips for this question. What construct did you use to delete author Barbara Owens? Insert the snip of the construct used: Insert the snip of the authors table. Be sure all rows are displayed:
Given the table PRODUCT(ProductID, ProductName, ProductClass, ProductWeight, ProductStyle, ProductColor, ProductPrice). Note: ProductWeight and ProductPrice are numeric fields, and the other attributes are character fields, i.e., store text. Write a SQL query to retrieve all details of products whose name is "Watermelon" and whose color is "green".