Databases

Course Description (pdf)

1M of this course is given as lectures, 1M as self-study course. The self-study course will be implementing a web-based database system for a given problem. Below is the schedule for the 1M lectures.

Literature:

• [1] A. Silberschaltz, H. Korth, S. Sudarshan, Database System Concepts, 5th Ed., 2006

OR
• [2] A. Silberschaltz, H. Korth, S. Sudarshan, Database System Concepts, 4th Ed., 2002

Files:

• Lecture 1 exercises from [1]: l1_exercises.pdf
• Lecture 4 PHP examples: index.php, insert.php
• Show Lecture 4 example: ./php/
• MySQL Referential Integrity Tutorial
• Lecture 5 PHP example: login.php,
• Show Lecture 5 example: ./php/login.php
• Lecture 5 HTAccess example: .htaccess,

Lecture 1: Introduction to Databases and the Relational Algebra

• Time: Thursday 7/9 2006, 12:30-16:15
• Place: Niels Jerners Vej 14 - 3-119
• Lecture Notes: pdf
• Literature:
  • [1] Chapter 1 (browse) and Chapter 2
  • [2] Chapter 1 and Chapter 3

Lecture 2: Structured Query Language (SQL)

• Time: Thursday 14/9 2006, 12:30-16:15
• Place: Niels Jerners Vej 14 - 3-119
• Lecture Notes: pdf
• Literature:
  • [1] Chapter 3
  • [2] Chapter 4

Lecture 3: The Entity-Relational Model

• Time: Thursday 21/9 2006, 12:30-16:15
• Place: Niels Jerners Vej 14 - 3-119
• Lecture Notes:
• Literature:
  • [1] Chapter 6
  • [2] Chapter 2

Lecture 4: PHP Interface to MySQL

• Time: Monday 23/10 2006, 12:30-16:15
• Place: Fredrik Bajers Vej 7A - A4-106
• Lecture Notes: pdf
• Literature:
  • None

Lecture 5: MySQL Authorization and PHP Sessions

• Time: Monday 6/11 2006, 12:30-16:15
• Place: Fredrik Bajers Vej 7A - A4-106
• Lecture Notes: pdf
• Literature:
  • [1] Sections 8.7 - .8.7.4
  • [2] Sections 6.6 - 6.6.3