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_at_news.worldonline.be>
I have a problem with following excercice :
Date: Sun, 14 Apr 2002 14:19:43 +0200
Message-ID: <a9bs6q$8si$1_at_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 - 14:19:43 CEST