GATE DA concept:normal-form PYQs & Answers

Questions 1–2 of 2. Imported answers require independent review unless marked reviewed.

Consider an ER model with the entities E1 (A₁₁, A₁₂, A₁₃) and E2 (A₂₁, A₂₂, A₂₃), where, A₁₁, A₁₂, A₁₃ are the attributes of E1, and A₂₁, A₂₂, A₂₃ are the attributes of E2. Let A₂₂ be a multi-valued attribute. A₁₁ and A₂₁ are the primary keys of E1 and E2, respectively.

Let R12 be a many-to-many relationship between E1 and E2. Participation of both E1 and E2 in R12 is total.

The minimum number of relations required to convert the ER model into relational model (assuming there is no other functional dependency) where each relation is in third normal form (3NF) is ________ . (Answer in integer)

You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answer

Consider a database relation R with attributes ABCDEFG, and having the following functional dependencies:

A → BCE E → DG BC → A

Which of the following statements is/are correct?

Your answerSelect all correct options. You can choose more than one.

A is the only candidate key of R

A, BC are the candidate keys of R

A, BC, E are the candidate keys of R

Relation R is not in Boyce-Codd Normal Form (BCNF)

You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answer

GATE DA concept:normal-form PYQs

How to practice concept:normal-form

Question 61

Question 57