Question
A B C is a set of attributes. The functional dependency is as follows

AB -> B AC -> C C -> B
a) is in 1NF

b) is in 2NF

c) is in 3NF

d) is in BCNF

Answers

(a) is in 1NF since (AC)+ = { A, B, C} hence AC is the primary key. Since C B is a FD given, where neither C is a Key nor B is a prime attribute, this it is not in 3NF. Further B is not functionally dependent on key AC thus it is not in 2NF. Thus the given FDs is in 1NF.   Your Comment






Search
Can you Answer!!
  • Q There are over 130000 species of what on earth
  • Q Explain different recording modes ?
  • Q What are binary search and Fibonacci search?
  • Q Why did you decide to work for this company?
  • Q Mention what is the role of validators in jira?
  • Q Can we overload methods on a single parameter with data types as int and long. For example - int calculate(int x) and int calculate(long x) ?
  • Q Why don’t you include gnome web (epiphany) by default?
  • Q In Hamlet who is Ophelia's father
  • Q The International Date-line is an imaginary line extending from pole to pole along the places on the earth's surface and lies along the ___________
  • Q Can a private method of a superclass be declared within a subclass?
  • Q Who proposed 14 points demanding seperate electorates and reservation for Muslims in Govt. service ?