1. Extend the ERD from the attached ERD (chaos construction) to include the following business rules:

a. Chaos Construction wants to keep salary history for all employees.

b. They want to track another type of employee (besides foreman) who has a role in a project: each project has a sponsor, who is an executive in the company.

c. Each sponsor can sponsor multiple projects over time.

d. An executive assistant enters all project information into the system. It is not necessary in the system to record who entered the information.

e. Projects can have many purposes. Chaos wants to classify them according to their purpose:

f. Commercial construction

g. Residential construction

 

2. - Create an ERD in third normal form (3NF) from the data in the attached spreadsheet:

• 1500397656-data1.xlsx
• 1500397657-Chaos Construction.pdf

APlusGrades

Not Rated (0)

Status NEW Posted 18 Jul 2017 05:07 PM My Price 12.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I

Not Rated(0)

• Buy Answer