Consider the relation below, ONLEAVE, which lists the faculty members who are on leave (Faculty_Name). Each Faculty Member's name is UNIQUE. Each Faculty Member belongs to only one DEPARTMENT. Each DEPARTMENT, has one CHAIR. The Primary Key of this relation is FACULTY_NAME. What is the highest Normal Form that this relation is in?
|
FACULTY_NAME
|
DEPARTMENT
|
CHAIR
|
|
John
|
Ids
|
Jim
|
|
Bob
|
Ids
|
Jim
|
|
Pete
|
Mgt
|
Duke
|
|
Mary
|
Acct
|
Linda
|