Database Answers

Printer Printer-friendly version.

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Car Parking Enforcement
Back to the Data Model.
This Star Schema is useful for thinking about a Reporting Database.

Car Parking Enforcement Star Schema Data Model This Schema is designed to answer questions such as :-
"What percentage of PCNs are challenged ?"

More complex Questions might require a more complex Schema where Events are joined to the original PCN to provide an at-a-glance analysis.


Barry Williams
29th. December 2007
Principal Consultant
Database Answers

 

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map