Page 1


	Page 1











Computer Science 455


Second Hour Exam




Name _______________________________


















Thursday, Mar. 23
80 pts.


I.	Consider the following entity-relationship diagram:

                                                             




1.	(15 pts.)	From this entity-relationship diagram, construct a 
series of tables.  You do not need to write CREATE TABLE 
statements.  Instead, write the tables as, for example, S(SNO, 
SNAME, STATUS, CITY).













2.	(15 pts.)	Identify, for each table, the primary and the 
foreign keys, and specify what fields, if any, should be 
specified as NOT NULL, giving reasons for each.  Please do 
this below table by table.

II.	Consider the following form:

                                                             

Let's make the additional assumption that each customer has a 
unique salesperson:  i.e., if we know the customer number, we 
know the salesperson number.

1.	(10 pts.)	Write down the fields in this form, indicating any 
repeating fields, and listing any functional dependencies.













2.	(10 pts.)	Give a brief definition of first normal form, and put 
the un-normalized form in first normal form.  Please note that 
in this problem and in the following problems, it may happen 
that no violations of the normal form referred to exist.  In that 
case, please note that fact.


3.	(10 pts.)	Give a brief definition of second normal form, and 
put the result of the previous problem into second normal 
form.














4.	(10 pts.)	Give a brief definition of third normal form, and 
put the result of the previous problem into third normal form.

5.	(10 pts.)	Sketch an entity-relationship diagram of your 
result.