MariaDB [tentaq6]> select from project_reportv1; +--. | ProjectNumber | ProjectName | EmployeeNumber | EmployeeName | JobClass | Charge_Per_Hour | HoursB1lled | TotalCharge | +- | Evergreen 103 | June...

Normalize this table to the third normal form

3NF

MariaDB [tentaq6]> select from project_reportv1;<br>+--.<br>| ProjectNumber | ProjectName | EmployeeNumber | EmployeeName<br>| JobClass<br>| Charge_Per_Hour | HoursB1lled | TotalCharge |<br>+-<br>| Evergreen<br>103 | June E. Arbough<br>101| John G. News<br>23.80 |<br>19.40 |<br>15<br>Elet. Engineer<br>Database Designer<br>84.50<br>2011.10<br>105.00<br>2037.00<br>2 rows in set (0.000 sec)<br>MariaDB [tentaq6]> .<br>

Extracted text: MariaDB [tentaq6]> select from project_reportv1; +--. | ProjectNumber | ProjectName | EmployeeNumber | EmployeeName | JobClass | Charge_Per_Hour | HoursB1lled | TotalCharge | +- | Evergreen 103 | June E. Arbough 101| John G. News 23.80 | 19.40 | 15 Elet. Engineer Database Designer 84.50 2011.10 105.00 2037.00 2 rows in set (0.000 sec) MariaDB [tentaq6]> .

Jun 02, 2022

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here