Advanced level · Module 6: Database Capstone · Lesson 1 of 5
Capstone Requirements and Design
Gather requirements for the multi-site health programme and design the schema, roles and targets.
In this lesson you will
- Produce a design covering schema, roles and service targets
- Agree RPO, RTO and performance targets
Key concepts
multi-site requirementsschema designrole designservice targets
The lesson
Clinics in several locations record patients and visits; managers need reports; auditors need oversight. Write requirements for each group, including which data each may see.
Design the schema with constraints, the roles and row-level policies, and the reports. Agree measurable targets: query response times, RPO and RTO.
Review the design against the threat model from the security module before building.
Step by step
- Write requirements per user group.
- Design the schema and access model.
- Agree performance and recovery targets.
- Review against the threat model.
Practice activity
Submit the capstone design for milestone 1.
Expected result: An approved design with access model and measurable targets.
Check your understanding
-
Why agree measurable targets at the start?
Show answer
So the final system can be proven to meet them.
-
What should the access model specify?
Show answer
Which roles can see and change which data, including row-level rules.
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.