Assignment Instructions:

• 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).
• Document your logical design using SQL Create Table statements as shown in Figure 4-6 on page 162 of the textbook.

Save your completed logical design as either a .txt file or a PDF file. No credit will be given for drawing files submitted in other formats.

PROJ_NUM	PROJ_NAME	EMP_NUM	EMP_NAME	JOB_CLASS	CHG_HOUR	HOURS
15	Evergreen	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
18	Amber Wave	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
22	Rolling Tide	105	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
25	Starflight	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

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 (Customer D)); CREATE TABLE Order T (OrderID NUMBER(11,0) NOT NULL, Order Date DATE DEFAULT SYSDATE, CustomerlD 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), ProductStandard 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, Productin), CONSTRAINT OrderLine FK1 FOREIGN KEY (OrderID) REFERENCES Order_T (OrderID). CONSTRAINT OrderLine_FK2 FOREIGN KEY (ProductID) REFERENCES Product_T (ProductID))