Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 database

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle 12c SQL

Authors: Joan Casteel

3rd edition

1305251032, 978-1305251038

More Books

Students also viewed these Databases questions

Question

4. What advice would you give to Carol Sullivan-Diaz?

Answered: 1 week ago