Project Assignments

Requirements
You are asked to create a relational model for the data that has information about: The following business rules must be considered:
 * Departments in an organization, such as department name and phone number,
 * Employees in each department, such as last name, first name, salary, status (whether full time or part time), and email, and
 * Projects on which the employees work, such as project name, start and end date, and budget.
 * 1) A department has at least one employee.
 * 2) An employee belongs to at most one department (or might not belong to any)
 * 3) An employee can work on more than one project.
 * 4) A project involves at least one employee (or more).

Design
Project Assignments UML class diagram

Back to CIS520 Class Notes