Path: news.easynews.com!easynews!crtntx1-snh1.gtei.net!cpk-news-hub1.bbnplanet.com!news.gtei.net!opentransit.net!newsfeeds.belnet.be!news.belnet.be!news.worldonline.be!not-for-mail
From: "De Stercke Erwin" <Erwin.DES@village.uunet.be>
Newsgroups: comp.databases.theory
Subject: Normalization problem
Date: Sun, 14 Apr 2002 14:19:43 +0200
Organization: Worldonline Belgium
Lines: 33
Message-ID: <a9bs6q$8si$1@news.worldonline.be>
NNTP-Posting-Host: 62.235.203.219
X-Trace: news.worldonline.be 1018786843 9106 62.235.203.219 (14 Apr 2002 12:20:43 GMT)
X-Complaints-To: abuse@worldonline.be
NNTP-Posting-Date: Sun, 14 Apr 2002 12:20:43 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Xref: easynews comp.databases.theory:20443
X-Received-Date: Sun, 14 Apr 2002 05:18:25 MST (news.easynews.com)

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