Database Design - Course Contents

Navigation:

---

Site Home

Computing Home

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

---

 

Use this page as your starting point for the database design course. The left column of the table (below) contains links to the web based version of the course, whilst the right column contains links to the printable version (pdf format).

 

Before starting the course you should donwnload the Microsoft Access database that the course is based on (below):

 

Download Database here (Student Records.mdb)

 

 

As you progress through the course you should attempt the on-line quiz that accompanies each section; you can access these tests here (On-line tests).

 

A printable version (.pdf) version of this course can be found here.

 

The Database Design Course

Session	Topic
Essential Pre-course Information	Schedule of Work. Aims & Objectives. Initial data (web page). Reading List.
Session 1:	Database Terminology and Access Tables.
Session 2:	Boolean Logic and queries.
Session 3:	Reports.
Session 4:	Forms.
Session 5: Use this session to ensure that you are up to date with your work OR have go at extending your knowledge of Access by investigating the use of Macros.	Macros (optional section).
Session 6:	Introduction to Relational Databases.
Session 7:	Normalisation.
Session 8:	Entity Relation Modelling.
Session 9:	Data Warehousing.
Session 10: Use this session to ensure that you are up to date with your work OR have go at exploring the "generic" language of relational database manipulation - SQL.	Structured Query Language (optional section).
Appendices:	Appendix A (Validation Rules and Input Masks). Appendix B (Visual Basic Code used to embed SQL statements).

 

This work is licensed under a Creative Commons License.