Database Design: Functional Dependencies and Normalization GATE 2007 Question #7543 with Solution

GATE 2007

Database ManagementDatabase Design: Functional Dependencies and NormalizationeasyMCQ1 mark

A relation R is in BCNF if for every functional dependency X -> Y:

AX is a superkey of RBY is a prime attribute of RCX is a prime attribute of RDY is a subset of X or X is a prime attribute

Related Database Management PYQs

The ACID property that guarantees that all updates performed by a committed transaction survive system crashes and power failures …

A primary index is created on a database file when the file is ordered on:

Which of the following relational calculus languages is based on first-order predicate logic with variables ranging over individua…

The lost update problem in database concurrency control is caused primarily by:

A schedule in which each transaction reads only changes committed by earlier transactions is called:

Which relational algebra operation corresponds to vertical partitioning or selecting specific columns?

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.