Module Descriptor

15/08/2012

Code:

CE00332-6

Version:

5

Approval Status:

Valid Current

Title:

ADVANCED DATABASE SYSTEMS

Section:

Computing, Engineering & Technology

Level:

6

Contact

E-mail Address

VLE

CLARE STANIER

[email-masked]

Blackboard

Pattern Of Delivery

Credits

15

Contact Hours

Independent Study Hours

Total Learning Hours

24

126

150

Description of Pattern of
Delivery

Pattern 1, study 100% in period
1

Site

STAFFORD

Registration Conditions

Module Version Condition Text

SPECIAL ADMISSIONS REQUIREMENT

CE00318-5

Module Details

Assessment Details

A COURSEWORK weighted at 100%.

A coursework weighted at
100% made up of:-

1) Assignment weighted at 70% (Learning
Outcomes 1, 2 and 3)
2) Management Style Report - 1500 words
weighted at 30% (Learning Outcome 4)

Indicative Content

Advanced database architectures, N-Tier, Grid Computing,
Distributed Databases.
Data Models, Relational and
Object-Relational technologies, query languages including advanced
SQL and Object SQL,
Advanced Design and design issues, database
development and performance.
Current trends in Database
development, including knowledge management, web and mobile
databases, database issues for complex data including forensic and
biometric data.

Learning Strategies

This module will develop knowledge of current DBMS support for
Information Systems. You will acquire the ability to make informed
DBMS selection from a critical appreciation of key database issues.
Theoretical and contextual material will be presented in lectures
and tutorials. You will carry out academic research to complement
the subject matter some of which will be integrated into the
assessment. You will be provided with practical exercises to enable
you to see how the theories are put into practice.
1 lecture and
1 practical per week, (1:n)1 (1:20)1.

Prospectus Information

This module will develop knowledge of current DBMS support for
Information Systems. You will acquire the ability to make informed
DBMS selection from a critical appreciation of key database issues.
Theoretical and contextual material will be presented in lectures
and tutorials. You will carry out academic research to complement
the subject matter some of which will be integrated into the
assessment. You will be provided with practical exercises to enable
you to see how the theories are put into practice.

Resources

-ORACLE relational database management system, students will
require access to the SQL*PLUS and Developer 2000 products.
-sql
server, MySQL
- The Library,
- ITS and Computing labs
-
NetBeans

Special Admissions Requirements

Prior study of Database and Systems or equivalent.

Texts

Date C J, Database System, 8th Edition Vol 1 Addison-Wesley
2004, ISBN: 0321189566

Connolly T, Begg C, Database Systems,
4th Edition, Addison Wesley, 2005, ISBN: 0201342871

Various
internet based materials

Learning Outcome

1. EXPLAIN AND CRITICALLY EVALUATE CONTEMPORARY
DATABASE ARCHITECTURES AND DATABASE MANAGEMENT ISSUES.

Analysis

Knowledge & Understanding

2. CREATE, IMPLEMENT AND CRITICALLY TEST AND EVALUATE AN
ADVANCED DATABASE DESIGN.

Knowledge & Understanding

3. ANALYSE AND CRITICALLY EVALUATE DATABASE MODELS AND
QUERY LANGUAGES.

Analysis

Enquiry

4. DISCUSS THE PROJECTED FUTURE DIRECTIONS OF DATABASE
TECHNOLOGY IN TERMS OF DESIGN, HARDWARE AND SOFTWARE
IMPLEMENTATIONS.

Learning