Please see the attached questions. This question is the extension of the problem from the last problem that you helped me.

 

 

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 Cost
Estimated Start Date
Estimated End Date
Actual Cost Location Actual Start Date Location ID Actual End Date Customer ID Student RFID Reads Reader Location Student ID Read ID Location ID Foreman
Foreman ID Student Name Student ID Location Type Location ID Location Name Read Date Time
Direction
Driver Driver Schedule Driver ID Shift ID Driver Name Driver ID License Plate Number Location ID
Shift Date
Start Time
End Time Customer
Customer ID

 

1. Extend the ERD from Problem #1 on Homework 2 to include the following business
rules:
o ABC Construction wants to keep salary history for all employees. o 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. o Each sponsor can sponsor multiple projects over time. o An executive assistant enters all project information into the system. It is not
necessary in the system to record who entered the information. o Projects can have many purposes. ABC wants to classify them according to their
purpose: Commercial construction Residential construction 2. Create an ERD in third normal form (3NF) from the data in the following table:
project_i
d
1
1
1
1
1
1 project_nam
e
Test Project
Test Project
Test Project
Test Project
Test Project
Test Project 1 Test Project
1 Test Project
1 Test Project
1
1
1
1 Test Project
Test Project
Test Project
Test Project 1 Test Project
1 Test Project pw_wp_i
d
pw_login
2 rdsouza
7 testw
samfrant
4 a
3 yoyotsa
11 trythis
6 semiatty
rogerand
5 y
2 rdsouza
7 testw
samfrant
4 a
3 yoyotsa
11 trythis
6 semiatty
rogerand
5 y
2 rdsouza ps_wp_i
d
ps_login
2 rdsouza
2 rdsouza
2
2
2
2 rdsouza
rdsouza
rdsouza
rdsouza 2 rdsouza
3 yoyotsa
3 yoyotsa
3
3
3
3 yoyotsa
yoyotsa
yoyotsa
yoyotsa 3 yoyotsa
samfrant
4 a 1 Test Project 5
6
6 samfrant
a
samfrant
a
samfrant
a
samfrant
a
samfrant
a
samfrant
a
rogerand
y
rogerand
y
rogerand
y
rogerand
y
rogerand
y
rogerand
y
rogerand
y
semiatty
semiatty 6
6
6
6 semiatty
semiatty
semiatty
semiatty 4 1 Test Project 7 testw
samfrant
4 a 1 Test Project 3 yoyotsa 4 1 Test Project
1 Test Project 11 trythis 4 4
4 1 Test Project 6 semiatty
rogerand
5 y 1 Test Project 2 rdsouza 5 1 Test Project 5 1 Test Project 7 testw
samfrant
4 a 1 Test Project 3 yoyotsa 5 4 5 1 Test Project 11 trythis 5 1 Test Project 6 semiatty
rogerand
5 y
2 rdsouza
7 testw
samfrant
4 a
3 yoyotsa
11 trythis
6 semiatty
rogerand
5 y 5 1 Test Project
1 Test Project
1 Test Project
1
1
1
1 Test Project
Test Project
Test Project
Test Project 1 Test Project
Test Adding
3 Ex
Test Adding
3 Ex 6 semiatty 2 rdsouza 3 yoyotsa 7 testw 3 yoyotsa

Attachments:

• 1493703473-ABC Construction.pdf
• 1493703474-Extend the ERD from Problem.docx