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:
- A.
Not in 3NF, in BCNF
- B.
In 3NF, not in BCNF
- C.
In 3NF, in BCNF
- D.
Not in 3NF, not in BCNF
Attempted by 638 students.
Sign up free to check your answer
Sign up freeLoading lesson…

