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?
- A.
Schema I
- B.
Schema II
- C.
Schema III
- D.
Schema IV
Attempted by 356 students.
Sign up free to check your answer
Sign up freeLoading lesson…

