Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

CS420 Database Design

Requirement

In this assignment, you are designing an online bookstore database. The storekeeper wants to record the publishers, books and buyer. For each publisher, the storekeeper records the email address, phone number and book genres. For each book the storekeeper records the ISBN, book title, authors and price. For each buyer the storekeeper records the name, phone number, and purchase amount in total.

Note that the storekeeper doesn’t want to record which book is bought by which buyer. You should to drow an E-R diagrams to demonstrate your database design.