PC Databases

 

1        Lect       Part 1: Introduction to and overview of the module. 

Part 2:  Relational principles.

 

 2       Lect       Part 1: Integrity constraints.

Part 2:  Joining tables, main/sub forms and reports.

 

 3       Lect       Relational algebra.

   Prac       Assignment 1: in class, individual test.

 

4        Lect       E-R modelling.

 

 5       Lect       Normalisation.

 

 6       Lect       Assignment 2 Part 1: in class, individual test.

 

 7       Lect       Physical database design.

 

 8       Lect       Database integrity, security and recovery.

Prac       Assignment 2 Part 2: in class, individual test.

 

 9       Lect                   Exam Revision.

 

10      Examination period

 

Text Books:             

1. “Access 97 Further Skills” - S Coles & J Rowley, ISBN  (1-85805-300-5)
2. “Database Design & Management using Access” - Nick Dowling, ISBN (1-85805-361-7)