Normalization problem

From: De Stercke Erwin <Erwin.DES_at_village.uunet.be>
Date: Sun, 14 Apr 2002 14:19:43 +0200
Message-ID: <a9bs6q$8si$1@news.worldonline.be>

I have a problem with following excercice :

For a school I would like to design a normalized database model for the surveillance during different times a day on different places by different teachers.

There are different places Tables => Places (Placen°, placename) Placen° is the primary key

=> Teachers (Teachn°, teachersname)

                 Teachn° is the primary key



                => Surveillancemoments(Survn°, Date, Begintime, endtime)

                    Survn° is the primary key

Note : it must be possible to have different surveillancemoments for each place.

=> SurveillanceTeachersLink(Teachn°, Survn°)

Note : for each surveillancemoment, different numbers of different teachers must be possible too.

I'm trying to make a prototype-construction in MS Access, but, I don't get out of it.

It seems my model is not correct. What do I forget/mistake?

Thanks for any help,
EDS Received on Sun Apr 14 2002 - 07:19:43 CDT