Use Acccess DB to create a set of tables that can support Common Workgroup Process shown in Figure 7-3 for...

Use Acccess DB to create a set of tables that can support Common Workgroup Process shown in Figure 7-3 for the

a. Sales and Marketing Department (excluding the forecasting function)

b. Operations Department

Each table design must have field definitions, data types and descriptions (on what is the purpose of the field.)

Observe and list the relationships between the tables.

Limit the number of the tables (e.g., 3 to 6 tables) and the number of field in each table (e.g., 5 - 8).

HINT: A minimal table design for this homework may support the state and context of a sales process (e.g., time, location, customer, salesReps, state of the customer engagement, product for sale, order entry, and product inventory, etc.). Product specifications or promotional materials may be defined using "attachment" or "hyperlink" as data types.

Queries:
Next quarter sales revenue forecast (based on probability multiplied by revenue) by customer
Quarterly sales v.s. target by department. For example, 80% of $600K for July for shoe department and 95% of $650K for Aug. for the sports goods department etc.. Add planned sales target and department fields as needed.