| PAGE |
LOCATION/ITEM |
CORRECTION |
| 51,
54 |
constraint expression |
NOT
(r2.res# <> r1.res#
AND r2.room =
r1.room
AND r2.arr_date <
r1.dpt_date
AND r2.dpt_date >
r1.arr_date) |
| |
3rd
sentence of Note |
ARR_DATE
should be DPT_DATE |
| 53 |
last two
lines |
base --
is all domain, column, table and
database constraints ANDed
together |
| 53-54 |
sum of
constraints expression |
all
instances of OR should be AND |
| 98 |
last
paragraph, 2nd sentence |
Figure
4.1 should be 4.3
Figure 4.4 should be
4.1 |
| 137 |
bulleted
list |
- An employee can be assigned
to any specified project and all specified
activities
- An employee can be assigned
to any number of projects and any number of
activities.
- Projects and activities are
independent of each other
- A given project or activity
can have any number of employees assigned to it
|
| 138
195 |
table
A
table
ASSIGNS |
|
| 139 |
last
paragraph before 5.2.2.3 |
Figure
5.7 should be 5.8 |
| 140
197 |
table A
table ASSIGNS |
|
| 153 |
Table
COM_EMP |
last
column name should be COMMISSION |
| 179 |
last SQL
statement |
SELECT
cp#, 'P1' AS pp#
FROM links
CONNECT BY PRIOR cp# = pp#
START with
pp# = 'P1' |
| 189 |
Figure
8.3 |
|
| 196 |
Diagram
after last paragraph |
delete
one EMP# |
| 222 |
3rd line
after Note |
'less
than q' should be 'less than or equal
to q' |
| |
SQL
query & calculus expression |
'< q'
should be '> q' |
| 232 |
line
9 |
'redundancy' should be 'missing
values' |
