Sample Exercises and Examination Questions - Database Systems - page 414

By completing closure, determine the candidate key
in the given relation.

{03}

Derive a set of 4NF relations. {07}

Section C: Examine the section of a college/university database, shown in
Figure 26-9 and answer one question from this section.

6.

Write relational calculus statements that will produce the
results specified below:

6a. List all students (name, ID, and gender) who share

surname with other students {03}

6b. List all program-names and related course-

names {04}

6c. List the names of all programs that include the course (code)

'CS100' {03}

6d. List the names of all programs that do not include course
(code) 'ENGL101' {03}

6e. List all Canadian (country code 'CAN') students (name,

ID, Hall-name) enrolled in the B.S. in Computer Science
(program code 'P11SC')

{04}

6f. List the name of each department along with the name

of its chair-person {03}

7.

Write relational algebra statements that will produce the
results specified below:

7a. List all students (name, ID, and gender) who share

surname with other students {03}

7b. List all program-names and related course-names 04}

7c. List the names of all programs that include the

course (code) 'CS100' {03}

7d. List the names of all programs that do not include course
(code) 'ENGL101'

{03}

7e. List all Canadian (country code 'CAN') students (name,

ID, Hall-name) enrolled in the B.S. in Computer Science
(program code 'P11SC') {04}

7f. List the name of each department along with the name

of its chair-person {03}