Answered step by step
Verified Expert Solution
Question
1 Approved Answer
draw ER diagram using below info plz The database keeps information about comic books, customers, orders, inventory and reviews. First, the database should include information
draw ER diagram using below info plz
The database keeps information about comic books, customers, orders, inventory and reviews. First, the database should include information about all comic books available at the store. In addition to a unique id, each book has a title, publisher, issue number, cover price and one or more authors who authored the comic. You can assume the ids of books and authors are unique. Each series of books has a name and consists of one or more comic books (also referred to as issues). The comics in a series are ordered. The database must keep track of the store's inventory of comics, including the number of copies of each book in stock and the location of those copies in the store. It is always possible to find all copies of the same book on a single shelf. Each customer has a customer id and a full name. Customers can make orders, and each order has a date and includes one or more comic books. Each order belongs to a single customer. Orders must be kept on file even when a customer's data is not available anymore. Customers can review comic books. Each review can be made public or private. Each review has a date, number of stars (1 to 5), title and detailed description. The system must ensure that the customer really bought the comic book they reviewed, so each review must have a corresponding order. After a new review is added, an average rating for the reviewed comic book is recalculated and stored in the databaseStep 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