Sample Exercises and Examination Questions - Database Systems - page 426

12.

A scientific research est. For each experiment, the following is
recorded:

· Project number

· Project manager

· Project name

· Experiment number

· Experiment name

· Lab in which experiment is to be conducted

· List of scientists to work on the project

Note: A project manager may work on an experiment. A scientist may work
on more than one experiment, provided that they are done in the same lab.
A manager may manage more than one project.

From the information given, use the XR model to derive a set of BCNF
relations for the system.

Use self-explanatory relation and attribute names (you may introduce
new attributes). {20}

Section C: 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.

13.

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

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

{03}

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

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

course (code) 'CS100'

{03}

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

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

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

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

of its chairperson

{03}