Free online book on database design, UML and SQL. This third edition of dbDesign is a general update, both to meet legal requirements for U.S. “Section 508” accessibility and to bring the code into compliance with the latest World Wide Web Consortium standards.
Book Description
In the process, I’ve tried to make the SQL examples as generic as possible, although you will still have to consult the documentation for your own database system. Graphics no longer require the SVG plugin; large-image and text-only views of each graphic are provided for all readers; the menu is now arranged by topic areas; and the print version (minus left-side navigation) is done automatically by a style sheet.
Table of Contents
Basic UML & SQL
- Models
- Classes & schemes
- Rows & tables
- Associations
- Keys
UML design
- Many-to-many
- Many-to-many 2
- Subkeys
- Repeated attributes
- Multivalued attributes
- Domains
- Enumerated domains
- Subclasses
- Aggregation
- Recursive associations
- Normalization
SQL technique
- Queries
- DDL & DML
- Join
- Multiple joins
- Join types
- Functions
- Subqueries
- Union & minus
- Views & indexes