CS2312

• Pair Grouping Form
• Lab manual (PDF)
• Using Oracle 8i (PDF)
• Using Integrity Constraints (PDF)
• Oracle online documentation library
• Table repair script for lab
• Basis file for dia
• Lecture notes:
• Introduction (PPT, PDF)
• Relational Data Model (PPT, PDF)
• Relational Query Languages (PPT, PDF)
• Using SQL (PPT, PDF)
• Views (PPT, PDF)
• EER Modelling (PPT, PDF)
• Normalisation (PPT, PDF)
• Normalisation Example (PPT, PDF)
• Internal Schema Design, Performance & Indexing (PPT, PDF)
• Transaction Processing, Recovery and Concurrency Control (PPT, PDF)
• Integrity Constraint Management (PPT, PDF)
• Database Connectivity (ODBC, JDBC and SQLJ) (PPT, PDF)
• Operational Design (PPT, PDF)
• **Database Procedural Programming (PPT, PDF)** NOTE: may be omitted
• Suplementary notes (joins etc.) (PPT, PDF)
• Revision (PPT, PDF)
• Reading list (Elmasri and Navathe) (PPT, PDF)
• Examples sheets:
• Sheet 1 (PDF)
• Sheet 2 (PDF)
• Sheet 3 (PDF)
• Sheet 4 (PDF)
• Example Exam Questions:
• Questions (PDF)