The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
+18 votes

Consider the following functional dependencies in a database.

Date_of_Birth -> Age

Age -> Eligibility
Name -> Roll_number Roll_number -> Name
Course_number -> Course_name Course_number -> Instructor
(Roll_number, Course_number) -> Grade  

The relation (Roll_number, Name, Date_of_birth, Age) is

  1. in second normal form but not in third normal form
  2. in third normal form but not in BCNF

  3. in BCNF

  4. in none of the above

asked in Databases by Veteran (59.4k points) | 2.1k views

2 Answers

+33 votes
Best answer

There are three FDs that are valid from the above set of FDs for the given relation :

Date_of_Birth -> Age

Name -> Roll_number

Roll_number -> Name

candidate keys for the above are : (Date_of_Birth,Name) and (Date_of_Birth,Roll_number)

clearly there is partial dependency here (Date_of_Birth -> Age) and Age is not a prime attribute. So it is only in 1NF.

Option (D).


answered by Active (3.8k points)
selected by
There are also given two other fds  i.e course no ,course name and instructor.for the ck all fds should be derived from it
@Neha Singh we need to find dependency btw given relation only which is The relation (Roll_number, Name, Date_of_birth, Age) so all extra dependency other than relation no use
0 votes
there is partial dependency hence it is 1st normal form
answered by Junior (613 points)

Related questions

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true

35,506 questions
42,827 answers
42,181 users