• Create a logical database design for the construction company data in the attached Excel file.
• Your logical design must be in Third Normal Form (3NF).
• 
• example

PROJ_NUM PROJ_NAME Evergreen 15 Amber Wave 22 Rolling Tide 105 EMP_NUM EMP_NAME JOB_CLASS CHG_HOUR HOURS 103 June E. Arbough Elect. Engineer 84.5 23.8 101 John G. News Database Designer 105 19.4 105 Alice K. Johnson Database Designer 105 35.7 106 William Smithfield Programmer 35.75 12.6 102 David H. Senior Systems Analyst 96.75 23.8 114 Annelise Jones Applications Designer 48.1 24.6 118 James J. Frommer General Support 18.36 45.3 104 Anne K. Ramoras Systems Analyst 96.75 32.4 112 Darlene M. Smithson DSS Analyst 45.95 44 Alice K. Johnson Database Designer 105 64.7 104 Anne K. Ramoras Systems Analyst 96.75 48.4 113 Delbert K. Joenbrood Applications Designer 48.1 23.6 111 Geoff B. Wabash Clerical Support 26.87 22 106 William Smithfield Programmer 35.75 12.8 107 Maria D. Alonzo Programmer 35.75 24.6 115 Travis B. Bawangi Systems Analyst 96.75 45.8 101 John G. News Database Designer 105 56.3 114 Annelise Jones Applications Designer 48.1 33.1 108 Ralph B. Washington Systems Analyst 96.75 23.6 118 James J. Frommer General Support 18.36 30.5 112 Darlene M. Smithson DSS Analyst 45.95 41.4 1283318237333933333 25 Starflight NOT NULL, NOT NULL, CREATE TABLE Customer_T (CustomerID NUMBER(11,0) CustomerName VARCHAR2(25) CustomerAddress VARCHAR2(30), CustomerCity VARCHAR2(20), Customer State CHAR(2), Customer PostalCode VARCHAR2(9), CONSTRAINT Customer_PK PRIMARY KEY (CustomerID)); CREATE TABLE Order_1 (OrderID NUMBER(11,0) NOT NULL, OrderDate DATE DEFAULT SYSDATE, CustomerID NUMBER(11,0), CONSTRAINT Order_PK PRIMARY KEY (OrderID), CONSTRAINT Order_FK FOREIGN KEY (CustomerID) REFERENCES Customer_T (CustomerlD)); NOT NULL, CREATE TABLE Product_T (ProductID NUMBER(11,0) ProductDescription VARCHAR2(50), ProductFinish VARCHAR2(20), Product Standard Price DECIMAL(6,2), ProductLineID NUMBER(11,0), CONSTRAINT Product_PK PRIMARY KEY (ProductID)); CREATE TABLE OrderLine_T (OrderID NUMBER(11,0) NOT NULL, ProductID NUMBER(11,0 NOT NULL, Ordered Quantity NUMBER(11,0) CONSTRAINT OrderLine_PK PRIMARY KEY (OrderID, ProductID), CONSTRAINT OrderLine_FK1 FOREIGN KEY (OrderID) REFERENCES Order_T (Order|D), CONSTRAINT OrderLine_FK2 FOREIGN KEY (ProductID) REFERENCES Product_T (ProductID)); PROJ_NUM PROJ_NAME Evergreen 15 Amber Wave 22 Rolling Tide 105 EMP_NUM EMP_NAME JOB_CLASS CHG_HOUR HOURS 103 June E. Arbough Elect. Engineer 84.5 23.8 101 John G. News Database Designer 105 19.4 105 Alice K. Johnson Database Designer 105 35.7 106 William Smithfield Programmer 35.75 12.6 102 David H. Senior Systems Analyst 96.75 23.8 114 Annelise Jones Applications Designer 48.1 24.6 118 James J. Frommer General Support 18.36 45.3 104 Anne K. Ramoras Systems Analyst 96.75 32.4 112 Darlene M. Smithson DSS Analyst 45.95 44 Alice K. Johnson Database Designer 105 64.7 104 Anne K. Ramoras Systems Analyst 96.75 48.4 113 Delbert K. Joenbrood Applications Designer 48.1 23.6 111 Geoff B. Wabash Clerical Support 26.87 22 106 William Smithfield Programmer 35.75 12.8 107 Maria D. Alonzo Programmer 35.75 24.6 115 Travis B. Bawangi Systems Analyst 96.75 45.8 101 John G. News Database Designer 105 56.3 114 Annelise Jones Applications Designer 48.1 33.1 108 Ralph B. Washington Systems Analyst 96.75 23.6 118 James J. Frommer General Support 18.36 30.5 112 Darlene M. Smithson DSS Analyst 45.95 41.4 1283318237333933333 25 Starflight NOT NULL, NOT NULL, CREATE TABLE Customer_T (CustomerID NUMBER(11,0) CustomerName VARCHAR2(25) CustomerAddress VARCHAR2(30), CustomerCity VARCHAR2(20), Customer State CHAR(2), Customer PostalCode VARCHAR2(9), CONSTRAINT Customer_PK PRIMARY KEY (CustomerID)); CREATE TABLE Order_1 (OrderID NUMBER(11,0) NOT NULL, OrderDate DATE DEFAULT SYSDATE, CustomerID NUMBER(11,0), CONSTRAINT Order_PK PRIMARY KEY (OrderID), CONSTRAINT Order_FK FOREIGN KEY (CustomerID) REFERENCES Customer_T (CustomerlD)); NOT NULL, CREATE TABLE Product_T (ProductID NUMBER(11,0) ProductDescription VARCHAR2(50), ProductFinish VARCHAR2(20), Product Standard Price DECIMAL(6,2), ProductLineID NUMBER(11,0), CONSTRAINT Product_PK PRIMARY KEY (ProductID)); CREATE TABLE OrderLine_T (OrderID NUMBER(11,0) NOT NULL, ProductID NUMBER(11,0 NOT NULL, Ordered Quantity NUMBER(11,0) CONSTRAINT OrderLine_PK PRIMARY KEY (OrderID, ProductID), CONSTRAINT OrderLine_FK1 FOREIGN KEY (OrderID) REFERENCES Order_T (Order|D), CONSTRAINT OrderLine_FK2 FOREIGN KEY (ProductID) REFERENCES Product_T (ProductID))