Consider the COMPANY database which keeps track of a company’s employees, departments, and projects: • The company is organized into departments. Each department has a unique name, a unique number and a particular employee that manages the department. • A department controls a number of projects, each of which has a unique name and unique number. • We store each employee’s name, a national card ID, address, salary, and birth date. An employee is assigned to one department but may work on several projects, which are not controlled by the same department. We keep track of the number of hours per week that the employee works on each project. A project may involve more than one employee. • We want to keep track of the dependents of each employee for Insurance purposes. We keep each dependent’s first name, birth date and relationship to the employee. Answer the following questions about the COMPANY database. State clearly any assumptions that you may make. Draw the entity relationship diagram for the COMPANY database showing all entities, primary keys and weak entities.
Consider the COMPANY
employees, departments, and projects:
• The company is organized into departments. Each department
has a unique name, a unique number and a particular employee
that manages the department.
• A department controls a number of projects, each of which has a
unique name and unique number.
• We store each employee’s name, a national card ID, address,
salary, and birth date. An employee is assigned to one
department but may work on several projects, which are not
controlled by the same department. We keep track of the number
of hours per week that the employee works on each project. A
project may involve more than one employee.
• We want to keep track of the dependents of each employee for
Insurance purposes. We keep each dependent’s first name, birth
date and relationship to the employee.
Answer the following questions about the COMPANY database.
State clearly any assumptions that you may make.
Draw the entity relationship diagram for the COMPANY database showing
all entities, primary keys and weak entities.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
