Database Management Option for BSc IS&M

Links

• BSc IS&M Course Page

Timetable - Spring Term Wednesday Evenings

• 6.00-7.25 : Lecture in SH124 in Malet Street.
• 7.35-9.00 : Lab session in SH131.

Course Notes

• Course Structure
• Introduction
• Entity Relationship Diagrams
• Relational Model
• Querying a Relational Database
• Creating Relational Schemas
• Modifying a Relational Database
• Integrity Constraints in the Relational Model
• Relational Database Design
• Normal Forms
• Normalisation Algorithms
• Object Relational Databases
• Retrieving Information from the Web

        Full set of notes for printing

LabSheets

• Supply-Parts ACCESS database
• LABSHEET 1: creating a table, primary keys and data types
• LABSHEET 2: simple queries on a single table using selection, projection, operators and wildcards
• LABSHEET 3: queries and aggregates
• LABSHEET 4: updating records, adding, removing and changing data (ACCESS database tables for Labsheet)
• LABSHEET 5: multiple tables, referential integrity and join relationships
• LABSHEET 6: querying multiple tables
• LABSHEET 7: null values and outer joins (ACCESS database tables for Labsheet)
• LABSHEET 8: Joins with multiple tables
• LABSHEET 9: Simple SQL queries
• LABSHEET 10: SQL Queries
• Additional EXERCISE: SQL queries over single tables

Coursework

Compulsory Coursework, due on March 16 2010.