Assume that we are designing a database for a company to track the assignment of employees...

Transcribed Image Text:

Assume that we are designing a database for a company to track the assignment of employees to projects, The business requirements are as follows. Departments will initiate and own various projects. It is possible that a department does not initiate and own any project, but one department could also possibly have one or many projects. Each project needs to be owned by at least one department, but it is also possible that a project is jointly owned by many departments. Employees are affiliated with departments. Each employee belongs to one and only one department, and each department must have at least one employee, although usually it has many. Employees will be assigned to different projects. A given project could have zero or more employees assigned, but each employee can be assigned to at most one project, and it is possible that an employee has not been assigned to any project. Draw the E-R diagram of your data model based on the description above. The attributes that need to be captured about each entity are listed below, with identifiers underlined. • DEPARTMENT (DepartmentName, BudgetCode, OfficeNumber, Phone) EMPLOYEE (EmployeeID, FirstName, LastName, Phone, Email) PROJECT (ProjectID, Name, MaxHours, StartDate, EndDate) . . Assume that we are designing a database for a company to track the assignment of employees to projects, The business requirements are as follows. Departments will initiate and own various projects. It is possible that a department does not initiate and own any project, but one department could also possibly have one or many projects. Each project needs to be owned by at least one department, but it is also possible that a project is jointly owned by many departments. Employees are affiliated with departments. Each employee belongs to one and only one department, and each department must have at least one employee, although usually it has many. Employees will be assigned to different projects. A given project could have zero or more employees assigned, but each employee can be assigned to at most one project, and it is possible that an employee has not been assigned to any project. Draw the E-R diagram of your data model based on the description above. The attributes that need to be captured about each entity are listed below, with identifiers underlined. • DEPARTMENT (DepartmentName, BudgetCode, OfficeNumber, Phone) EMPLOYEE (EmployeeID, FirstName, LastName, Phone, Email) PROJECT (ProjectID, Name, MaxHours, StartDate, EndDate) . .

Answer rating: 100% (QA)

To create an EntityRelationship ER diagram based on the given business requirements and attributes we need to identify the entities their attributes a... View the full answer