Re: Erm Modelling
Date: Sun, 2 Mar 2003 01:13:10 -0000
Message-ID: <zMk8a.411$gq3.227_at_newsfep1-gui.server.ntli.net>
yea, i would like to store this in an RDBMS.
"karl wettin" <wettin_at_users.sourceforge.net> wrote in message
news:20030301193032.59ef613a.wettin_at_users.sourceforge.net...
> On 1 Mar 2003 05:55:56 -0800
> kellizer_at_hotmail.com (Ian) wrote:
>
> > Hi,
> >
> > Little query, as i'am interested in variation of possible
> > implementations. Basically "A Child can apply many times to a school,
> > but may or may not be sucessful. If the child is sucessful, then the
> > child's information is then stored in a student table. Applicants who
> > are refused are also stored in the application table" A relationship
> > must exsist between the student and the application. But my
> > implemenation ends up being a mandatory 1 to 1, which is nearly always
> > worng.
> >
> > Also tried going down the "ApplicationRequests", ie 1 application can
> > have many request, still no joy.
> >
> > Anyone have any guidence? is there a name for this modelling problem?
>
> I would model it this way: (UML class diagram)
>
> [Student]-{*} --[School]-- {*}-[Application]-{*} --[Human]<|----[Student]
>
> I suppose you want to store this in an RDBMS? There are quite a few ways
> of implementing the [Human]<|----[Student] generalization.
>
>
> karl
Received on Sun Mar 02 2003 - 02:13:10 CET