Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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

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

Oracle 12c: SQL
Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter12: Subqueries And Merge Statements
Section: Chapter Questions
Problem 19MC
See similar textbooks
icon
Related questions
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
steps

Step by step

Solved in 3 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Single Table
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
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS