Register

ISRO-2017

233 views
0 votes
0 votes

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
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

  1. Not in 3NF,in BCNF
  2. In 3NF,not in BCNF
  3. In 3NF, in BCNF
  4. Not in 3NF, not in BCNF

What are the FD that can be obtained from the above relation and what is its normal  form?

 

 

User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

5 votes
5 votes
3 answers
3
sh!va asked May 7, 2017
5,125 views
ISRO 2017-5
Which of the following concurrency control protocol ensures both conflict and free from deadlock? , Time stamp ordering 2 Phase locking Both (a) and (b) None of the above
Which of the following concurrency control protocol ensures both conflict and free from deadlock? ,Time stamp ordering2 Phase lockingBoth (a) and (b)None of the above
User Avatar
0 votes
0 votes
0 answers
4
MeghnaJain asked Jun 21, 2018
270 views
Geeks for Geeks,ISRO CS 2017
int func(int num) { int count = 0; while(num) { count++; num >>= 1; } return(count) ; } ques:if func(435) what will be the result?
int func(int num) { int count = 0; while(num) { count++; num >>= 1; } return(count) ; }ques:if func(435) what will be the result?
User Avatar
Link Copied!