Scenario:
Imagine you have been contracted to develop a system for processing data for an organization that sells household items and electronics. Just like any organization, there are departments such as IT, customer service, marketing, sales, payroll, accounts payable, and some sort of operations. Within each department, employees will have specific jobs (supervisor, administrative assistant, and janitor). All employees are paid a salary and benefits. The only exception is the sales department where employees are paid a commission as well. To calculate commission, this is the formula:
Employee’s commission rate = product commission amount X quantity sold.
Instructions:
For this assignment, you must create the entities and attributes via MySQL Workbench or SQL queries to model the above business case. Open MySQL Workbench and perform the following tasks:
- Create a schema with the appropriate entities and attributes to fit the scenario above.
- In your new database, add sufficient data for each of the entities and attributes – at least five departments with at least ten employees in each.
- Export your database to your computer. Be sure and select the option to “Export to Self-Contained File.”
- Run a SQL query to determine the total number of employees and take a screenshot of the query results.
- Run a SQL query for the sales department to determine the commissions paid to specific employees for the month of December and take a screenshot of the query results.
- Insert your screenshots into a Word document. Please be sure and label each of your screenshots in the document to show which part of the assignment each screenshot is supposed to fulfill. Also, please be sure and add a standard assignment title page at the beginning of your Word document.
