Introduction to Databases (CA 218)

         Tutorial Timetable

Week
 Comments
1
 No tutorial this week
2
 Chapters 1 & 2: Database Overview (Tutorial sheet 1)
3
 Chapter 3: Storage, Indexing and Hashing (Tutorial Sheet 2)
4
 Chapter 4: Entity Relationship Data Modelling (Tutorial Sheet 3)
5
 Chapter 5: Relational Data Model (Tutorial Sheet 4, Claus' Lab #5 & Tutorial #5, see here) 
6
 Chapter 6: ER to Relational Mapping (Tutorial Sheet 5) 
7
 No Tutorial but you might want to get started on the first part of next weeks tutorial.
8
 Chapter 7: SQL 
  1. Have a look at the SQL "Try It" page, on W3Schools.com; it gives some simple SQL exercises that use the "Northwind" Database that you will be querying in the Lab Exam.
  2. Have a look at SQL AGGREGATE FUNCTIONS & GROUP BY on Claus' Lab #6 here.
  3. When you are happy with that, log on to SQL Server (username and password will be emailed to you).
  4. 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)
  5. Here are some query questions relating to the "Northwind" database for the tutorial session (here are the answers). NEW!
  6. Try executing the commands in the Sample Lab Exam here. NEW!
9
 Lab Exam this week so no tutorial.
10
 Chapter 9 & 10: Views and Normal Forms/Normalisation
11
 Chapter 9 & 10: Views and Normal Forms/Normalisation
(Tutorial Sheet 6) 
12