ALL GATE QUESTIONS SUBJECTWISE
×

ER Diagrams

1 Mark Questions 2 Marks Questions

Functional Dependencies and Normalization

1 Mark Questions 2 Marks Questions

SQL 

1 Mark Questions 2 Marks Questions

Relational Algebra and Relational Calculus

1 Mark Questions 2 Marks Questions

Transactions and Concurrency Control

1 Mark Questions 2 Marks Questions

File Structures  and Indexing

1 Mark Questions 2 Marks Questions



GATE 1995 Question - Marks 2

(a) Consider the relation scheme R(A, B, C) with the following functional dependencies:
  A, B → C, C → A
Show that the scheme R is the Third Normal Form (3NF) but not in Boyce- Code Normal Form (BCNF).
(b) Determine the minimal keys of relation R.


Total 13 Questions



Share: