| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/CST1600/Resources/Examples/Normilization/ |
Upload File : |
_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 )