Question
Chegg.com wants to store data about customers and hard copy rental books. Customer data should include first and last names, street address, city, state, ZIP
Chegg.com wants to store data about customers and hard copy rental books. Customer data should include first and last names, street address, city, state, ZIP code, phone number and customer number. Book data should include the title, ISBN, book_id (iprimary key), and the publication date. Books can have multiple authors, and authors can write many books. Data about authors should include their first, last, and middle names, their birth dates, and their death dates, if needed. Customers rent books using their customer number. Each time a book is rented, the rental date and the rental expiration date need to be stored. Customers can rent many books, and books can be rented by many customers, though not at the same time.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started