Consider the following relation: Faculty(facName, dept, office, rank,…

ISRO Scientist/Engineer SC 2017

Consider the following relation: Faculty(facName, dept, office, rank, dateHired).

facName

dept

office

rank

dateHired

Ravi

Art

A101

Professor

1975

Murali

Math

M201

Assistant

2000

Narayanan

Art

A101

Associate

1992

Lakshmi

Math

M201

Professor

1982

Mohan

CSC

C101

Professor

1980

Sreeni

Math

M203

Associate

1990

Tanuja

CSC

C101

Instructor

2001

Ganesh

CSC

C105

Associate

1995

(Assume that no faculty member within a single department has same name. Each faculty member has only one office identified in office). 3NF refers to third normal form and BNCF refers to Boyce-Codd normal form

Then Faculty is:

  1. A.

    Not in 3NF, in BCNF

  2. B.

    In 3NF, not in BCNF

  3. C.

    In 3NF, in BCNF

  4. D.

    Not in 3NF, not in BCNF

Attempted by 638 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…