Question: Create a databse for the below application using MySQL and upload the sql file that shows create and insert statements for the tables: A small

Create a databse for the below application using MySQL and upload the sql file that shows create and insert statements for the tables:

A small accounting firm wants a simple HR application that will help it to keep track of its employees, their positions, office locations, salary scales, and which company vehicles their employees drive. The application must keep track of all the positions at the firm, the employees filling these positions, the offices for these positions which may have more than one employee, the salary scales for these positions, and the company vehicles assigned to these positions.

Hint: There are seven tables in the solution. For each entity, there is a table. Take a look at the last sentence for 5 entities. when there are many to many relationships, we need bridge tables.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!