Sample Exercises and Examination Questions - Database Systems - page 415

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

Figure 26-9. Section of a College Database

8.

Write SQL statements that will produce the results specified below:

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

surname with other students {03}

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

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

course (code) 'CS100' {03}

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

{03}

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

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

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

of its chair-person {03}

9.

9a. How important are (logical) views in a database

(cite possible advantages)? {04}

9b. Identify four (4) scenarios that could render a logical

view non-updateable.

{04}

9c. Referring to the college database of Figure 26-9 , define

a view that “stores” Computer Science courses only
(assume that all Computer Science course-codes begin
with the acronym 'CS'). {03}