Oracle Design
by Dave Ensor and Ian Stevenson


Unconfirmed error reports are from readers. They have not yet been 
approved or disproved by the author or editor and represent solely
the opinion of the reader.


This page was updated December 5, 2000.


Here's the key to the markup:

        [page-number]: serious technical mistake
        {page-number}: minor technical mistake
        <page-number>: important language/formatting problem
        (page-number): language change or minor formatting problem
        ?page-number?: reader question or request for clarification


UNCONFIRMED errors and suggestions from readers:


?76?  Table 3-1 indicates that there are 3 crew members on the Lookout team. 
The paragraph after Table 3-2 says that after crew member "Wells" is deleted, 
no members remain on team Lookout. Either this is a contradiction or I am 
missing something here.


[76]  First full sentence on the page;
I don't believe that Table 3-1 is in 3NF. The PK is a combo of 
"Cream Member" and "Team Name." I don't think that the PK can
be anything else. If this is true, then the attribute "Leader
Name" is a function of only part of the PK. Consequently, the table
is not in 3NF. 


(78)  4th paragraph;
The sentence "Her preference is for a blue Ghia but she does not
mind which model". The word "model" needs to be changed to "car"
because Ghia is a model type. 


[491]  4th paragraph;

l_empno := g_empno(g_empno_ind);
should be:
l_empno := g_empno(I);