Week | Topic | Practical |
1 |
Introduction to Database Design Introduction To U18 Databases Introduction To Databases Database Features Summary Database Glossary |
Create Database & Reports Databae Simple Queries |
------------------------------------------------------------------------- | ||
2 |
Database Design Design (Relationships) Database Queries |
Database Relationship exercise |
------------------------------------------------------------------------- | ||
3 |
Data Mod 1- Enitities Data Mod 2- Relationships Data Mod 3- Normalisation |
Data Entry Data Entry Forms |
------------------------------------------------------------------------- | ||
4 |
Normalisation Review Database Design-Conference Centre |
|
------------------------------------------------------------------------- | ||
5 |
Referential Integrity Referential Integrity |
|
------------------------------------------------------------------------- | ||
6 |
Importing/Exporting Data Importing Data |
Use a Query to Create Mailmerge |
------------------------------------------------------------------------- | ||
7 |
Errors in the Database Errors in Database Design |
|
------------------------------------------------------------------------- | ||
8 |
Testing the Database Testing A Relational Database |
|
------------------------------------------------------------------------- | ||
9 |
Recap & Review. Database Exercise |
|
------------------------------------------------------------------------- | ||
10 | ||
================================================ |