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