1. Extend the ERD from the attached ERD 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:

 

 

project_id project_n pw_wp_id pw_login ps_wp_id ps_login
1 Test Projec
2 rjones
2 rjones
1 Test Projec
7 testw
2 rjones
1 Test Projec
4 rdjones
2 rjones
1 Test Projec
3 rkjones
2 rjones
1 Test Projec
11 trythis
2 rjones
1 Test Projec
6 rnjones
2 rjones
1 Test Projec
5 rmjones
2 rjones
1 Test Projec
2 rjones
3 rkjones
1 Test Projec
7 testw
3 rkjones
1 Test Projec
4 rdjones
3 rkjones
1 Test Projec
3 rkjones
3 rkjones
1 Test Projec
11 trythis
3 rkjones
1 Test Projec
6 rnjones
3 rkjones
1 Test Projec
5 rmjones
3 rkjones
1 Test Projec
2 rjones
4 rdjones
1 Test Projec
7 testw
4 rdjones
1 Test Projec
4 rdjones
4 rdjones
1 Test Projec
3 rkjones
4 rdjones
1 Test Projec
11 trythis
4 rdjones
1 Test Projec
6 rnjones
4 rdjones
1 Test Projec
5 rmjones
4 rdjones
1 Test Projec
2 rjones
5 rmjones
1 Test Projec
7 testw
5 rmjones
1 Test Projec
4 rdjones
5 rmjones
1 Test Projec
3 rkjones
5 rmjones
1 Test Projec
11 trythis
5 rmjones
1 Test Projec
6 rnjones
5 rmjones
1 Test Projec
5 rmjones
5 rmjones
1 Test Projec
2 rjones
6 rnjones
1 Test Projec
7 testw
6 rnjones
1 Test Projec
4 rdjones
6 rnjones
1 Test Projec
3 rkjones
6 rnjones
1 Test Projec
11 trythis
6 rnjones
1 Test Projec
6 rnjones
6 rnjones
1 Test Projec
5 rmjones
6 rnjones
3 Test Adding
2 rjones
3 rkjones
3 Test Adding
7 testw
3 rkjones

 

project_id project_name
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
1 Test Project
3 Test Adding Ex
3 Test Adding Ex pw_wp_id pw_login ps_wp_id ps_login
2 jbellah
2 jbellah
7 testw
2 jbellah
4 jdbellah
2 jbellah
3 jkbellah
2 jbellah
11 trythis
2 jbellah
6 jnbellah
2 jbellah
5 jmbellah
2 jbellah
2 jbellah
3 jkbellah
7 testw
3 jkbellah
4 jdbellah
3 jkbellah
3 jkbellah
3 jkbellah
11 trythis
3 jkbellah
6 jnbellah
3 jkbellah
5 jmbellah
3 jkbellah
2 jbellah
4 jdbellah
7 testw
4 jdbellah
4 jdbellah
4 jdbellah
3 jkbellah
4 jdbellah
11 trythis
4 jdbellah
6 jnbellah
4 jdbellah
5 jmbellah
4 jdbellah
2 jbellah
5 jmbellah
7 testw
5 jmbellah
4 jdbellah
5 jmbellah
3 jkbellah
5 jmbellah
11 trythis
5 jmbellah
6 jnbellah
5 jmbellah
5 jmbellah
5 jmbellah
2 jbellah
6 jnbellah
7 testw
6 jnbellah
4 jdbellah
6 jnbellah
3 jkbellah
6 jnbellah
11 trythis
6 jnbellah
6 jnbellah
6 jnbellah
5 jmbellah
6 jnbellah
2 jbellah
3 jkbellah
7 testw
3 jkbellah

Attachments:

• 1493695858-HW3_data.xlsx