You are an IT Manager of a large team of highly skilled analysts, programmers, and support personnel. You need to manage the assignment of these skilled employees to various projects, and your highly skilled employees are often assigned to support several projects simultaneously. You would like to create a database to help manage their assignment to various company projects. There are many-to-many relationships between Employees, Skills, and Projects. These many-to-many relationships could be decomposed as follows: Each Employee has one-to-many Skills and each Skill is associated with one-to-many Employees. Each Project requires one to many Employees and each Employee is assigned to one-to-many Projects. Each Project requires one-to-many Skills and each Skill is needed for one-to-many Projects. Assume the following fields are required at a minimum for each of the primary RDBMS tables: Tasks: Using the table attached 1. Draw a decomposed ERD based on the above business rules 2. Convert the ERD into a normalized table design to illustrate how the one-to-many relationships would be implemented in an RDBMS to help manage the assignment of employee responsibilities to various projects.
You are an IT Manager of a large team of highly skilled analysts, programmers, and support personnel. You need to manage the assignment of these skilled employees to various projects, and your highly skilled employees are often assigned to support several projects simultaneously. You would like to create a
Tasks:
Using the table attached
1. Draw a decomposed ERD based on the above business rules
2. Convert the ERD into a normalized table design to illustrate how the one-to-many relationships would be implemented in an RDBMS to help manage the assignment of employee responsibilities to various projects.
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 3 images
