Errata to

Information Modeling and Relational Databases, Third Edition

Halpin, T. and Morgan T. 2024

(Morgan Kaufmann)

Last updated: 2025 August 30

If you spot any other errors in this third edition, please e-mail them to Terry Halpin at [email protected].

The following corrections should be made to the first printing. . To determine the print version of your copy of the book, look at the row of digits below the copyright notice on the verso of the main title page: the final digit denotes the print version (e.g. 1 = first printing, 2 = second printing).

The symbol "-->" means "is replaced by".

Page 40, question 3, insert the following as the third sentence: "Here,the marital status "single" is used in the sense of "never married".

Page 288, Figure 7.21: Symmetric and antisymmetric relations should overlap (as purely reflexive relations are their intersection), and strongly intransitive relations should be a proper subset of acyclic relations. Here is an updated version of Figure 7_21:

Page 289, sentence 1: "constraints" --> "constraints on non-empty relations".

Page 428, paragraph 4, append to the first sentence ending with "Chapter 2": "where "single" is used in the sense of "never married".

Page 428, paragraph 5: in sentence 3 change "10.29(a)" to "10.29(b)" and in sentence 4 change "10.29(b) to "10.29(c)".

Page 459, Figure 10.60(a): Add the predicate text "is monolingual" to the unary predicate.

Page 521, Figure 13.35(c): change the colour of the predicate reading "smokes" to black. Note: the role of the objectifed unary applies only to its positve instances.

Page 792, Figure 15.22(b): "F(in Y)" --> "F[in Y]".

Page 925, second constraint formula: Insert closing parenthesis so it reads "ic (c1, c2, n) requires (hasCountryName(c1,n) and hasCountryName(c2,n)) implies c1 = c2 ".