Business and technology qualifications, Levels 3-6, in Brussels. Explore qualifications
Portal login
Level 6 Diploma in Information Technology

Applying Advanced Database Management Systems in practice: case studies

IT603 · Advanced Database Management Systems — Week 12 of 16

CourseIT603
Week12 of 16
SemesterI
TutorOnline in the course chat

This week’s topics

Applying Advanced Database Management Systems in practice: case studies

  1. Case analysis
  2. Linking theory to practice
  3. Evaluating evidence

What you will be able to do

  • 1.1 Assess how relational database models and normalisation provide reliable and efficient databases.
  • 1.2 Critically compare a range of Database Modelling languages.
  • 1.3 Critically evaluate different database management systems available in relation to open source and vendor-specific platforms.
  • 3.5 Evaluate security risks to the database.

Activity

Case-study workshop: apply the unit’s concepts to a real or realistic case and evaluate the outcome.

Study materials

Videos

  • 02 - Modern Analytical Database Systems (CMU Advanced Databases / Spring 2023) · YouTube · CMU Database Group · 53 min · for registered students
  • Efficient Reliable Database Migration: A Legacy Innovation Story • Dave Thomas • GOTO 2024 · YouTube · GOTO Conferences · 38 min · for registered students

Further resources

  • Readings in Database Systems ('Red Book', 5th ed., Bailis, Hellerstein & Stonebraker) · PDF · Other, textbook · for registered students
  • MIT 6.830 Database Systems (Fall 2010), lecture notes · Reading · MIT OpenCourseWare, course · for registered students
  • Five Misunderstandings About Case-Study Research · Reading · Arxiv, article · for registered students
Materials marked “for registered students” open in the student portal, which is set up as soon as you receive final acceptance.
Week 11Week 13
Course chat

Admitted students ask questions on this week’s page in the student portal: an AI assistant trained on the course answers first, and during the course’s timetabled classes Connect to your tutor brings your tutor into the chat, who may start a call if needed.

Open this week in the portal
Course plan
  • Week 1: Relational Theory and Normalisation
  • Week 2: Database Modelling Languages
  • Week 3: Database Engine Architecture and Platform Selection
  • Week 4: Logical Modelling and Normalisation Practice
  • Week 5: Physical Database Design and Build
  • Week 6: Advanced Querying and Data Extraction
  • Week 7: Database Access Control and Granular Security
  • Midterm: Midterm evaluation
  • Week 9: Database Threat Landscape and Risk Evaluation
  • Week 10: Database Functional and Performance Testing
  • Week 11: Database Administration and Enterprise Resilience
  • Week 12: Applying Advanced Database Management Systems in practice: …
  • Week 13: Assignment workshop: research, planning and referencing
  • Week 14: Assignment workshop: drafting, feedback and improvement
  • Week 15: Review and coursework completion
  • Final: Final assessment and submission
Back to the course
Scroll