Activity Progress Report Activity ID Progress Report ID Project ID Project ID Estimated Cost Progress Report Date Estimated Start Date Objectives

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:

• Attachment 1
• Attachment 2

Activity Progress Report Activity ID Progress Report ID Project ID Project ID Estimated Cost Progress Report Date Estimated Start Date Objectives Completed Estimated End Date Project Work Planned Actual Cost Project ID Lessons Learned Actual Start Date Foreman ID Actual End Date Location ID Percent Complete Estimated CostEstimated Start DateEstimated End DateActual Cost Location Actual Start Date Location ID Actual End Date Customer ID Student RFID Reads Reader Location Student ID Read ID Location ID ForemanForeman ID Student Name Student ID Location Type Location ID Location Name Read Date TimeDirectionDriver Driver Schedule Driver ID Shift ID Driver Name Driver ID License Plate Number Location IDShift DateStart TimeEnd Time CustomerCustomer ID