Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / You have been contracted to develop a system for processing data for an organization with several retail stores that sell household items, including furniture

You have been contracted to develop a system for processing data for an organization with several retail stores that sell household items, including furniture

Computer Science

You have been contracted to develop a system for processing data for an organization with several retail stores that sell household items, including furniture. Just like any organization, there are departments such as IT, customer service, marketing, sales, payroll, accounts payable, credit services, and some sort of operations. Within each department, employees have specific jobs (manager, administrative assistant, and associate). All employees are paid a salary and benefits. The only exception is the sales department, where sales representatives are paid a base salary plus commission, which is 20% of their sales.

Instructions:

For this assignment, you must create the entities and attributes via MySQL Workbench or SQL queries to model the business case in the scenario.

Open MySQL Workbench and perform the following tasks:

Create a schema with the appropriate entities and attributes to fit the scenario above.

Add sufficient data, within your new database, for each of the entities and attributes – at least five departments with at least 10 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 December and take a screenshot of the query results.

 

the following are the readings for this assignment

https://www.brainbell.com/tutorials/MySQL/Performi...

https://www.qhmit.com/mysql/tutorial/mysql_queries...

https://www.qhmit.com/sql/tutorial/sql_syntax.cfm

https://www.tutorialspoint.com/dbms/dbms_data_mode...

 

https://www.guru99.com/data-modelling-conceptual-l...

Option 1

Low Cost Option
Download this past answer in few clicks

18.89 USD

PURCHASE SOLUTION

Already member?


Option 2

Custom new solution created by our subject matter experts

GET A QUOTE