home
tsql exercise 2 - data modelling
Author Nigel Rivett
Take the database schema you created in exercise 1 and populae it with the following
There are three schools
All Boys High
Bottington High
All Boys High
There are three teachers
Adam Askey
Bill Blowers
Adam Askey
The first Adam Askey works at the first All Boys High and Bottington High.
Bill Blowers only works at the first All Boys High.
The second Adam Askey does not work at a school in our system.
Note - different schools and teachers can have the same names. If your schema will not cater for this it will have to be changed.
You might want to think about why this situation has arisen, what problems it will cause and how it can be resolved - in fact that will be the next excercise.
home