Database design with UML and SQL, 3rd edition

Database design with UML and SQL, 3rd edition

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.


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

Book Details

Author(s): Tom Jewett
Format(s): HTML
Link: Read online.

Leave a Reply