Question: Please design a database for this bookstore. Draw the ERD. (You may need to add necessary attributes.) 1. Books information includes book name, authors, book
Please design a database for this bookstore. Draw the ERD. (You may need to add necessary attributes.)
1. Books information includes book name, authors, book type, price, and units in inventory. 2. One book will only have one book type. One book type can contain many books. 3. 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. 4. A membership system, with customers information including name, phone number, balance, ... 5. Customers can search books by an author's name. However, one book may have multiple authors. 6. An invoice system, a customer can buy more than one books at one time.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
