Please note that these changes may have
been implemented in the text you are currently using.
5th Edition
Corrections
Page 17, third bullet under point 2, second line ( in the CUSTOMER file become linked to a nonexistent agent.) Reason for change: You cant be linked to something that does not exist.
Corrected:
in the CUSTOMER file refer to a nonexistent agent.
Page 25, 4th line below note (Although the hierarchical database model . Reason for change: The boldfaced term has not been defined. (This insertion will not add to the page count there is plenty of room at the bottom of this page.)
Corrected:
The hierarchical database model is based on structure that resembles an upside-down tree in which the trunk sprouts branches that in turn sprout other branches. The trunk and all of its branches have a 1:M relationship to the branches that sprout from them. Although the hierarchical model is no longer a major player in ...
Page 91, Figure2.31 P_NUM label should be PAINTER_NUM. Reason for change: The label must match the text.
Figure 2.31 Components of an Index
Page 130, Section 3.3.6, line 4 (in the COURSE is supplied by CLASS relationship .. Reason: is supplied by makes no sense and doesnt match the text or Figures 3.17 and 3.18.
Correction:
in the COURSE generates CLASS relationship
Page 136, Figure 3.21. The top (Chen model) portion does not include the connectivities.
Correction: Add the connectivities the letters next to the entity boxes -- to the Chen model as shown below. BUT KEEP THE CROWS FOOT MODEL BELOW IT EXACTLY AS IS.
Page 144, paragraph below Figure 3.33, line 5 (Such disjoint relationships are .
Correction:
Such disjoint subtypes are indicated by .)
Page 145, paragraph below Figure 3.34, line 5 (Such overlapping relationships are .
Correction:
Such overlapping subtypes are indicated by .)
Page 161, Problem 8, section b (Describe the relationships between instructor and course .. )
Correction:
Describe the relationships between instructor and class .
Page 183, Figure 4.5, table name ASSIGN
Correction: The PROJ_NUM box must be colored green to match the EMP_NUM box.
Page 183, line 1 below Figure 4.5 (Figure 4.5 still shows a partial dependency )
Correction:
Figure 4.5 still shows a transitive dependency, which )
Page 189, Figure 4.8, second dependency diagram
Correction: change the 2NF label to 1NF
Page 205, problem 18, bullet 2. (Each consultant can serve many clients ..) Reason for change: The business rule doesnt match the data shown on the previous page.
Correction:
- Each consultant can work on many contracts, and each contract may require the work of many consultants.
Page 205, problem 18, bullet 4 (Each contract covers one classification ..) Reason for change: The business rule doesnt match the data shown on the previous page.
Correction:
- Each contract can include many classifications. (For example, a client may require consulting work in database and in networking.)
-
Page 226, Section 5.3.4, line 1, first sentence.
Correction: Use the UPDATE command to modify the data in a table. For example, .
Page 234, 2nd line above Figure 5.15 (of logical devices.)
Correction: of logical operators.
Page 236, first SQL command sequence, third line (WHERE P_MIN IS NULL;) Reason for change: This line does not yield a return.
Correction: WHERE V_CODE IS NULL;
Page 243, Section 5.5.6, line 4 (_DESCRIPT)
Correction: P_DESCRIPT
Page 243, Section 5.5.6, SQL command line 1 (CREATE TABLE (PART
Correction: CREATE TABLE PART (
Page 299, Review Question 3. (Assuming that the remaining .) Reason for change: Students seem to think that they do not need to enter the remaining records.
Correction: 3. Enter the remaining records (see Figure R5.1) into the EMP_1 table, then write the .
Page 302, problem 1, two references (lines 1 and 4) that list CH2_AVIA. Reason for change: The actual database name in Chapter 2 is CH2_AVIA_CO
Correction: CH2_AVIA_CO
Page 360, Table 7.1, OUTPUT column contains the SECTION numbers.
Correction: Move all SECTION numbers to the SECTION column
Page 468, Section 9.2.4, last paragraph on page (The scheduler establishes .) Reason for change: Boldfaced, but the definition misses part of the definition.
Correction: The scheduler is a special DBMS process that establishes the order in which ..
Page 501, Section 10.8.1, line 3 (from several remote sites on a network.) Reason for change: the sites are different, but they may or may not be remote.)
Correction: from several different sites on a network.
Page 502, line 1 below Figure 10.10 (Similarly, a remote transaction, composed of ) Reason for change: Missing word in description/definition.
Correction: Similarly, a remote transaction, composed of several requests, may access data at only a single remote site.
Page 502, third line from bottom of page (each single request .) Reason for change: Missing word in description/definition.
Correction: each single request can reference only one local or remote DP site, the transaction .
Page 503, last paragraph, lines 1 and 2 (A distributed request lets us ..) Reason for change: Missing word in description/definition.
Correction: A distributed request lets us reference data from several local or remote DP sites. Because each request can access data from more than one local or remote DP site, a transaction can access multiple sites. The ability
Page 504, Figure 10.13, the SQL command sequence does not match the illustration. (The PRODUCT and CUSTOMER labels are reversed in the picture.)
Correction: See figure below:
Page 529, third line above the note (example in Table 11.2, the MAJOR ..) change (English) to
(Accounting). Reason for change: Reference does not match examples.
Correction:
example in Table 11.2, the MAJOR attribute contains the OID of a Department object (Accounting); and the ADVISOR attribute
Page 648, Figure 3.18, arrow points to the wrong attribute (VEND_NAME) in the VENDOR table.
Correction: Please reposition the arrow that now points to the VEND_NAME in the VENDOR table to the VEND_ID in the VENDOR table.
Page 653, Figure 13.21, light yellow text box makes it hard tow read white lettering.
Correction: Please change the yellow to blue to make the white text stand out. Or at least use a darker shade of yellow!
Page678 line 2, second sentence from the top of the page (In an e-commerce context .) Please note that security must be boldfaced. Reason for change: Security is in the key Terms list.
Correction: In an e-commerce context, security encompasses all the .
Page 688, last bullet (The SHOPCART structure ..
Correction:
This is not a bullet! Please move the sentence to the margin, i.e.,
The SHOPCART structure is shown in Table 14.9.
Page 703, Hint at bottom of page, incorrect reference.
Correction: Please change to
Hint: Use Sections 14.8 and 14.9 as your map.