Page 1


	Page 1











Computer Science 455


First Hour Exam




Name _______________________________


















Friday, Feb. 17
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.	DBA








b.	Entity integrity







c.	Foreign Key







d.	Data independence

(problem I, continued)

e.	Entity







f.	Data Dictionary







II.	For the following questions, consider the following 
database:

STUDENT(SNO, SNAME, MAJOR, FNO)
	(FNO is the faculty number of the student's advisor)
FACULTY(FNO, FNAME, DEPT)
CLASS(CNO, CNAME)
ENROLL(SNO, CNO, GRADE)

	On the following pages, give both EASYALG and SQL queries to 
find answers to the given questions (10 pts. each)

1.	Find the names (only) of students majoring in computer 
science (i.e., students with MAJOR = 'CSCI').

	a.	EASYALG






	

	b.	SQL








2.	Find the names (only) of students advised by Jerry (i.e., those 
advised by a faculty member with FNAME = 'KERRICK').

	a.	EASYALG







	b.	SQL

	(problem II continued)

3.	Find the names (only) of students enrolled in the class with 
CNAME = 'CS455'.

	a.	EASYALG









	b.	SQL