Given the relational schema R = (U, V, W, X, Y, Z) and the set of functional dependencies: {U → V, U → W, W → Y, W → Z, X → Y, X → Z} Which of the following functional dependencies can be derived from the above set?

A. VW → YZ; B. WX → YZ; D. VW → Y

Normal Form and Functional Dependencies GATE 2024 Question #10144 with Solution

GATE 2024 · session-1

Database Management and WarehousingNormal Form and Functional DependenciesmediumMSQ2 marks

Given the relational schema R = (U, V, W, X, Y, Z) and the set of functional dependencies: {

GRAMMAR RULES

UV,

UW,

WY,

WZ,

XY,

XZ}

Which of the following functional dependencies can be derived from the above set?

AVW → YZBWX → YZCVW → UDVW → Y

Select every correct option.

Consider a database that includes the following relations: Defender(name, rating, side, goals), Forward(name, rating, assists, goa…

Let the minimum, maximum, mean, and standard deviation values for the attribute income of data scientists be Rs 246000, Rs 170000,…

Consider the following two tables named Raider and Team in a relational database maintained by a Kabaddi league. The attribute ID …

An OTT company is maintaining a large disk-based relational database of different movies with the following schema: • Movie (ID, C…

Let \(R(A,B,C,D,E)\) be a relational schema with functional dependency set \(F = \{A \rightarrow BC,\ CD \rightarrow E,\ E \righta…

Consider that the visualization of a 3-dimensional data cube is showing Sales Quantity for each combination of the attributes Prod…

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.