1. ER diagram
2. FIVE FUNDAMENTAL OPERATORS AND ADDITIONAL OPERATORS
3. QUERY OPTIMIZATION (PPT )
4. Relational Database Design (PPT )
   THEORY OF FUNCTIONAL DEPENDENCIES
5. Tuple relational calculus
6. SQL
7. TRANSACTIONS, RECOVERY & CONCURRENCY CONTROL (PPT_Chinese, PPT )

• HW1 (Relational Algebra)
  
  Key Points:
  List the artists that have been a member of more than one group
  Maximum (Reference )
• HW2 (Tuple Relational Calculus)
  
  Key Points:
  Basic operations, Division and Max Value
• HW3 (SQL)
  
  Key Points

Software:

WinRDBI Educational Tool

• MidTerm Spring 2007
• Midterm solutions