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

Physical Database Design and Build

IT603 · Advanced Database Management Systems — Week 5 of 16

CourseIT603
Week5 of 16
SemesterI
TutorOnline in the course chat

This week’s topics

Physical Database Design and Build

  1. DDL script development
  2. Table space allocation
  3. B-tree and hash indexing
  4. Referential integrity constraints
  5. #07 - Database Hash Tables ✸ YugabyteDB Database Talk (CMU Intro to Database Systems)

What you will be able to do

  • 3.1 Design and build a database structure.

Activity

Start with this week’s video, then: Seminar, guided reading and a short written task: design and build a database structure.

Study materials

Videos

  • #07 - Database Hash Tables ✸ YugabyteDB Database Talk (CMU Intro to Database Systems) · YouTube · CMU Database Group · 81 min · for registered students
  • 07 - Hash Tables (CMU Intro to Database Systems / Fall 2022) · YouTube · CMU Database Group · 83 min · for registered students

Further resources

  • MIT 6.830 Database Systems (Fall 2010), lecture notes · Reading · MIT OpenCourseWare, course · for registered students
  • Readings in Database Systems ('Red Book', 5th ed., Bailis, Hellerstein & Stonebraker) · PDF · Other, textbook · for registered students
  • Introduction to Computer Science, ch. 8: Data Management · PDF · OpenStax, textbook chapter; pp. 369–438 · 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 4Week 6
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