Contents
Database design with UML and SQL, 3rd edition - intro.html
Basic UML & SQL
Models and languages - models.html
Basic structures: classes and schemes - class.php
Basic structures: rows and tables - tables.php
Basic structure: associations - association.php
Discussion: more about keys - keys.php
UML design
Design pattern: many-to-many (order entry) - manymany.php
Design pattern: many-to-many with history (the library loan) - loan.php
Design pattern: subkeys (the zip code) - subkeys.php
Design pattern: repeated attributes (the phone book) - phone.php
Design pattern: multivalued attributes (hobbies) - hobbies.php
Discussion: more about domains - domains.php
Design pattern: enumerated domains - enum.php
Design pattern: subclasses - subclass.php
Design pattern: aggregation - aggregate.php
Design pattern: recursive associations - recursive.php
Appendix: traditional normalization - normalize.php
SQL technique
Basic queries: SQL and RA - queries.php
Basic SQL statements: DDL and DML - ddldml.php
Basic query operation: the join - join.php
SQL technique: multiple joins and the distinct keyword - multijoin.php
SQL technique: join types - jointypes.php
SQL technique: functions - functions.php
SQL technique: subqueries - subqueries.php
SQL technique: union and minus - setops.php
SQL technique: views and indexes - views.php
Copyright © 2002–2006, by Tom Jewett. Links to this site are welcome and encouraged. Individual copies may be printed for non-commercial classroom or personal use; however, this material may not be reposted to other web sites or newsgroups, or included in any printed or electronic publication, whether modified or not, without specific permission from the author.