Database Management and Administration

Module summary

Module code: COMP1638
Level: 6
Credits: 15
School: Liberal Arts and Sciences
Department: Computing and Mathematical Sci.
Module Coordinator(s): Tatiana Simmonds

Specification

Pre and co requisites

Basic knowledge of SQL and relational databases

Aims

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. This course also teaches how to protect the database and how to identify and solve various database problems.

Learning outcomes

On successful completion of this course a student will be able to:
1 Critically evaluate the concepts and tools of the database management systems.
2 Demonstrate substantial ability to design, build and manage various database structures based on the specified business requirements.
3 Identify crucial database security issues and demonstrate ability to solve them in the timely manner.
4 Develop critical awareness of issues relating to database management and practical skills to solve common database management 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.
Other formative tasks include self-assessment quizzes.

Assessment

Coursework: 100% weighting, 40% pass mark.
Learning Outcomes: All.
Outline Detail: Build database admin system.
Maximum Wordcount: 3000 words.
Formative Assessment: Quizzes and tutorials.