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
Recommended book · affiliate linkDatabase System Concepts (Korth)Normalisation, SQL, transactions and indexing — the DBMS syllabus in one book.
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