_Normilization_Example_2.txt

Business rules:
There are several departments in the company. Each department has a unique identification, a name, location
of the office and a particular employee who manages the department.
• A department controls a number of projects, each of which has a unique name, a unique number and
a budget.
• Each employee has a name, identification number, address, salary and birthdate. An employee is assigned to
one department but can join in several projects. We need to record the start date of the employee in each
project and the total hours worked. We also need to know the direct supervisor of each employee.
• We want to keep track of the dependents for each employee. Each dependent has a name, birthdate and
relationship with the employee.

* = primary key (unique identifier)
@ = foreign key (points to a primary key or unique identifier in another table)
^ - unique field.

department( departmentId*, name, location, manager(employee.employeeId) )
employee( name, employeeId*, address1, address2, city, state, zip, salary, birthdate, departmentId@, supervisor(employee.employeeId) )

project( name^, projectId*, budget )
dependent( employeeId*@, name*, birthdate*, relationship )

employee_project ( employeeId*@, projectId*@, startdate, hoursworked )