Jess, the owner of the Best Deal Bookstore has given you several sample reports…
Jess, the owner of the Best Deal Bookstore has given you several sample reports that contain information about the books she has in her inventory. She wants your database to be able to generate these reports and customer receipts. (Reports included in packet —reverse engineering — use to create dependency diagrams)
The Best Deal Bookstore database must also store data about its customers, in particular, a customer’s name, address, city, state, zip code, and email. A customer may buy several copies of any book in inventory, if it is available. The store front will need forms that add, update or delete customer and book data. It will also need the functionality to allow customers to purchase books. At the very least, for every customer transaction, the database needs to store the sales date, the price of each book and total price of all books sold along with payment data.