Database Design: Functional Dependencies and Normalization GATE 2016 Question #1576 with Solution

GATE 2016 · CS1 - Forenoon

Database ManagementDatabase Design: Functional Dependencies and NormalizationmediumMCQ1 mark

Schema R(VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, YEAR, PRICE) with PK (VOLUME, NUMBER, STARTPAGE, ENDPAGE). FDs: (VOLUME, NUMBER, STARTPAGE, ENDPAGE) -> TITLE, PRICE (VOLUME, NUMBER) -> YEAR Redesigned as R1(VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, PRICE) and R2(VOLUME, NUMBER, YEAR). Which is the weakest normal form that the new database satisfies, but the old one does not?

A1NFB2NFC3NFDBCNF

Save your progress

Related Database Management PYQs

GATE 2016 · CS1 - Forenoon

Which of the following is NOT a superkey in a relational schema with attributes V, W, X, Y, Z and primary key VY?

GATE 2016 · CS1 - Forenoon

Which one of the following is NOT a part of the ACID properties of database transactions?

GATE 2016 · CS1 - Forenoon

A 2PL protocol acquires exclusive locks to objects O1, ..., Ok in increasing order of their addresses, performs operations, and re…

GATE 2016 · CS2 - Afternoon

B+ Trees are considered BALANCED because

GATE 2016 · CS2 - Afternoon

Construct the precedence graph of schedule S with vertices representing transactions and edges representing conflicts. If S is ser…

GATE 2016 · CS2 - Afternoon

Schedule S: r2(X); r1(X); r2(Y); w1(X); r1(Y); w2(X); a1; a2. Which statement is TRUE?

Saved progressKeep answers, mock results and completion history across devices.

Adaptive practiceGet questions matched to your recent accuracy and difficulty level.

Bookmarks and notesBuild a personal revision list and record why a question was difficult.

Performance insightsSee weak subjects, accuracy trends, streaks and exam readiness.

Related Database Management PYQs

Turn practice into measurable progress