[ Top of page ]

Creative Commons LicenseDatabase Design with UML and SQL, 4th edition by Alvaro Monge is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License. Based on a work at http://www.tomjewett.com/dbdesign/.

Database Design with UML and SQL - a tutorial for classroom or individual use

[ Skip menu ]

  • Introduction
  • 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

[ Contents ]

[ Glossary ]

[ Change log ]