Practice of ER modeling . Yong Choi School of Business CSUB. Practice 1. A department hires many employees . A employee is hired by one department. A manager manages one department. A department is managed by one manager. . Practice 2.
School of Business
NCFCComp would like to keep track of their employees, departments and projects. The company is organized into departments. Each department has a unique name, a unique number and a particular employee who manages the department. We keep track of the start date when that employee began managing the department. A department may have several locations. A department controls a number of projects, each ofwhich has a unique name, a unique number and a single location. We need to store each employee's name, social security number, address, salary, sex, and birth date.
An employee is assigned to one department but maywork on
several projects, which are not necessarilycontrolled by the same
department. We need to keeptrack of the number of hours per
week that anemployee works on each project. We also should
keeptrack of the direct supervisor of each employee. Forinsurance
purposes, we want to keep track of thedependents of each
employee. We keep eachdependent's name, sex, birth date, and