August 2009
Intermediate to advanced
893 pages
26h 48m
English
Content preview from Database Systems: Concepts, Design and Applications
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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:
|