O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required