In this chapter, we introduced the basic concepts of database design, and which ones are more suited to reporting. We have also seen how a balance between report speed and data loading needs to be struck, given limited resources.
To ensure that your database is useful to its customers, it should achieve certain objectives which are met using rules and goals that you lay down in the initial design phase and follow up in each design choice.
Implementing a database does not stop when the objects are created, but should be followed up with a continuous monitoring and maintenance process.
In the production of this book, we have created a small warehouse for reporting on Tennis Statistics. All the database objects and data are available for download ...