Computer Science 455

First Hour Exam

Name _____________________________

Friday, Feb. 18

100 points

I. (5 pts. each): Give basic definitions for the following:

a. Database

b. Data Administrator

c. Database Administrator (different job)

d. Key

e. Foreign key (give an example as well as a definition)

f. Entity Integrity

(definitions, con't)

g. Referential Integrity

II. (15 pts.) Data independence is some times given as one of the advantages of the database approach (contrasted with the file approach). What does data independence mean, and why is it important? A complete answer will do more than give a one-sentence definition of data independence.

III. (10 points) What sort of information is stored in the Oracle data dictionary?

IV. With respect to the SPJ database:

S(sno, sname, status, city)

P(pno, pname, color, weight, city)

J(jno, jname, city)

SPJ(sno, pno, jno, qty)

On the following page, write both EASYALG and SQL queries for the following queries:

a. (15 pts.) Get the project numbers and project names for projects in LONDON (i.e., j.city = "LONDON")

EASYALG

SQL

b. (15 pts.) Get the names of parts supplied by a LONDON supplier (s.city = 'LONDON')

EASYALG

SQL

c. (SQL only - 10 pts.) Find the names of projects that use no RED parts