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

Logical Modelling and Normalisation Practice

IT603 · Advanced Database Management Systems — Week 4 of 16

CourseIT603
Week4 of 16
SemesterI
TutorOnline in the course chat

This week’s topics

Logical Modelling and Normalisation Practice

  1. Translating domain requirements into UML class diagrams
  2. Normalization of complex datasets
  3. Domain constraint specification
  4. Relationship multiplicity
  5. Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF

What you will be able to do

  • 2.1 Apply data modelling techniques to refine logical data requirements and normalize.
  • 2.2 Use a standard unified modelling language (UML) notation to document logical data requirements.

Activity

Start with this week’s video, then: Seminar, guided reading and a short written task: apply data modelling techniques to refine logical data requirements and normalize.

Study materials

Videos

  • Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF · YouTube · Decomplexify · 29 min · for registered students
  • Relational Database Design – Full Course · YouTube · freeCodeCamp.org · 355 min · for registered students

Further resources

  • MIT 6.830 Database Systems (Fall 2010), lecture notes · Reading · MIT OpenCourseWare, course · for registered students
  • Introduction to Computer Science, ch. 8: Data Management · PDF · OpenStax, textbook chapter; pp. 369–438 · for registered students
  • Foundations of Information Systems, ch. 3: Database Management Systems · PDF · OpenStax, textbook chapter; pp. 91–124 · 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 3Week 5
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