Course Information Undergraduate prospectus

Database Management and Administration

Course summary

Course code: COMP1638
Level: 6
Credits: 15
School: Architecture, Computing and Hums
Department: Computing and Information Sys.
Course Coordinator(s): Tatiana Simmonds

Specification

Pre and co requisites

Basic knowledge of SQL and relational databases

Aims

The aim of this course is to introduce more advanced database concepts and provide the necessary knowledge and practical skills of creating and maintaining the database including database users, objects and data. It also teaches how to protect the database by designing a backup and recovery strategy.

Learning outcomes

On successful completion of this course a student will be able to:

Critically evaluate the concepts and tools of the database management system.
Demonstrate systematic knowledge of the database architecture.
Design database backup and recovery strategy.
Develop critical awareness of issues relating to database management and practical skills to solve common database administration problems.

Indicative content

Exploring the database architecture; Creating the database; Managing the database instance; Managing database storage structures; Managing transactional processing and locking mechanism; Database security; Monitoring the database and using the advisors; Backup and recovery concepts; Investigating, reporting, and resolving problems.

Teaching and learning activity

Each week there will be a 2 hour lecture and a 1 hour practical session.
In the lecture students will be introduced to the issues affecting the design, development and management of the database. In the lab sessions students will learn how to create, maintain and protect the database.

Assessment

Logbook - 30% weighting, 40% pass mark.
Learning Outcomes - All.
Logbook includes: portfolio of weekly uploads.

Exam - 70% weighting, 40% pass mark.
Learning Outcomes - All.