Lesson 2 - Describing the tables

What does the title mean? Well in my eyes it means we will reverse engineer the database schema and describe the domain of the problem. We can see how it all fits together and understand a little more about the area we will be working on.

Here is that database schema again.. (click on it to see a larger version)

Orginal CYPD Database Schema

First we will have a whistle stop tour of the tables and their relations.. Lets start in the middle with the org.. or ‘Organisation’, its the main entity from which most other things relate to, it will the organisations attributes on which most people will be searching.

I wont go into all of the attributes of the organisation here, as this is an old model and I would prefer to describe the newer version.. :oP but we will mention one or two,