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 1996 Question - Marks 2

A library relational database system uses the following schema
USERS (User #, User Name, Home Town)
BOOKS (Books # Book Title, Author Name) ISSUED (Book #, User #, Date)
Explain in one English sentence, what each of the following relational algebra queries is designed to determine.
(a) σ User #=6 (11 User #, Book Title ((USERS ISSUED) BOOKS))
(b) σ Author Name (BOOKS (σ Home Town) = Delhi (USERS ISSUED)))


Total 17 Questions



Share: