Database Management · Intermediate level

Intermediate level · Module 6 of 6 · 17 guided hours

Intermediate Database Project

Design, build, load and report from the NGO Beneficiary and Distribution Database.

Learning objectives

  • Deliver a normalised, constrained database from requirements
  • Load and clean realistic data
  • Produce documented reports and present the project

Topics

  • requirements and ER design
  • schema script and constraints
  • data import and cleaning
  • views and reports
  • application script
  • documentation and presentation

Lessons

  1. Lesson 1 Project Design

    Turn the NGO's requirements into an approved ER diagram, schema and list of reports.

    requirementsER diagramreport specificationdesign approval

  2. Lesson 2 Building and Loading

    Create the database, import and clean the data and prove that the constraints work.

    schema scriptsimport pipelineconstraint testsaudit trail

  3. Lesson 3 Reports, Documentation and Presentation

    Write the reports and application script, document the database and present it.

    reporting viewsdata dictionaryuser guidepresentation

Practical activity

Build the level project in three reviewed stages: design, build and load, reports and presentation.

Expected outcomes

  • A complete database project
  • Documentation others can use

Assessment

The level project assessed against its criteria, including a demonstration of constraints and reports.

Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.