Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1873
| X-Received | by 10.236.228.106 with SMTP id e100mr17911683yhq.46.1422897150527; Mon, 02 Feb 2015 09:12:30 -0800 (PST) |
|---|---|
| X-Received | by 10.140.104.174 with SMTP id a43mr150368qgf.2.1422897150503; Mon, 02 Feb 2015 09:12:30 -0800 (PST) |
| Path | csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!peer03.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!v8no5863333qal.1!news-out.google.com!q4ni25qan.0!nntp.google.com!v8no5863331qal.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail |
| Newsgroups | comp.databases.ms-sqlserver |
| Date | Mon, 2 Feb 2015 09:12:30 -0800 (PST) |
| In-Reply-To | <mal6f2$ajg$1@dont-email.me> |
| Complaints-To | groups-abuse@google.com |
| Injection-Info | glegroupsg2000goo.googlegroups.com; posting-host=173.61.135.70; posting-account=SOVadwoAAAB3h7W1MLW9kMYtEc2JW2L8 |
| NNTP-Posting-Host | 173.61.135.70 |
| References | <mal6f2$ajg$1@dont-email.me> |
| User-Agent | G2/1.0 |
| MIME-Version | 1.0 |
| Message-ID | <5019f0d4-6b8e-46df-9bd5-743298d4f9cb@googlegroups.com> (permalink) |
| Subject | Re: About E-R model for horsejumping |
| From | Ross Presser <rpresser@gmail.com> |
| Injection-Date | Mon, 02 Feb 2015 17:12:30 +0000 |
| Content-Type | text/plain; charset=ISO-8859-1 |
| X-Received-Bytes | 1972 |
| X-Received-Body-CRC | 1815233481 |
| Xref | csiph.com comp.databases.ms-sqlserver:1873 |
Show key headers only | View raw
On Sunday, February 1, 2015 at 7:34:14 AM UTC-5, Tony Johansson wrote: > Assume I have many to many relation between a Rider and Competition so I > will have a relation table in between that I call Participate. > In the entity Rider I have Social security number, Name, E-mail, Address, > PhoneNumber, Picture, Description > In entity Competition I have Name, Date, Id > In entity Place I have Address, Phone number, E-mail, Name. > I have one to many between Place and Competition. > > Now to my question is it sensible to place attribute like StartTime, Track, > Result, NumberOfFault in the relation table Participate > that is the relation table in between Rider and Competition. > > //Tony If Competition is referring to a single race (an outing of several horses on a particular track at a particular time), then yes. If it's referring to a day's set of races, then no.
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar
About E-R model for horsejumping "Tony Johansson" <johansson.andersson@telia.com> - 2015-02-01 13:33 +0100 Re: About E-R model for horsejumping Ross Presser <rpresser@gmail.com> - 2015-02-02 09:12 -0800
csiph-web