Question: A local bookstore invites you to design a database system for them based on the following requirements. Basic Requirements Books information includes book name, authors,
A local bookstore invites you to design a database system for them based on the following requirements.
Basic Requirements
-
Books information includes book name, authors, book type, price, and units in inventory.
-
One book will only have one book type. One book type can contain many books.
-
The store has different areas to organize different types of books. One book type can only be located in one area. One area can contain many book types.
-
A membership system, with customers information including name, phone number, balance, ...
-
Customers can search books by an author's name. However, one book may have multiple authors.
-
An invoice system, a customer can buy more than one books at one time.
Please design a database for this bookstore. Draw the ERD. (You may need to add necessary attributes.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
