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.
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.
14 freelancers estão ofertando em média $46 para este trabalho
Hi, I can do this job for you. I am an experienced professional. If interested in hiring me then please let me know so that we finalize the assignment scope. Regards, Jawad
Let expert do this I am an expert Database Administrator. Plz let me do this [url removed, login to view] [url removed, login to view] [url removed, login to view]