What are the SQL statements that will produce the tables and columns identified below (including relationships/keys/constraints)? Also, could you tell me the SQL statements to populate at least 5 records in each of the tables?Thanks!! Bookbook_id (primary key)titleauthor_id (foreign key to Author table)year_of_releasenumber_of_pagesgenrelocation (in library, checked out)Authorauthor_id (primary key)nameCustomercustomer_id (primary key)nameagephone_numberjoin_dateBookCheckoutbook_id (foreign key to Book table)customer_id (foreign key to Customer table)checkout_datedue_datereturn_dateRelationships:Book to Author (one-to-many)Book to Customer (many-to-many)Customer to BookCheckout (one-to-many)Keys and Constraints:Primary keys:book_id (Book table)author_id (Author table)customer_id (Customer table)Foreign keys:author_id (Book table) -> author_id (Author table)book_id (BookCheckout table) -> book_id (Book table)customer_id (BookCheckout table) -> customer_id (Customer table)Constraints:A book cannot have more than one checkout record at a time.A customer cannot check out more than one copy of the same book at a time.

Answered: What are the SQL statements that will…

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

What are the SQL statements that will produce the tables and columns identified below (including relationships/keys/constraints)? Also, could you tell me the SQL statements to populate at least 5 records in each of the tables?

Thanks!!

Book

book_id (primary key)
title
author_id (foreign key to Author table)
year_of_release
number_of_pages
genre
location (in library, checked out)

Author

author_id (primary key)
name

Customer

customer_id (primary key)
name
age
phone_number
join_date

BookCheckout

book_id (foreign key to Book table)
customer_id (foreign key to Customer table)
checkout_date
due_date
return_date

Relationships:

Book to Author (one-to-many)
Book to Customer (many-to-many)
Customer to BookCheckout (one-to-many)

Keys and Constraints:

Primary keys:
- book_id (Book table)
- author_id (Author table)
- customer_id (Customer table)
Foreign keys:
- author_id (Book table) -> author_id (Author table)
- book_id (BookCheckout table) -> book_id (Book table)
- customer_id (BookCheckout table) -> customer_id (Customer table)
Constraints:
- A book cannot have more than one checkout record at a time.
- A customer cannot check out more than one copy of the same book at a time.

Expert Solution

Step 1: Introduction

This qus is from the subject SQL . Here we have to put light on the three important type of queries. These queries will be based on all Table creation, putting constraints as per the given instructions and inserting values into the created tables. All this work is done in the following steps.

Step by step

Solved in 3 steps with 1 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