Review Questions

1.In the context of a relational model, discuss each of the following concepts:

  1. relation

  2. attributes

  3. tuple

  4. cardinality

  5. domain.

2.Discuss the various types of keys that are used in relational model.
3.The relations (tables) shown in Fig. 4.15 are a part of the relational database (RDBMS) of an organisation. Find primary key, secondary key, foreign key and candidate key.
4.Let us assume that a database system has the following relations:

STUDENTS (NAME, ROLL-NO, ADDRESS, MAIN)

ADMISSION (ROLL-NO, COURSE, SEMESTER)

FACULTY (COURSE, FACULTY, SEMESTER)

OFFEREING (BRANCH, COURSE)

Using relational algebra, derive relations to obtain the following information:

  1. All courses taken by a given student.

  2. All faculty that at some time taught a given ...

Get Database Systems: Concepts, Design and Applications now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.

Start your free trial