By Tom Jewett
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.
The second edition was largely motivated by the very helpful comments of Prof. Alvaro Monge, as well as by my own observations in two semesters of using its predecessor in class. Major changes included the clear separation of UML from its implementation in the relational model, the introduction of relational algebra terminology as an aid to understanding SQL, and an increased emphasis on natural-language understanding of the design.
The second edition was largely motivated by the very helpful comments of Prof. Alvaro Monge, as well as by my own observations in two semesters of using its predecessor in class. Major changes included the clear separation of UML from its implementation in the relational model, the introduction of relational algebra terminology as an aid to understanding SQL, and an increased emphasis on natural-language understanding of the design.
Following are the few topics covered in this UML book
- 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