CourseCYB502

Week6 of 16

SemesterI

TutorOnline in the course chat

This week’s topics

Normalisation using normal forms: reducing redundancy and improving data integrity

The process of normalisation and its importance in database design

What you will be able to do

2.3 Explain the process of normalisation and its importance in database design.

Activity

Seminar, guided reading and a short written task: explain the process of normalisation and its importance in database design.

Study materials

The teaching notes, exercises and videos of this week are in the student portal. Your portal is set up as soon as you receive final acceptance, so you can open them before the semester starts.

Week 5 Week 7

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: Database concepts: tables (entities), attributes and relati…
Week 2: Database models (hierarchical, network, relational) compare…
Week 3: Database management systems: MySQL, PostgreSQL and MongoDB …
Week 4: Queries and views; introduction to SQL: SELECT, INSERT, UPD…
Week 5: Requirements gathering and entity-relationship diagrams for…
Week 6: Normalisation using normal forms: reducing redundancy and i…
Week 7: Converting an ER diagram to SQL and deploying the schema in…
Midterm: Midterm evaluation
Week 9: SQL queries for extracting, updating and manipulating recor…
Week 10: Server-side programming with PHP: HTTP GET and POST, connec…
Week 11: Building a PHP web application on the database, including a…
Week 12: Applying Databases in practice: case studies
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