Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Erm Modelling

Re: Erm Modelling

From: Ian <kellizer(nospam)_at_hotmail.com>
Date: Sun, 2 Mar 2003 01:13:10 -0000
Message-ID: <zMk8a.411$gq3.227@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 Sat Mar 01 2003 - 19:13:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US