Review Questions
1. | In the context of a relational model, discuss each of the following concepts:
|
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:
|
Get Database Systems: Concepts, Design and Applications now with the O’Reilly learning platform.
O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.