Bluewater Construction Company Consider the simplified database activities of a construction company that manages several building projects. Each project has its own project number, name, assigned employees, and so on. Each employee has an employee number, name, and job classification, such as engineer or computer technician. The company charges its clients by billing the hours spent on each contract. The hourly billing rate is dependent on the employee's position. For example, one hour of computer technician time is billed at a different rate than one hour of engineer time. Periodically, a report is generated that contains the information displayed in Figure 1. Complete the following: 1. Create an un-normalized tabular format (flat spreadsheet-like table) from the report format 2. Convert to 1NF: a. Each cell contains a single value b. Identify the primary key 3. Convert to 2NF: a. Identify the partial dependencies b. Convert tables to 2NF (table form and relational schema) by eliminating partial dependencies 4. Convert to 3NF: a. Identify the transitive dependencies b. Convert tables to 3NF (table form and relational schema) by eliminating transitive dependencies