The following is a list of functional and multi-valued dependencies for a company:
Employee_ID -> Supervisor_ID
Supervisor_ID ->-> Employee_ID
Employee_ID ->-> Child
Employee_ID ->-> { Salary, Year }
Employee_ID -> Spouse
{ Employee_ID, Year } -> Salary
Salary ->-> Year
Employee_ID -> { Name, Address }
Here is one possible normalization of these dependencies:
Here is some simple sample data that shows these dependencies:
| Employee | ||||
|---|---|---|---|---|
| Employee_ID | Name | Address | Spouse | Supervisor_ID |
| 1 | Znotinas, Dr. Nora | Waterloo, ON | NULL | NULL |
| 97 | Brown, David | Waterloo, ON | Lori | 1 |
| 64 | Gartner, Manfred | Kitchener, ON | Elaine | 1 |
| Children | |
|---|---|
| Employee_ID | Child |
| 97 | Tasmin |
| 97 | Tristan |
| 97 | Deborah |
| Salary | ||
|---|---|---|
| Employee_ID | Year | Salary |
| 1 | 2010 | 9,000.00 |
| 97 | 1986 | 400.00 |
| 97 | 1987 | 400.00 |
| 97 | 2010 | 2,300,000.00 |