Problem 1: The database should record sales and returns for a bookstore. Draw an
ID: 644706 • Letter: P
Question
Problem 1: The database should record sales and returns for a bookstore. Draw an ERD that represent information requirements as stated or implied by the following descriptions: The following information about each book should be stored: ISBN, cover type (hard cover or soft cover), current price, # of pages, publication year, category, #of copies in store. ISBNs are unique, that is, two books with the same ISBN are identical in every way (as far as the database is concerned.) A customer can purchase multiple books (multiple copies of the same book or different books). (Even though database needs to store quantity of each ISBN sold, we?ll leave this requirement out for this assignment.) Database should store date/time of purchase, total dollar amount, payment method, and amount paid. When a customer returns one or more books purchased, a record is created for each physical book returned. Date/time of the return should be recorded. Of course, a customer can only return a book that was previously purchased from the bookstore.Explanation / Answer
Answer:
ERD Diagram for stated Description:
Relational Database:
For one-to-many relationships: add the key field in the