Draw an ERD for the following problem: Company organized into departments. Each department has unique, name and a particular employee who manages the department. Start date for the manager is recorded. Department may have several locations. A department controls a number of projects. Projects have a unique name, number and a single location. Company’s employees name, ssno, address, salary, sex and birth date are recorded. An employee is assigned to one department, but may work for several projects (not necessarily controlled by her dept). Number of hours/week an employee works on each project is recorded; the immediate Supervisor for the employee. Employee’s dependents are tracked for health insurance purposes (dependent name, birthdate, relationship to employee).
Draw an ERD for the following problem:
Company organized into departments. Each department has unique, name and a particular
employee who manages the department. Start date for the manager is recorded. Department may
have several locations. A department controls a number of projects. Projects have a unique name,
number and a single location. Company’s employees name, ssno, address, salary, sex and birth
date are recorded. An employee is assigned to one department, but may work for several projects
(not necessarily controlled by her dept). Number of hours/week an employee works on each project
is recorded; the immediate Supervisor for the employee. Employee’s dependents are tracked for
health insurance purposes (dependent name, birthdate, relationship to employee).
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
