No many to many relationships!

3. Design a database to help a consulting organization keep track of the amount of time an employee spends working on a contract. While working each day, each employee completes an online timesheet that looks like this: Name Tristan Elliott Date 2/5/2021 Employee ID 3411 Contract ID Type of Work Description Time Start Minutes Worked 444 Python Programming SAM 180 444 Tableau Report Generation 11 AM 240 777 Tableau Report Generation 4PM 120 The data stored for this application is shown on the next page. The first three rows on the data shown on the next page represents the timesheet above. The organization wants to keep track of the data at the detailed level shown on the spreadsheet. For each employee, the organization keeps track of a unique Employee ID, as well as a first name and last name, office phone number, hourly billing rate and the employee ID for the manager of that employee (managerID). For each contract, the organization keeps track of a unique ContractID, the date the contract was signed and the date it is due as well as the employee ID of the employee who serves as the manager for the contract. Every time an employee records work on the time sheet, the employee must record the contract related to that work, the type of work that was performed (type of work description above) the start time and the number of minutes worked. Here are some business rules about the application: An employee might work on many contracts, and a contract might have many employees working on it. An employee may work on more than one contract during a given day. A contract might have more than one employees working on it at any point in time. Each time an employee works on a contract, the employee must record a description of the type of work that was done on that contract. The work descriptions are standard across all employees in the organization. Examples of a work description include: "Java Programming," "Tableau Report Generation," "Database Design," and "SQL Programming." There are many different work description values but they are standardized across the organization so that employees can select a description of the type of work performed when entering their timesheet data. A given employee may be able to perform many different types of work description", and a type of work description may be able to be performed by many employees. An employee has a standard hourly billing rate. Each type of work has a standard billing rate (called Std Bill Rate" on the spreadsheet on the next page). The employee's billing rate and the standard billing rate for a type of work do not have to be the same. Each employee has only one manager, but a manager may manage multiple employees. An employee does not have to have a manager. A contract has only one manager. Each contract must have one manager. An employee does not have to manage a contract, but if an employee manages a contract, the employee manages only one contract. Managers are also employees of the consulting organization. Consider a manager as just another employee. A contract might also have an employee who serves as the person who sells the contract. It is possible that no employee sold a given contract. An employee may serve as the seller for more than one contract. This data is not included in the spreadsheet on the next page, but it is a business rule that should be included in the database. Sample data stored: Employee Work Date Last Name Time Description First Name Manager Office ID Phone Hourly Work Billing Type Rate ID Std Bill Rate Minutes Contract Worked ID Date Contract Signed Date Contract Due Contract Manager ID ID 3411 Tristan Elliott 4522 7753446558 $35 451 Python Programming $75 180 444 2021-02-05 08:00:00 02/17/2021 7819 2021-01-12 00:00:00 3411 Tristan Elliott 4522 7753446558 $35 3 Tableau Report Generation $60 240 444 2/5/2021 11:00 02/17/2021 7819 2021-01-12 00:00:00 3411 Tristan Elliott 4522 7753446558 $35 Tableau Report Generation $60 2/5/2021 16:00 120 777 4522 2021-01-08 00:00:00 03/30/2021 3424 Charles 4522 7754665991 $40 451 2021-02-02 Polanski 08:00:00 Python Programming $75 480 444 02/17/2021 7819 2021-01-12 00:00:00 3424 Charles 4522 7754665991 $40 3 Tableau Report Generation $60 180 2021-02-05 Polanski 14:00:00 02/17/2021 7819 444 2021-01-12 00:00:00 777 2021-01-08 00:00:00 3424 Polanski Charles 4522 7754665991 $40 3 Tableau Report Generation $60 2021-02-02 08:00:00 480 3/30/2021 4522 4522 Martin 1619 8056448777 S50 255 $155 120 888 04/15/2021 1227 Vendor Investigation/Procurement 2021-01-02 00:00:00 7819 Jenicia 1619 7754881222 $85 $285 180 444 02/17/2021 7819 2021-01-12 00:00:00 2021-01-27 Jenkins 15:00:00 2021-02-05 Martinez 8:00:00 2021-01-29 Martinez 10:00:00 2021-01-05 Matsumoto 7:00:00 7819 Jenicia 1619 7754881222 $85 $285 60 777 03/30/2021 4522 455 Strategic Analysis and Planning 455 Strategic Analysis and Planning 255 Vendor Investigation Procurement 2021-01-08 00:00:00 2021-01-12 00:00:00 1619 Haruko null 8582219001 $125 $155 240 444 02/17/2021 7819 3. Design a database to help a consulting organization keep track of the amount of time an employee spends working on a contract. While working each day, each employee completes an online timesheet that looks like this: Name Tristan Elliott Date 2/5/2021 Employee ID 3411 Contract ID Type of Work Description Time Start Minutes Worked 444 Python Programming SAM 180 444 Tableau Report Generation 11 AM 240 777 Tableau Report Generation 4PM 120 The data stored for this application is shown on the next page. The first three rows on the data shown on the next page represents the timesheet above. The organization wants to keep track of the data at the detailed level shown on the spreadsheet. For each employee, the organization keeps track of a unique Employee ID, as well as a first name and last name, office phone number, hourly billing rate and the employee ID for the manager of that employee (managerID). For each contract, the organization keeps track of a unique ContractID, the date the contract was signed and the date it is due as well as the employee ID of the employee who serves as the manager for the contract. Every time an employee records work on the time sheet, the employee must record the contract related to that work, the type of work that was performed (type of work description above) the start time and the number of minutes worked. Here are some business rules about the application: An employee might work on many contracts, and a contract might have many employees working on it. An employee may work on more than one contract during a given day. A contract might have more than one employees working on it at any point in time. Each time an employee works on a contract, the employee must record a description of the type of work that was done on that contract. The work descriptions are standard across all employees in the organization. Examples of a work description include: "Java Programming," "Tableau Report Generation," "Database Design," and "SQL Programming." There are many different work description values but they are standardized across the organization so that employees can select a description of the type of work performed when entering their timesheet data. A given employee may be able to perform many different types of work description", and a type of work description may be able to be performed by many employees. An employee has a standard hourly billing rate. Each type of work has a standard billing rate (called Std Bill Rate" on the spreadsheet on the next page). The employee's billing rate and the standard billing rate for a type of work do not have to be the same. Each employee has only one manager, but a manager may manage multiple employees. An employee does not have to have a manager. A contract has only one manager. Each contract must have one manager. An employee does not have to manage a contract, but if an employee manages a contract, the employee manages only one contract. Managers are also employees of the consulting organization. Consider a manager as just another employee. A contract might also have an employee who serves as the person who sells the contract. It is possible that no employee sold a given contract. An employee may serve as the seller for more than one contract. This data is not included in the spreadsheet on the next page, but it is a business rule that should be included in the database. Sample data stored: Employee Work Date Last Name Time Description First Name Manager Office ID Phone Hourly Work Billing Type Rate ID Std Bill Rate Minutes Contract Worked ID Date Contract Signed Date Contract Due Contract Manager ID ID 3411 Tristan Elliott 4522 7753446558 $35 451 Python Programming $75 180 444 2021-02-05 08:00:00 02/17/2021 7819 2021-01-12 00:00:00 3411 Tristan Elliott 4522 7753446558 $35 3 Tableau Report Generation $60 240 444 2/5/2021 11:00 02/17/2021 7819 2021-01-12 00:00:00 3411 Tristan Elliott 4522 7753446558 $35 Tableau Report Generation $60 2/5/2021 16:00 120 777 4522 2021-01-08 00:00:00 03/30/2021 3424 Charles 4522 7754665991 $40 451 2021-02-02 Polanski 08:00:00 Python Programming $75 480 444 02/17/2021 7819 2021-01-12 00:00:00 3424 Charles 4522 7754665991 $40 3 Tableau Report Generation $60 180 2021-02-05 Polanski 14:00:00 02/17/2021 7819 444 2021-01-12 00:00:00 777 2021-01-08 00:00:00 3424 Polanski Charles 4522 7754665991 $40 3 Tableau Report Generation $60 2021-02-02 08:00:00 480 3/30/2021 4522 4522 Martin 1619 8056448777 S50 255 $155 120 888 04/15/2021 1227 Vendor Investigation/Procurement 2021-01-02 00:00:00 7819 Jenicia 1619 7754881222 $85 $285 180 444 02/17/2021 7819 2021-01-12 00:00:00 2021-01-27 Jenkins 15:00:00 2021-02-05 Martinez 8:00:00 2021-01-29 Martinez 10:00:00 2021-01-05 Matsumoto 7:00:00 7819 Jenicia 1619 7754881222 $85 $285 60 777 03/30/2021 4522 455 Strategic Analysis and Planning 455 Strategic Analysis and Planning 255 Vendor Investigation Procurement 2021-01-08 00:00:00 2021-01-12 00:00:00 1619 Haruko null 8582219001 $125 $155 240 444 02/17/2021 7819