Database Information

• MySQL - Open Source Database
• PostgreSQL
• Microsoft SQL Server
• Oracle Corporation
• Sybase Inc
• IBM DB2

SQL

• Introduction to SQL
• Transact-SQL Reference
• Oracle Documentation

Articles

• A Relational Model of Data for Large Shared Data Banks - E.F. Codd
• An introduction to Database Normalization
• Normal Form Definitions & Examples
• What is XQuery
• Interactive Online SQL Training
• SQL.ORG Online Resources

ER Diagramming Tools

• Modelling Tools Info

• Dia Open Source Project
• Object Management Group - UML
• CASE Studio 2
• DeZign for databases
• ER/Studio
• ERCreator
• Entity Relationship Diagram (ERD) editor

Additional Tools and Sites

• MySQL Forge
• MySQL Developer Zone
• TOAD
• CodeBase
• Oracle Development Tools
• Database Development Tools

ACID

The basic properties of a database transaction ACID: Atomicity, Consistency, Isolation, and Durability.

* Atomicity - The entire sequence of actions must be either completed or aborted. The transaction cannot be partially successful.

* Consistency - The transaction takes the resources from one consistent state to another.

* Isolation - A transaction's effect is not visible to other transactions until the transaction is committed.

* Durability - Changes made by the committed transaction are permanent and must survive system failure.