Consider The Following Functional Dependencies In A Database P #869
Consider the following functional dependencies in a database. </p> <pre><code class="language-sql"> Date_of_Birth->Age Age->Eligibility Name->Roll_number Roll_number->Name Course_number->Course_name Course_number->Instructor (Roll_number, Course_number)->Grade </code></pre> <p>The relation (Roll_number, Name, Date_of_birth, Age) is
This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 Query Processing Techniques - Materialized Views - Quiz No.1.
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
In second normal form but not in third normal form
In third normal form but not in BCNF
In BCNF
None of the mentioned
Similar question(s) are as followings:
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117 Database Management System
Online Quizzes