GATE CSE 2000 | Functional Dependencies and Normalization Question 39 | Database Management System

GATE CSE 2000

MCQ (Single Correct Answer)

-0.6

Given the following relation instance
$$\eqalign{ & X\,\,\,\,\,Y\,\,\,\,\,Z \cr & \,\,1\,\,\,\,\,\,4\,\,\,\,\,\,2 \cr & \,\,1\,\,\,\,\,\,5\,\,\,\,\,\,3 \cr & \,\,1\,\,\,\,\,\,6\,\,\,\,\,\,3 \cr & \,\,3\,\,\,\,\,\,2\,\,\,\,\,\,2 \cr} $$

Which of the following functional dependencies are satisfied by the instance?

$$XY \to Z$$ and $$Z \to Y$$

$$YZ \to X$$ and $$Y \to Z$$

$$YZ \to X$$ and $$X \to Z$$

$$XZ \to Y$$ and $$Y \to X$$

GATE CSE 1999

MCQ (Single Correct Answer)

-0.6

Consider the schema $$R = \left( {S\,\,T\,\,U\,\,V} \right)$$ and the dependencies $$S \to T,\,\,T \to U,\,\,U \to V$$ and $$V \to S$$ let $$R =$$ $$(R1$$ and $$R2)$$ be a decomposition such that $$R1 \cap R2 \ne \phi .$$ The decomposition is:

Not in $$2NF$$

In $$2NF$$ but not $$3NF$$

In $$3NF$$ but not in $$2NF$$

In both $$2NF$$ and $$3NF$$

GATE CSE 1998

Subjective

-0

Consider the following database relations containing the attributes
Book–id
Subject–Category–of–book
Name–of–Author
Nationality–of–Author
With book–id as the primary key.
(a) What is the highest normal form satisfied by this relation?

(b) Suppose the attributes Book–title and Author–address are added to the relation, and the primary key is changed to {Name–of–Author, Book–title}, what will be the highest normal form satisfied by the relation?

GATE CSE 1998

Subjective

-0