Introduction to Databases (CA 218)

         Student Consultation Times
                Student Surveys of Opinion

Lecture & Tutorial Timetable

Week
Lecture  Notes/
Handouts in pdf
(1Up, 3Up)
  Tutorials/Comments
1
 Chapters 1 & 2 (1Up, 3Up) No tutorial this week
2
 Chapter 3
(1Up, 3Up)
 Chapters 1 & 2: Database Overview (Tutorial sheet 1)
3
 Chapter 4
(1Up, 3Up) 		Chapter 3: Storage, Indexing and Hashing (Tutorial Sheet 2)
4
 Chapter 5
(1Up, 3Up) 		Chapter 4: Entity Relationship Data Modelling (Tutorial Sheet 3)
5
 Chapter 6
(1Up, 3Up) 		Chapter 5: Relational Data Model (Tutorial Sheet 4, Claus' Lab #5 & Tutorial #5, see here) 
6
 Chapter 7
(1Up, 2Up) 		Chapter 6: ER to Relational Mapping (Tutorial Sheet 5) 
7
 Chapter 7Supp
(1Up, 2Up) 		Chapter 7: SQL
  1. Have a look at the SQL "Try It" page, on W3Schools.com;
8
 Chapter 8
(1Up, 2Up)
 Chapter 7: SQL (Cont'd)

  1. When you are happy with that, log on to SQL Server (username and password will be emailed to you).
  2. Play around with the various databases there (you have read permissions on the "Northwind" and "pubs" databases there & read/write access to "ca218db" database (try these exercises for the latter database)
  3. Here are some query questions relating to the "Northwind" database for the tutorial session (here are the answers). NEW!
  4. Try executing the commands in the Sample Lab Exam here. NEW!
9
 No Lectures
 Lab Exam this week so no tutorial.
10
 Chapter 9
(1Up, 2Up) 		Chapter 8 & 9: Views and Normal Forms/Normalisation
(Tutorial Sheet 6 mis-labelled as "Week 11")
For help with this see this Additional SQL Example
11
 No Lectures Chapter 9: Normal Forms/Normalisation  (Tutorial Sheet 7) 
12