Lecture Notes

• Printed copies (4-up, double-sided) of the course notes will be available through the Graphic Services outlet in the Davis Centre.
• The lecture notes are also available in Postscript form.  Each of the links below will get you the Postscript version of one section of the notes.
• Introduction
• Relational Model
• SQL
• Embedded SQL
• E-R Models
• E-R to Relational
• Database Design
• Transactions
• File Structures
• Query Processing
• Query Optimization
If you intend to print sections of the notes on your own, you will probably find the commands psselect and psnup handy.  The former allows you to select which pages you wish to print.  The latter allows you to arrange several reduced pages on a single sheet of paper.  Both commands should be available on all of the MFCF machines.
• These notes are evolving - the links above will always point to the latest version.    The link below will get you a Postscript delta file containing only those slides that are too new to have been included in the printed notes sold by Graphic Services.
•  W02 New Slides