Data Structure
Java
Python
HTML
Interview Preparation
- Tutorials
- Courses
- Tracks
ISRO | CS | 2017 | Dec | DBMS | Normal Forms | Question 15
Last Updated :
Discuss
Comments
Consider the following table : 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 |
| Lakshmi | Math | M201 | Professor | 1982 |
| 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 BCNF refers to Boyee-Codd Normal Form Then Faculty is
Not in 3NF, in BCNF
In 3NF, not in BCNF
In 3NF, in BCNF
Not in 3NF, not in BCNF
This question is part of this quiz :
Database Design(Normal Forms),ISRO CS 2017 December,Database Management System PYQ ISRO QUIZShare your thoughts in the comments
GeeksforGeeks