Lecture notes and databases
Click on a title to see the list of topics in that chapter.
Use the download links to get lecture handouts in PDF format or lecture slides in PPT format. For some topics ou can also get a database to which the notes refer. Databases should open in Microsoft WebMatrix
Download
- notes | slides
Contents
What is a
database?
Databases vs. Database Management Systems
Relational and other database systems
Databases and
enterprise information systems
The language of relational
databases – SQL
Popular relational database systems
Designing a database
The data model
From data model to relational database
Download
- notes | slides
Contents
Database normalisation
Problems with un-normalised data
Functional dependencies
Normalisation and normal forms
First normal form (or 1NF)
Second Normal Form (2NF)
Third normal form (3NF)
Summing up the first three normal
forms
Higher normal forms
When to use
normalisation
Some notes are in PDF format - you may need Adobe Reader to view and print them. You can download it using the link below:
