Business and technology qualifications, Levels 3-6, in Brussels. Explore qualifications
Portal login
Level 5 Diploma in Cyber Security

Converting an ER diagram to SQL and deploying the schema in PostgreSQL for testing

CYB502 · Databases — Week 7 of 16

CourseCYB502
Week7 of 16
SemesterI
TutorOnline in the course chat

This week’s topics

Converting an ER diagram to SQL and deploying the schema in PostgreSQL for testing

  1. A relational database schema that satisfies user requirements

What you will be able to do

  • 2.4 Implement a relational database schema that satisfies user requirements.

Activity

Seminar, guided reading and a short written task: implement a relational database schema that satisfies user requirements.

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 6Midterm
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
Scroll