COMP283

Applied Database Management

Aims

  1. To utilise Relational Algebra to develop efficient Database Query Language code.
  2. To provide practical experience of designing relational databases;
  3. To provide the skills to manage and maintain a database system using commercial Database Management Systems such as Microsoft SQL Server.
  4. To introduce the skills required to maintain data integrity and durability across database systems.

Syllabus

  • Introduction to Relational Algebra and Database Management Systems (2 Lectures, 2 Practicals)
  • Introduction to Design and Implementation of Relational Databases (3 Lectures, 3 Practicals)
  • Database Administration Concepts (4 Lectures, 4 Practicals)
  • Introduction to Inter-database connectivity and data warehousing (2 Lectures, 1 Practical)

Recommended Texts

  • Microsoft Official Academic Course: 98-364: Database Administration Fundamentals. WILEY 2011 ISBN 978-0-470-88916-9.
  • R. Elmasri, and S.B. Navathe: Fundamentals of Database Systems. Addison-Wesley (latest edition).
  • H. Garcia-Molina, J. D. Ullman, and J. Widom: Database Systems: The Complete Book. Prentice Hall (latest edition).
  • R. Rankins, P. T. Bertucci, C. Gallelli, A. T. Silverstein: Microsoft SQL Server 2008 R2 Unleashed. Sams (latest edition).

Learning Outcomes

At the end of the module the student should be able to:

  • design and structure an efficient scalable database system,
  • implement and configure a database system,
  • maintain a secure and durable database,
  • describe, illustrate and explain the concept of linked databases and data migration techniques.

Learning Strategy

Formal Lectures: In a typical week, students will be expected to attend one lecture for the duration of the module.

Practical Sessions: In a typical week, students will be expected to work for three hours in a supervised computer laboratory practical session under the guidance of demonstrators.

Private Study: In a typical week students will be expected to devote three hours to unsupervised time to private study. Private study will provide time for reflection and consideration of lecture and practical material and completion of those aspects of the assessments tasks that do not involve computer laboratory work.

Assessment: Four assessment tasks will be carried out to consolidate the information presented in the lectures and to provide practical experience of designing and realising an information system.

Optional Extra-Curricular: Students will be offered the opportunity to take the Microsoft IT-Associate exam in Database Administration Fundamentals, successful students would receive Microsoft Technology Associate Certification.