• Menu
  • Skip to right header navigation
  • Skip to main content
  • Skip to secondary navigation
  • Skip to primary sidebar

OnlineProgrammingBooks.com

Legally Free Computer Books

  • All Categories
  • All Books
  • All Categories
  • All Books
  • About Us
  • Privacy policy
  • Disclaimer
  • Subscribe
  • Contact
You are here: Home ▶ Databases ▶ Database design with UML and SQL, 3rd edition

Database design with UML and SQL, 3rd edition

March 24, 2006

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.

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

Download Free PDF / Read Online

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

Similar Books:

  1. Interface Design Best Practices in Object-Oriented API Design in Java
  2. Concurrency Control and Recovery in Database Systems
  3. A Functional Pattern System for Object-Oriented Design
  4. Java Look and Feel Design Guidelines: Advanced Topics
  5. Bringing Design to Software
Previous Post: « Practical mod_perl
Next Post: Mobile Robots: Perception & Navigation »

Primary Sidebar

Get Latest Updates

  • Facebook
  • Pinterest
  • RSS
  • Twitter
  • YouTube
  • About Us
  • Privacy policy
  • Disclaimer
  • Subscribe
  • Contact

Copyright © 2006–2025 OnlineProgrammingBooks.com