The aim of the course is to provide you with an overview of database management system architectures and environments, an understanding of basic database design and implementation techniques, and practical experience of designing and building a relational database. By its conclusion you should be able to explain the importance of data, and the difference between file management and databases; be able to discuss the design of database management system architectures and environments (in particular the Ansi-Sparc model); have a good grasp of the principals of database design; explain and apply conceptual design methodologies, in particular conceptual design using Extended Entity Relationship modelling; explain and apply the relational model and mappings from conceptual designs, in particular normalisation; understand the physical and performance related design considerations including transaction processing; finally, to apply SQL to the Oracle DBMS.

• Lecture Slides Topics 01 to 05 inclusive (REMOVED)
• Lecture Slides Topics 06 to 10 inclusive (REMOVED)
• Lecture Slides Topics 11 to 14 inclusive (REMOVED)
• Lecture Slides Revision (REMOVED)
  
  
• Laboratory Manual
• Dia User Manual (160Kb pdf)
• (E)ER Dia File
• Programming SQL Appendix (2Mb pdf)
  
  
• Data Population File
• Table Repair File

• CS2312 Past Exam 2003/2004 (100Kb pdf)
• CS2312 Past Exam 2002/2003 (100Kb pdf)
• CS2312 Past Exam 2001/2002 (100Kb pdf)
  
  
• General Exam Information
• Exam Technique

• Schools Undergraduate Pages
• Schools 2nd Year Students Pages
• Careers Advice