Foundation degrees

Course Information

Database Architectures and Administration

Module summary

Module code: COMP1532
Level: 7
Credits: 15
School: Liberal Arts and Sciences
Department: Computing and Information Sys.
Module Coordinator(s): Tatiana Simmonds

Specification

Aims

The modern data growth is transforming performance and efficiency requirements for storage systems. The databases are getting more complex and more powerful which means that development and management of the database systems is only possible with a sound knowledge of architectures and techniques available.
This course will discuss the rationale, current trends and features of modern database practice.
It provides students with the tools and techniques to implement and administer complex database systems including backup and recovery.
It equips students with the skills required to develop creative solutions to information system problems using the latest database technologies.

Learning outcomes

On successful completion of this course a student will be able to:
1 Demonstrate a systemic knowledge and critical awareness of the rationale for and features of a range of database architectures.
2 Design, build and maintain complex database systems.
3 Devise strategies for managing database security, ensuring confidentiality, integrity and availability.
4 Demonstrate skills, self-direction and originality in identifying and solving various database problems.

Indicative content

Modern database features and architectures;
Managing database Instance;
Database storage management;
Query and transaction processing;
Managing users and schema objects;
Data presentation and security;
Database backup and recovery procedures;
Data manipulation between database systems.

Teaching and learning activity

Lectures - (1 hour) to introduce concepts and necessary theoretical background.
Lab work - (2 hours) to develop practical skills needed to apply the theoretical concepts.

Assessment

Must all elements of summative assessment be passed to pass the course? Yes

Method of SUMMATIVE assessment: Portfolio
Outcomes assessed:All
Grading Mode (e.g. pass/ fail; %): %
Weighting % :100%
Passmark: 50%
Word Length:n/a
Outline Details:Portfolio of several uploads.

Nature of FORMATIVE assessment supporting student learning:
Feedback on quiz (logbook) results
Feedback from lab tutors on lab-based tutorial exercises