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)

by


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:

  1. as many entities as necessary to carry out your process.
  2. At least 20 records in each entity.
  3. At least 30 transactions (sales, orders, reservations, or whatever business process you are focusing on).
  4. 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.

  1. 2 Queries (one for individual transactions and one for the sum of all transactions).
  2. 2 Reports (one for transaction receipts and one for the sum of all transactions).