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

by


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..).
    1. Include 4 buttons in each form (add record, delete record, next, and previous).
  5. 2 Queries (one for individual transactions and one for the sum of all transactions).
  6. 2 Reports (one for transaction receipts and one for the sum of all transactions).