Software EngineeringEngineeringFrançais

Introduction to Database

SWE 124 · Semester 2

5 credits · 13 learning units

Lessons

13 of 13 learning units provide interactive tutorials with worked examples, diagrams, knowledge checks and subject mastery questions. Each check draws five questions from the available bank; question counts vary by unit. The remaining units provide preparation, guided practice or an independent project.

Subunit titles retain the curriculum’s original language.

Start here

  1. Lesson 1Records, entities, relationships and keysInteractive tutorial

Curriculum topics

  1. Lesson 2From paper files to databasesInteractive tutorial
  2. Lesson 3The database approach and the DBMSInteractive tutorial
  3. Lesson 4The database environment: three-schema architectureInteractive tutorial
  4. Lesson 5Data models and database languagesInteractive tutorial
  5. Lesson 6The Entity-Relationship modelInteractive tutorial
  6. Lesson 7The relational model: relations, keys and relationshipsInteractive tutorial
  7. Lesson 8Integrity constraints and NULLsInteractive tutorial
  8. Lesson 9Normalization and the normal formsInteractive tutorial
  9. Lesson 10Relational algebra and relational calculusInteractive tutorial
  10. Lesson 11Practical: loading and exploring a sample databaseInteractive tutorial

Put it into practice

  1. Lesson 12Guided laboratory: from one messy table to related tablesInteractive tutorial

Work independently

  1. Lesson 13Independent project: design a small library databaseInteractive tutorial
Curriculum source

HND Computer Engineering Software Engineering Curriculum.pdf · SWE 124 · Course table: p. 9 · Outline pages: 21, 22