home
tsql exercise 1 - data modelling
Author Nigel Rivett
Create a database schema to model the following:
The system holds data about a number of schools and teachers.
Teachers may teach at any number of schools.
The only data held about teachers and schools is their names.
Note - The next question will be to populate the tables with some data.
you may find the schema you have created to be invalid when you try to populate it.
Don't look at the answers before seeing the next excercise.
It might be a good idea to look at the next excercise before coding anything - but think about what you expect first
home