Trace: » lesson_2

Login

You are currently not logged in! Enter your authentication credentials below to log in. You need to have cookies enabled to log in.

Login

You don't have an account yet? Just get one: Register

Forgotten your password? Get a new one: Send new password

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,