Database Design: Functional Dependencies and Normalization GATE 1991 Question #9026 with Solution

GATE 1991

Database ManagementDatabase Design: Functional Dependencies and NormalizationeasyMCQ1 mark

Armstrong's Transitivity Axiom states that:

GRAMMAR RULES

XY and

YZ hold, then

XZ holds

BIf X -> Y holds, then XZ -> YZ holdsCIf X -> Y holds and Y ⊆ X, then X -> Y is trivialD

GRAMMAR RULES

XY and

XZ hold, then

XYZ holds

Related Database Management PYQs

Which relational algebra operator is equivalent to the SQL expression 'INTERSECT'?

A clustering index is defined on an ordered data file where the ordering data attribute is:

In SQL, the HAVING clause is used to filter:

Which recovery log record format logs both the old value and the new value of a modified data item?

Which SQL command modifies existing table row data?

Let P, Q, R and S be the attributes of a relation in a relational schema. Let X → Y indicate functional dependency in the context …

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.