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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial