Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1876

Problem with E-R model

Show all headers | View raw

This is a question about horse jumping.

I have these relations one Rider can have many horses but one horse can only 
be owned by one rider.So here we have one to many counted from the Rider 
side.

One Rideclub can have many member which is Riders but one Rider can belong 
to only one RideClub. So here we have one to many counted from Rideclub

One Rider can participate in many classes and one class can have many Rider 
so here we have many to many.


For example
Nisse Hult owns the two horses Trisdan and Sylfid.

In my current E-R design I can tell which horse the Rider is using in a 
special class I can only know that Nisse Hult is using any of the horses 
that he owns.

If I for example change the conditions so that I have one to one relationhip 
between Rider and Horse that will solve the problem
because if Hisse Hult is starting in a class he owns only one horse.

The other solution is that I can create a new table with is the contents of 
Horse and Rider and then remove the  Horse and Rider.
But if I do so I get a lot of double information as you can see here.
So if I do this I can see directly which horse Nisse Hult is using becuse 
the Id will be put in the relation table in between
Rider and Class

Id   social sec number        Rider          Horse       ImgHorse 
DescHorse               ImgRider              RiderDesc          Phone
 1  123456-0001               NisseHult   Trisdan    ImgTrisdan    Info 
about Trisdan     img Nisse Hult   Info Nisse Hult   123 45
 2  123456-0001               NisseHult   Kitty        ImgKitty        Info 
about Kitty        Img Nisse Hult   Info Nisse Hult    123 45

I hope you can understand what I'm trying to say.

So what is the best solution if I want to know which Horse the Rider is 
starting with in a Class?

//Tony

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Problem with E-R model "Tony Johansson" <johansson.andersson@telia.com> - 2015-02-06 18:40 +0100
  Re: Problem with E-R model Erland Sommarskog <esquel@sommarskog.se> - 2015-02-06 20:44 +0100

csiph-web