Question: The Comer Bookstore - Associative (50 Points) The Comer Bookstore is an online bookstore in Norman, Oklahoma. They sell a broad portfolio of their books

 The Comer Bookstore - Associative (50 Points) The Comer Bookstore is

The Comer Bookstore - Associative (50 Points) The Comer Bookstore is an online bookstore in Norman, Oklahoma. They sell a broad portfolio of their books to their valued customers. The bookstore would like you to draw and ERD diagram that depicts their book sales process. The bookstore would like to keep track information about the publishers that provide them with their books. The publishers can sell many different books, but a book can only be printed by one publisher. Customers are encouraged to purchase many books, and many books can be purchased by many different customers. The store would like to track the information concerning each time (sale) one of the many books in the store are purchased by one the bookstores many customers. The bookstore would like to keep track of the following publisher information to include publisher company name, publisher company address (street, city, state, and zip), publisher sales representative first name, publisher sales representative last name, publisher sales representative phone number, and publisher sales representative email address. The bookstore would like you to keep track of the following book information to include book title, book publication date, book author (first name and last name), and book price. The bookstore would like you to keep track of the following book infonnation to include customer name (first name, middle initial, and last name), customer address (street, city, state, and zip code), customer's credit card company name, customer's credit card number, customer's credit card expiration date, and credit eard security code. Finally, the bookstore would like to keep track of the following customer book purchases (sales) information to include the sale date and the sale quantity. REMOVE THIS TEXT AND PLACE YOUR DLAGRAM HERE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!