Computer Science Engineering (CSE) Exam  >  Computer Science Engineering (CSE) Questions  >  Consider the following functional dependencie... Start Learning for Free
Consider the following functional dependencies in a database:
Data_of_Birth → Age
Age → Eligibility
Name → Roll_number
Roll_number → Name
Course_number → Course_name
Course_number → Instructor
(Roll_number, Course_number) → Grade

Q. The relation (Roll_number, Name, Date_of_birth, Age) is:
  • a)
    In second normal form but not in third normal form
  • b)
    In third normal form but not in BCNF
  • c)
    In BCNF
  • d)
    None of the above
Correct answer is option 'D'. Can you explain this answer?
Verified Answer
Consider the following functional dependencies in a database:Data_of_B...
The given table is not in 2NF as age is dependent on date of birth.
View all questions of this test
Most Upvoted Answer
Consider the following functional dependencies in a database:Data_of_B...
Explanation:

The given relation (Roll_number, Name, Date_of_birth, Age) does not satisfy any of the normal forms. Let's see why:

1. First Normal Form (1NF):
The relation is already in 1NF as it contains only atomic values.

2. Second Normal Form (2NF):
A relation is in 2NF if it is in 1NF and every non-key attribute is fully dependent on the primary key. In the given relation, Date_of_birth and Age are functionally dependent on Roll_number, which is a part of the primary key. However, Name is functionally dependent on Roll_number, which is not a part of the primary key. Hence, the relation is not in 2NF.

3. Third Normal Form (3NF):
A relation is in 3NF if it is in 2NF and every non-key attribute is non-transitively dependent on the primary key. In the given relation, Name is transitively dependent on Roll_number via the functional dependency Roll_number → Name and Name → Roll_number. Hence, the relation is not in 3NF.

4. Boyce-Codd Normal Form (BCNF):
A relation is in BCNF if it is in 3NF and every determinant is a candidate key. In the given relation, Roll_number is the only candidate key and all other attributes are dependent on it. Hence, the relation is not in BCNF.

Conclusion:
Thus, the given relation (Roll_number, Name, Date_of_birth, Age) is not in any of the normal forms. It needs to be decomposed into smaller relations that satisfy the normal forms.
Explore Courses for Computer Science Engineering (CSE) exam

Top Courses for Computer Science Engineering (CSE)

Question Description
Consider the following functional dependencies in a database:Data_of_Birth → AgeAge → EligibilityName → Roll_numberRoll_number → NameCourse_number → Course_nameCourse_number → Instructor(Roll_number, Course_number) → GradeQ. The relation (Roll_number, Name, Date_of_birth, Age) is:a)In second normal form but not in third normal formb)In third normal form but not in BCNFc)In BCNFd)None of the aboveCorrect answer is option 'D'. Can you explain this answer? for Computer Science Engineering (CSE) 2025 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about Consider the following functional dependencies in a database:Data_of_Birth → AgeAge → EligibilityName → Roll_numberRoll_number → NameCourse_number → Course_nameCourse_number → Instructor(Roll_number, Course_number) → GradeQ. The relation (Roll_number, Name, Date_of_birth, Age) is:a)In second normal form but not in third normal formb)In third normal form but not in BCNFc)In BCNFd)None of the aboveCorrect answer is option 'D'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2025 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Consider the following functional dependencies in a database:Data_of_Birth → AgeAge → EligibilityName → Roll_numberRoll_number → NameCourse_number → Course_nameCourse_number → Instructor(Roll_number, Course_number) → GradeQ. The relation (Roll_number, Name, Date_of_birth, Age) is:a)In second normal form but not in third normal formb)In third normal form but not in BCNFc)In BCNFd)None of the aboveCorrect answer is option 'D'. Can you explain this answer?.
Solutions for Consider the following functional dependencies in a database:Data_of_Birth → AgeAge → EligibilityName → Roll_numberRoll_number → NameCourse_number → Course_nameCourse_number → Instructor(Roll_number, Course_number) → GradeQ. The relation (Roll_number, Name, Date_of_birth, Age) is:a)In second normal form but not in third normal formb)In third normal form but not in BCNFc)In BCNFd)None of the aboveCorrect answer is option 'D'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE). Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.
Here you can find the meaning of Consider the following functional dependencies in a database:Data_of_Birth → AgeAge → EligibilityName → Roll_numberRoll_number → NameCourse_number → Course_nameCourse_number → Instructor(Roll_number, Course_number) → GradeQ. The relation (Roll_number, Name, Date_of_birth, Age) is:a)In second normal form but not in third normal formb)In third normal form but not in BCNFc)In BCNFd)None of the aboveCorrect answer is option 'D'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of Consider the following functional dependencies in a database:Data_of_Birth → AgeAge → EligibilityName → Roll_numberRoll_number → NameCourse_number → Course_nameCourse_number → Instructor(Roll_number, Course_number) → GradeQ. The relation (Roll_number, Name, Date_of_birth, Age) is:a)In second normal form but not in third normal formb)In third normal form but not in BCNFc)In BCNFd)None of the aboveCorrect answer is option 'D'. Can you explain this answer?, a detailed solution for Consider the following functional dependencies in a database:Data_of_Birth → AgeAge → EligibilityName → Roll_numberRoll_number → NameCourse_number → Course_nameCourse_number → Instructor(Roll_number, Course_number) → GradeQ. The relation (Roll_number, Name, Date_of_birth, Age) is:a)In second normal form but not in third normal formb)In third normal form but not in BCNFc)In BCNFd)None of the aboveCorrect answer is option 'D'. Can you explain this answer? has been provided alongside types of Consider the following functional dependencies in a database:Data_of_Birth → AgeAge → EligibilityName → Roll_numberRoll_number → NameCourse_number → Course_nameCourse_number → Instructor(Roll_number, Course_number) → GradeQ. The relation (Roll_number, Name, Date_of_birth, Age) is:a)In second normal form but not in third normal formb)In third normal form but not in BCNFc)In BCNFd)None of the aboveCorrect answer is option 'D'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice Consider the following functional dependencies in a database:Data_of_Birth → AgeAge → EligibilityName → Roll_numberRoll_number → NameCourse_number → Course_nameCourse_number → Instructor(Roll_number, Course_number) → GradeQ. The relation (Roll_number, Name, Date_of_birth, Age) is:a)In second normal form but not in third normal formb)In third normal form but not in BCNFc)In BCNFd)None of the aboveCorrect answer is option 'D'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.
Explore Courses for Computer Science Engineering (CSE) exam

Top Courses for Computer Science Engineering (CSE)

Explore Courses
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev