Sample Exercises and Examination Questions - Database Systems - page 427

14.

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

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

14a. List all students (name, ID, and gender) who share
surname with at least another student {03}

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

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

course (code) 'CS100' {03}

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

14e. List all Canadian (country code 'CAN') students

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

{04}

14f. List the name of each department along with the name of its

chairperson {03}

Section D: Answer one question from this section

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

15.

Write SQL statements that will produce the results specified below:

15a. List all students (name, ID, and gender) who share surname
with at least another student {03}

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

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

course (code) 'CS100' {03}

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

15e. List all Canadian (country code 'CAN') students

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

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

name of its chairperson {03}