Databases: Storage and retrieval of information
Overheads
Relevant text book chapters (Fluency Chapter 16, don’t worry the XML
references)
In addition before you start this material you should download and look
through the example that I will be referring to in lecture [Access
example]
Learning objectives
- Knowing what is the basic structure of a database and the advantage
of using a database over other programs
- How to form basic queries using SQL
- How to normalize a database (1st, 2nd and up to and including 3rd
normal form).