Registry

Module Specifications

Current Academic Year 2009 - 2010
This information is provisional and subject to change.

Module Title	Introduction to Databases
Module Code	CA218
School	Computing
Online Module Resources
Module Co-ordinator	Dr Martin Crane	Office Number	L2.51
Level	2	Credit Rating	5
Pre-requisite	None
Co-requisite	None

Module Aims

To provide students with an introduction to and an overview of database systems including database design, Entity Relationship data modelling, the relational model of data and SQL, as well as an overview of some database products.

Learning Outcomes

As a result of this course, students will be in a position to design and implement a database for real world application, covering all stages of the process from conceptual design and layout through to writing SQL for transactions. Students will also be very familiar with SQL.

Indicative Time Allowances
	Hours
Lectures	24
Tutorials	12
Laboratories	12
Seminars	0
Independent Learning Time	27

Total	75
Placements
Assignments

NOTE

Assume that a 5 credit module load represents approximately 75 hours' work, which includes all teaching, in-course assignments, laboratory work or other specialised training and an estimated private learning time associated with the module.

Indicative Syllabus

· Chapter 1. Information Systems · Chapter 2. Database Overview · Chapter 3. Storage Structures · Chapter 4. Entity-Relationship Data Modelling · Chapter 5. Relational Model of Data · Chapter 6. SQL · Chapter 7. Overview of Database Products · Chapter 8. The System Catalog · Chapter 9. Views · Chapter 10. Database Design & Normalisation · Chapter 11. Web Databases and JDBC