Each department has one chair the primary key of this


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

Solution Preview :

Prepared by a verified Expert
Basic Computer Science: Each department has one chair the primary key of this
Reference No:- TGS01476709

Now Priced at $10 (50% Discount)

Recommended (97%)

Rated (4.9/5)