GATE CS 2018 (Forenoon) — Question 52

Database Management Systems (DBMS)Normalization Schemes (1NF, 2NF, 3NF, BCNF Boundaries)MCQ2 marks · −2/3 if wrongMedium

Consider the following four relational schemas. For each schema, all non-trivial functional dependencies are listed. The underlined attributes are the respective primary keys. Schema I: Registration (rollno, courses) Field ‘courses’ is a set-valued attribute containing the set of courses a student has registered for. Non-trivial functional dependency: rollno \(\rightarrow\) courses Schema II: Registration (rollno, courseid, email) Non-trivial functional dependencies: rollno, courseid \(\rightarrow\) email email \(\rightarrow\) rollno Schema III: Registration (rollno, courseid, marks, grade) Non-trivial functional dependencies: rollno, courseid \(\rightarrow\) marks, grade marks \(\rightarrow\) grade Schema IV: Registration (rollno, courseid, credit) Non-trivial functional dependencies: rollno, courseid \(\rightarrow\) credit courseid \(\rightarrow\) 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
Practise the full 2018-FN paper
Challenge a friend: WhatsApp Telegram
From RENYXERAFree All-India Mock — every SundayA full GATE CS paper, exactly 180 minutes, ranked across India with your GATE score.
Practise more on Normalization Schemes (1NF, 2NF, 3NF, BCNF Boundaries)Timed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group