Intermediate level · Module 6: Intermediate Database Project · Lesson 1 of 3
Project Design
Turn the NGO's requirements into an approved ER diagram, schema and list of reports.
In this lesson you will
- Produce a complete design from requirements
- Plan reports from the users' questions
Key concepts
requirementsER diagramreport specificationdesign approval
The lesson
List the users — registration staff, programme managers, donors — and the questions each needs answered. Each question becomes a report or view.
Draw the ER diagram, normalise and write the schema with constraints. Note any denormalisation with its reason.
Have the design approved before building: it is the contract for the rest of the project.
Step by step
- List users and their questions.
- Draw and normalise the ER diagram.
- Write the schema with constraints.
- Specify each report and get approval.
Practice activity
Submit the design pack for approval.
Expected result: An approved ER diagram, schema script and report list.
Check your understanding
-
Where do report requirements come from?
Show answer
From the questions each group of users needs answered.
-
Why document denormalisation?
Show answer
So others understand the reason and do not 'fix' it by mistake.
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.