Homework answers / question archive / An ERD for the following scenario: Assume you are hired to design a database for Cyprus Online Book Shop

An ERD for the following scenario: Assume you are hired to design a database for Cyprus Online Book Shop

Computer Science

Share With

An ERD for the following scenario: Assume you are hired to design a database for Cyprus Online Book Shop. In the library there are many books. For each book, unique ISBN, title, page number, author and price must be kept. Books may belong to different categories. Some of the book types are textbook and novel. Additionally for textbooks keep track of the subject (e.g., mathematics, computer, science, etc.) and publisher name. Books may be the part or continuation of another book of the same type. Books are sold to zero or more customers, and a customer may buy zero or many books. The date and time that the book was sold to a customer must also be kept in the database. For each customer, unique customer id, name (first and last), address, date of birth (dob) and telephone number must be kept in the database. Customers (or any person who visits the website) may or may not make any comments about the books. For each book comment, keep comment number, description and the date comment made. Book comments can be identified by comment number and book id together. Clearly indicate multiplicities, cardinalities and primary keys in the ERD.