Operation Mangment

Access Assignment #1: It’s A Grind Coffee.

1. Create the tables from the data given. (Hint: there should be 5 tables)

2. Create the E-R diagram with the tables that you have created.

3. Create the relationships for the table. (Hint: All relationships are 1 to many)

a. For relationships: referential integrity should be enforced.

4. You can enter the data into the database in three different ways:

a. Manually enter data using the datasheet view

b. Create a form to enter data and add button controls for navigation

c. Import data from an external Excel file.

5. Create a new column called “Book Revenue” and have this column calculate the revenue from the sales.