Introduction to Desktop Databases
Links

Boolean Logic

• Elementary Boolean Logic (part of a larger page "factasia" on logic)

Access and SQL

• Microsoft Access tutorials: Access 2007 (by Microsoft)
• SQL Fundamentals by John Patrick (introductory book on SQL for Access and Oracle)
• Practical SQL Handbook by Bowman, Emerson, Darnovsky (book covers several SQL dialects)
• H2 Database Engine (supports all set operations)
• Notes by Lucia Dettori on how to use Visio for ER diagrams.
• Sample ER diagram by Lucia Dettori

Relational Database Model

• Codd's Twelve Rules

ER Modeling

• ER modeling (following Chen)
• Peter Chen's review of ER modeling

Textbook

• Pratt/Adamski, Concepts of Database Management, 6th edition
  • Sample Database downloads (two executable files containing three databases: Alexamara.aacdb, Henry Books.aacdb, and Premiere Products.aacdb), also available as zip files on col.