8.1. Reports
Reports typically describe the database instance.1 Their structure is often hierarchical, that is, it describes parent-child relationships. A report may have a heading for each parent, followed by a detail for each of its children. Parent-child relationships result from the database schema. For the reader’s convenience, we reproduce the canonical FD graph of the NUTS database here as Figure 8.1.
FIGURE 8.1 The canonical FD graph describing the Academic Records database, which determines what reports can be derived.
Consider a report that is focussed on Enrolments. Enrolments has two parents: Subjects and Candidates. A report about Enrolments ...
Get Systems Analysis and Synthesis now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
