Consider the following four relational schemas. For each schema, all…

PYQ GATE 2018Modified — slightly modified from the official paper; see the solution

Consider the following four relational schemas. For each schema, all non-trivial functional dependencies are listed, and the primary key is stated explicitly.

Schema I: Registration(rollno, courses)
Primary key: rollno
Field courses is a set-valued attribute containing the set of courses a student has registered for.
Non-trivial functional dependency:
rollno -> courses

Schema II: Registration(rollno, courseid, email)
Primary key: (rollno, courseid)
Non-trivial functional dependencies:
rollno, courseid -> email
email -> rollno

Schema III: Registration(rollno, courseid, marks, grade)
Primary key: (rollno, courseid)
Non-trivial functional dependencies:
rollno, courseid -> marks, grade
marks -> grade

Schema IV: Registration(rollno, courseid, credit)
Primary key: (rollno, courseid)
Non-trivial functional dependencies:
rollno, courseid -> credit
courseid -> credit

Which one of the relational schemas above is in 3NF but not in BCNF?

  1. A.

    Schema I

  2. B.

    Schema II

  3. C.

    Schema III

  4. D.

    Schema IV

Attempted by 356 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…