CPSC 203: Introduction to computers  

James Tam

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).