The final project consists of a Database related to the midterm and the midterm is attached below.
Database
For this project, 1) your team must design a CHEN ERD model, 2)a data dictionary, and 3) an Access database for a necessary business process in your company. Select a business process from unit 1, e.g. sales, placing an order, or handling reservations, among others.
Your database must have:
- as many entities as necessary to carry out your process.
- At least 20 records in each entity.
- At least 30 transactions (sales, orders, reservations, or whatever business process you are focusing on).
- Forms for all your entities related to objects (people, places, items, etc.).
a. Include 4 buttons in each form (add record, delete record, next, and previous.
- 2 Queries (one for individual transactions and one for the sum of all transactions).
- 2 Reports (one for transaction receipts and one for the sum of all transactions).
