Page 1


	Page 1











Computer Science 455


First Hour Exam




Name _______________________________


















Friday, Feb. 16
100 pts.


I.	Some definitions (5 pts. each).

	Give brief definitions of the following terms.  Please note that 
in the case of acronyms it is not sufficient simply to say what 
the letters mean.

a.	Data Independence








b.	Data model







c.	Key







d.	Data independence

(problem I, continued)

e.	Entity - relationship diagram







f.	Network/CODASYL model










II.	(5 pts.)	Why is data independence important?




III.	(10 pts.)

	Write a brief job description (as for a job advertisement) for a 
database administrator.



















IV.	For the following questions, consider the following database 
designed for a small video store:

CUSTOMER(CNO, CNAME, ADDRESS)
TAPE(TNO, TNAME, TYPE, RATING, DAILY-CHARGE)
RENTS(CNO, TNO, DUE-DATE)

	On the following pages, give both EASYALG and SQL queries to 
find answers to the given questions

Question IV continued

1.	(10 pts.)	Find the names (only) of tapes with a rating of 'G'.

	a.	EASYALG






	

	b.	SQL








2.	(15 pts.)	Find the names (only) of customers renting a tape 
with TNO = 'T12345'.

	a.	EASYALG








	b.	SQL

	(problem IV continued)

3.	(15 pts.)	Find the names (only) of customers renting a tape 
with TNAME = 'ATTACK OF THE KILLER TOMATOES'

	a.	EASYALG









	b.	SQL


V.	For the same database given above, 

	1.	(5 pts.)	write the CREATE TABLE for the CUSTOMER 
table.  Note that CNO is the key field and that we would like to 
enforce entity integrity.









	2.	(10 pts.)	Write the SQL code necessary to delete from 
the database customers who have rented 'ATTACK OF THE 
KILLER TOMATOES'.