Database Design: Functional Dependencies and Normalization GATE 1990 Question #8825 with Solution

GATE 1990

Database ManagementDatabase Design: Functional Dependencies and NormalizationeasyMCQ1 mark

A functional dependency X -> Y is called a trivial functional dependency if:

AY ⊆ XBX ⊆ YCX ∩ Y = ∅DX is a prime attribute

Related Database Management PYQs

In concurrency control, the Thomas Write Rule permits a write operation to be ignored if:

In a B-tree of order m, what is the maximum number of children any internal node can have?

The transaction property that ensures changes made by a committed transaction are not lost in a crash is:

Which SQL statement is used to create a new database table schema?

Fourth Normal Form (4NF) is specifically designed to eliminate:

First Normal Form (1NF) requires that all attribute values in a relation are:

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.