Java Reference
In-Depth Information
In addition, this chapter explored the underlying theory of relational databases
developed by E.F. Codd, and summarized in Codd's rules and the ACID test.
Although these specific topics are not discussed again, they are important in
understanding why relational databases work the way they do.
Chapter 2
explores the design of a simple, but non-trivial database for an XML based
application presented in
Part IV
. The design is derived from a specification for a legal
invoicing system which uses XML to transmit invoices from legal firms to large
corporate clients. The central topics discussed are the practical design of the tables
required, and of the primary and foreign keys used to link them. Particular attention is
also given to database integrity.
