Access Assignment - Rose Bookstore
1. Description
A small bookstore - Rose Bookstore -- mainly sells books to customers by telephone, fax, or email. The store keeps track of the business information by paper (please see the forms attached). To reduce the workload and enhance the competitive in market, the owner decided to investigate the possibility of automating some of the record keeping activities of the bookstore. The intention is to increase the efficiency of the staff, and make data-driven decisions.
2. The Requirements of Rose Bookstore
Track current inventory
Track customers
Track orders and invoices
Generate (business intelligence) reports
3. Information System Development
You are required to develop a database application for use by the bookstore staff. The application should have standardized interface, and be easy to use.
Reports:
- Invoice
- Book sale summary report
- Book sale detail report by ISBN
- Customer purchase report by Customer No
- Profit report grouped by publishers, by order types, and by categories
Profit report grouped by publisher:
Profit report grouped by order type and category are similar to the profit report grouped by publisher.
Read the attached lectures Files and to understand the assignment.
Attachment:- Lectures.rar
Attachment:- Assignment File.rar