Module Descriptor

15/08/2012

Code:

CE00856-5

Version:

2

Approval Status:

Valid Current

Title:

DATABASE SYSTEMS

Section:

Computing, Engineering & Technology

Level:

5

Contact

E-mail Address

VLE

ROB KINMOND

[email-masked]

Blackboard

Pattern Of Delivery

Credits

15

Contact Hours

Independent Study Hours

Total Learning Hours

36

114

150

Description of Pattern of
Delivery

Pattern 1, study 100% in period
1

Site

STAFFORD

Registration Conditions

Module Version Condition Text

None

Module Details

Assessment Details

A COURSEWORK weighted at 100%.

A coursework portfolio
weighted at 100% comprising:-
An assessment in two parts:

Part 1 (40%) A design and justification report based on a given
scenario. (Learning outcomes 1 and 4)
Part 2 (60%) A build and
reflection of the system designed in part 1.
(Learning outcomes 2
and 3)

Indicative Content

Entity models, relational design, mapping designs to
implementations, normalisation and de-normalisation.
Database
languages i.e. SQL: DML, DDL and DCL and PL/SQL
Developing
applications with appropriate database portal tools
Database
reliability, integrity and concurrency control.
Introduction to
client server web databases using ASP.
Introduction to XML and
related database technologies.
Globalisation and localisation
issues within database

Learning Strategies

The module aims to allow you to work in your own time at your
own pace, with lecturers being available during the two set
tutorial/practical sessions each week to offer assistance where
required. Extensive use is made of the technique of learning via
problem solving with each student having their own database account.
The course relies heavily on prescribed reading with lectures
supporting you in difficult areas. You will be able to identify the
extent and type of help you require from these sessions by active
learning self assessments which will be provided as an integral part
of the module. There will be 12 lectures and 24 tutorial/practical
sessions, the latter normally delivered to groups of 20 students per
tutor.
(1:n)1 (1:20)2

Prospectus Information

The module aims to develop your knowledge and understanding of
the application of database technologies. There is a strong
practical element requiring you to justify your database design and
reflect on the database system you will create to solve a given
problem scenario.

Resources

ORACLE relational database management system
The
Library
ITS and Computing Labs

Special Admissions Requirements

None.

Texts

Designing Effective Database Systems
(Available as e-book in
University library)
By: Rebecca M. Riordan
Publisher:
Addison-Wesley Professional
Pub. Date: January 10, 2005
Print
ISBN-10: 0-321-29093-3
Print ISBN-13:
978-0-321-29093-9

Learning Outcome

1) ANALYSE SITUATIONS AND/OR ENVIRONMENTS FOR THE
APPLICATION OF A DATABASE SOLUTION.

Analysis

Problem Solving

2) CREATE, ALTER AND REMOVE RELATIONAL TABLES, INDEXES AND DATA
USING AN APPROPRIATE DATABASE LANGUAGE.

Problem Solving

3) DEFINE THE CENTRAL CONCEPTS OF DATABASES, INCLUDING
CONSTRAINTS IN THE DESIGN OF A DATABASE DUE TO ISSUES OF CONCURRENCY
AND INTEGRITY.

Knowledge & Understanding

4) DESIGN AND JUSTIFY THE DESIGN OF A DATABASE SYSTEM
AND SELECT, JUSTIFY THE SELECTION AND EXPLOIT ANY ASSOCIATED
UNDERPINNING TECHNOLOGIES.

Communication

Knowledge & Understanding

Problem Solving