CIT844

Advanced Database Management Systems

Sciences
800 level
2 credit units
391 pages
21 units

This course introduces advanced concepts in Database Management Systems. It covers relational database design, implementation, and advanced SQL. Students will explore query processing, transaction management, security, and distributed databases. The course also delves into emerging database models, XML integration, data warehousing, and data mining techniques. Practical examples using PostgreSQL and Oracle are included to enhance understanding of real-world DBMS architectures.

Start reading

About this course

Difficulty: Intermediate
Study hours: 208 hours
Maths: Basic
Content: Theoretical, practical, case study
Practical work: Yes

Before you start

Basic database concepts
SQL fundamentals

How it is assessed

Assignments
Tutor marked assessments
Final examination

What you'll read

The real module and unit structure of CIT844, taken from the course material NOUN publishes.

Module 1 · Database Design and Implementation

Module 2 · Advanced Features and DBMS

Module 3 · Distributed Databases

Module 4 · Emerging Trends and Examples of DBMS Architecture

One paragraph, so you can see how it reads

CIT844 · Unit 1: Emerging Database Models

In the formal relational model terminology, a row is called a tuple, a column header is called an attribute, and the table is called a relation. The data type describing the types of values that can appear in each column is called a domain. We now define these terms – domain, tuple, attribute, and relation – more precisely.

Start reading Get the original PDF, if you want it

What you should be able to do

Describe relational database design principles
Implement advanced SQL queries
Explain transaction management techniques
Design distributed databases
Apply data warehousing concepts
Utilize data mining technologies
Understand emerging database models

What it prepares you for

Careers

Database Administrator
Data Analyst
Data Scientist
SQL Developer
GIS Analyst

Where it is applied

Finance
Healthcare
E-commerce
Logistics
Government

Tools

ORACLE
PostgreSQL

Where it gets hard

The units students slow down on, and what makes each one heavy.

Module 1: Database Design and Implemental
Unit 3: Advance SQL
Advanced SQL syntax and usage require extensive practice and understanding of relational database principles.
Module 2: DBMS Advance Features
Unit 2: Transaction Management and Recovery
Understanding concurrency control with locking, timestamping, and optimistic methods requires grasping complex synchronization concepts.
Module 3: Distributed Databases
Unit 1: Enhanced Database Models
Distributed query processing involves understanding replication, fragmentation, and various join strategies, requiring strong analytical skills.

A suggested way through it

Suggested

13 weeks, about 60 hours in total. Yours will differ.

Week 1Module 1: Database Design and Implemental
- Unit 1: Relational Database Design · 4 hours
  Understand relational database model concepts. Study domains, attributes, tuples, and relations. Explore characteristics of relations. Practice relational constraints.
Week 2Module 1: Database Design and Implementation
- Unit 2: Database Implementation · 4 hours
  Learn conceptual, logical, and physical database design phases. Study database creation, loading, and conversion. Explore system procedures and security measures. Practice testing and evaluation techniques.
Week 3Module 1: Database Design and Implementation
- Unit 3: Advance SQL · 4 hours
  Understand SQL statements and their usage. Practice SQL queries on relational databases. Explore advanced SQL features. Complete Tutor Marked Assignment.
Week 4Module 1: Database Design and Implementation
- Unit 4: Database System Catalog · 4 hours
  Learn the purpose and structure of database system catalogs. Study metadata management. Complete Tutor Marked Assignment.
Week 5Module 2: DBMS Advance Features
- Unit 1: Query Processing & Evaluation · 4 hours
  Study query interpretation and equivalence of expressions. Explore selection and natural join operations. Learn estimation of query-processing costs. Study join strategies.
Week 6Module 2: DBMS Advance Features
- Unit 2: Transaction Management and Recovery · 4 hours
  Understand transactions and their properties. Study transaction management with SQL. Explore concurrency control and locking methods. Learn database recovery management.
Week 7Module 2: Advanced Features and DBMS
- Unit 3: Database Security & Authorization · 4 hours
  Study security and integrity violations. Explore authorization and views. Learn integrity constraints and encryption. Understand statistical databases.
Week 8Module 3: Distributed Databases
- Unit 1: Enhanced Database Models · 4 hours
  Study distributed databases and their structure. Explore trade-offs in distributing databases. Learn design of distributed databases. Understand transparency and autonomy.
Week 9Module 3: Distributed Databases
- Unit 2: Object Oriented Database · 4 hours
  Study features of object-oriented DBMS. Explore object-oriented database design. Learn how OO concepts influenced the relational model.
Week 10Module 3: Distributed Databases
- Unit 3: Database and XML · 4 hours
  Define the purpose of XML. Study XML trees and syntax rules. Explore XML elements and attributes.
Week 11Module 3: Distributed Databases
- Unit 4: Introduction to Data Warehousing · 4 hours
  Learn data warehousing concepts. Study data warehouse architectures. Explore logical versus physical design. Learn data warehousing schema and objects.
- Unit 5: Introduction to Data Mining · 4 hours
  Learn data mining uses and functions. Study data mining technologies.
Week 12Module 4: Emerging Trends and Example of DBMS Architecture
- Unit 1: Emerging Database Models · 4 hours
  Study limitations of conventional databases. Explore multimedia and temporal databases. Learn temporal data semantics and modeling temporal data.
Week 13Module 4: Emerging Trends and Example of DBMS Architecture
- Unit 2: The Major Application Domains · 4 hours
  Study database on the World Wide Web. Explore GIS applications. Learn GENOME data management. Understand digital libraries.
- Unit 3 PostgreSQL · 4 hours
  Study PostgreSQL and its features. Explore open source software.

Preparing for the exam

What to do

Review all SQL syntax and practice writing complex queries (Units 3, 4)
Create diagrams illustrating transaction management concepts (Unit 6)
Study distributed database design principles and replication strategies (Unit 7)
Focus on data warehousing schemas and their applications (Unit 8)
Practice identifying data mining techniques for different scenarios (Unit 9)
Understand the characteristics of emerging database models (Unit 10)
Review the major application domains and their database requirements (Unit 11)

Questions students ask about this course

What is CIT844 about?

How many units does CIT844 have?

CIT844, Advanced Database Management Systems, has 21 units across 4 modules, over 391 pages of course material. You can read it one unit at a time.

How many credit units is CIT844?

CIT844 carries 2 credit units, at 800 level in Sciences.

Is CIT844 hard?

CIT844 is rated intermediate level, with basic mathematical content. It is mostly theoretical, practical and case study work, and it has a practical component.

How long does CIT844 take to study?

About 208 hours of study, spread across its 21 units.

How is CIT844 assessed?

CIT844 is assessed by assignments, tutor marked assessments and final examination.

What do I need before starting CIT844?

Basic database concepts SQL fundamentals

What can I do with CIT844?

Database Administrator, Data Analyst, Data Scientist, SQL Developer and GIS Analyst.