Given the following entity and business rules, normalize to 3NF PROJECT (project_number, project_name, customer#, customer_name, project...

 

Transcribed Image Text:

Given the following entity and business rules, normalize to 3NF PROJECT (project_number, project_name, customer#, customer_name, project manager, years experience, start_date, estimated_duration) Business Rules: i A project manager may manage more than one project but a project may only have one manager. ii. A customer may have more than one project contracted with the company. Each project manager has a number of years of experience. Given the following entity and business rules, normalize to 3NF PROJECT (project_number, project_name, customer#, customer_name, project manager, years experience, start_date, estimated_duration) Business Rules: i A project manager may manage more than one project but a project may only have one manager. ii. A customer may have more than one project contracted with the company. Each project manager has a number of years of experience.