Database Systems: Concepts, Design and Applications

Review Questions

1.	In the context of a relational model, discuss each of the following concepts: relation attributes tuple cardinality 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: All courses taken by a given student. All faculty that at some time taught a given ...