Additional Resources for HW1

Some students have asked for pointers to additional material on databases, database modeling and SQL.  Here are some pointers we have used in past years in this class:

Structured Query Language (SQL) and Relational Algebra

• Very basic introduction to SQL
• More on SQL
• Even more on SQL
• More detail regarding the Oracle implementation of SQL (pdf)
• In depth view of one of the two languages behind relational database operations: relational algebra (pdf)
• A good, short book on SQL: Teach Yourself SQL in 10 Minutes
• A pdf on MS Access SQL.

Conceptual Modeling & UML

• Brief Introduction to Conceptual Graphs
• Conceptual graph examples
• Introduction to the use of conceptual graphs for medical databases
• Paper on tradeoff in the modeling of large clinical databases (pdf)
• Introduction to UML - the most commonly used conceptual modeling formalism