Napier University Module Descriptor

Module Number	CO22001		Credit Value :	15
Module Title	DATABASE SYSTEMS
Module Leader	DR G RUSSELL
School	Computing	Date of Approval

Indicative Student Workload [in Notionally Efficient Student Hours (NESH)]

	Contact	Flexible	Weighting of Assessment Components
Lectures	24		Supervised	60		%
Tutorials/Seminars			Continuous	40		%
Practical	24		Indicative Assessment Week (s) LO’s Covered Catalogue
Supervised assessment	2		Coursework		9		2,3
Student cent'd learning	100		Exam		15		1-5
Other (specify)
TOTAL WORKLOAD	150

Timetable Details:

Practical sessions run on standard networked PCs.

Prerequisite(s) [400 characters, normally module numbers and titles]

Rapid Application Development, CO12001 or equivalent.

Aims of Module

Allow the student to gain a good theoretical understanding of database primitives and concepts, combined with practical exercises in SQL and database design.

Learning Outcomes [maximum 5, contained in 1000 characters]

By the end of this module, the student will be able to:

1. Describe the three-level ANSI-SPARC architecture for database systems.

2. Implement a relational database schema from initial written specifications.

3. Utilise SQL and relational algebra for database manipulation.

4. Understand the techniques required to implement the components of a DBMS.

5. Describe DBMS techniques for recovery and concurrency control.

Description of Module Content [maximum 100 words contained in 500 characters]

DB architecture.

Data Analysis and E-R modelling.

Normalisation 1st to BCNF.

Logical and physical database design.

SQL and relational algebra.

DB operation including: transactions, concurrency, recovery, data storage, and security.

Set theory.

Notes [maximum 340 characters]

Formal Examination YES - duration in Hrs/Mins: 2hrs

LTA Approach:

Much of the theoretical content of the module is taught using lectures. Tutorials are used to reinforce this learning. The tutorials cover database design, SQL, and normalisation. Tutorial time is also used to support students working on the coursework. Finally, there are a number of on-line exam-style questions that can be discussed in both tutorials and lecture time.

Reading:

Introduction to SQL Rick van der Lans, Addison Wesley, ISBN 0-201-59618-0

Fundamental of Database Systems Elmasri/Navathe Addison-Wesley , ISBN 0-8053-1755-4

Database Systems Atzeni,Ceri,Paraboschi,Torlone, McGraw Hill,

ISBN 0-07-709500-6