Intermediate level · Module 6: Intermediate Database Project · Lesson 3 of 3
Reports, Documentation and Presentation
Write the reports and application script, document the database and present it.
In this lesson you will
- Deliver correct, documented reports
- Present the database to its users
Key concepts
reporting viewsdata dictionaryuser guidepresentation
The lesson
Implement each report as a view or saved query, check results against hand calculations and document what each shows.
Write a data dictionary (tables, columns, meanings, rules) and a short guide for staff on common tasks, such as registering a household with the script.
Present to the 'NGO': show registration, a rejected duplicate, the main reports and how backups are taken.
Step by step
- Implement and check the reports.
- Write the data dictionary and user guide.
- Finish the registration script.
- Rehearse and present.
Practice activity
Complete and present the NGO Beneficiary and Distribution Database.
Expected result: Correct reports, complete documentation and a clear presentation to the 'client'.
Check your understanding
-
What does a data dictionary contain?
Show answer
Tables, columns, their meanings and rules.
-
What should the presentation demonstrate besides reports?
Show answer
For example registration, a rejected duplicate and how backups are taken.
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.