Java Reference
In-Depth Information
14.11
W
HAT
Y
OU
S
TILL
D
ON
'
T
K
NOW
This is another chapter that represents a mere gloss of its topic. Visit your local
book megamart and just count the number of topics on Oracle, MySQL, and
PostgreSQL. Database servers and relational database design are very large
topics indeed. We have hardly scratched the surface. Our goal here has been
merely to give you enough to get started. If you plan to use one of these prod-
ucts, definitely take the time to download and read the official product docu-
mentation (for both MySQL and PostgreSQL it is actually quite good), and
then take your time looking for after-market topics that seem to meet
your needs.
14.12
R
ESOURCES
By no means have we read all the titles available on this topic, but we have read
and can recommend:
• Leon Atkinson,
Core MySQL
, ISBN 0-13-066190-2.
• Paul DuBois,
MySQL
, ISBN 0-7357-0921-1.
• Korry Douglas and Susan Douglas,
PostgreSQL
, ISBN 0-7357-1257-3.
14.13
E
XERCISES
Is this database fully normalized?
13
If not, what would need to be done to
normalize it? What reasons might exist for not fully normalizing a database?
13. “Normalization” is a process of eliminating database redundancy and of theoretical
optimization of the data model. A decent introduction to the concepts may be found at
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html
.
