If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > ER diagram help

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-26-11, 06:39
silvercats silvercats is offline
Registered User
 
Join Date: Mar 2011
Posts: 15
ER diagram help

can somebody draw an ER diagram for the table in below link please

http://oi55.tinypic.com/aytvv5.jpg

if you can,create one using PAINT or something.then take a screen capture and upload to
tinypic.com

how to create a many to many relation ER diagram to above?
thanks/
Reply With Quote
  #2 (permalink)  
Old 03-26-11, 07:09
mike_bike_kite mike_bike_kite is offline
vaguely human
 
Join Date: Jun 2007
Location: London
Posts: 2,519
If you supply the email of your teacher then we could save you wasting any effort on this by emailing him directly.
__________________
Mike
Reply With Quote
  #3 (permalink)  
Old 03-26-11, 07:41
silvercats silvercats is offline
Registered User
 
Join Date: Mar 2011
Posts: 15
actually this is a question from a past year exam paper.not homework at all.
Reply With Quote
  #4 (permalink)  
Old 03-26-11, 09:07
mike_bike_kite mike_bike_kite is offline
vaguely human
 
Join Date: Jun 2007
Location: London
Posts: 2,519
Surely then you should just ask your lecturer (or a fellow student) to explain the question to you. It seems odd to expect us to do the question for you when you've done nothing towards solving it yourself. Of course if you genuinely haven't a clue how to go forwards then it might be worth questioning whether you're on the right course.

Oddly the question contains a couple of small errors regards the names of coach c02 and member m123.
__________________
Mike
Reply With Quote
  #5 (permalink)  
Old 03-26-11, 09:53
silvercats silvercats is offline
Registered User
 
Join Date: Mar 2011
Posts: 15
i even don't know the basics of the ERs.they didn't teach me that section yet.and i am just curious about it.enough with that thing and this thing.if someone knows the answer please post
Reply With Quote
  #6 (permalink)  
Old 03-26-11, 10:38
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
Quote:
Originally Posted by silvercats View Post
if someone knows the answer please post
no

either it's homework now, in which case you're busted, or you're studying on your own, and you ~clearly~ don't know enough yet, so go and read some more tutorials, there are literally hundreds of them on the web
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #7 (permalink)  
Old 03-27-11, 11:03
silvercats silvercats is offline
Registered User
 
Join Date: Mar 2011
Posts: 15
kk ..thanks
Reply With Quote
  #8 (permalink)  
Old 03-27-11, 11:45
silvercats silvercats is offline
Registered User
 
Join Date: Mar 2011
Posts: 15
hey guys is this correct then?
above one is the table i tm relaying on.it has to be a many to many one

http://oi56.tinypic.com/333k2nn.jpg

i know it is ugly.sry ,my 1st one :grin: ,is this theoretically correct?
Reply With Quote
  #9 (permalink)  
Old 03-27-11, 11:47
silvercats silvercats is offline
Registered User
 
Join Date: Mar 2011
Posts: 15
do i also have to put name in somewhere?
Reply With Quote
  #10 (permalink)  
Old 03-29-11, 09:39
silvercats silvercats is offline
Registered User
 
Join Date: Mar 2011
Posts: 15
ER diagram help!

create a many to many ER diagram using this table


http://oi55.tinypic.com/aytvv5.jpg

this is what i created.is this correct?what are missing?

http://oi56.tinypic.com/333k2nn.jpg

yeah yeah it is not pretty,my 1st one


thanks.
Reply With Quote
  #11 (permalink)  
Old 03-29-11, 11:02
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
why did you create a new thread? trying to snare some other unsuspecting person?

i've asked that your threads be merged
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #12 (permalink)  
Old 03-29-11, 11:16
healdem healdem is offline
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,246
posts #8 & #9 are from another thread started by Silvercats
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #13 (permalink)  
Old 03-29-11, 11:22
silvercats silvercats is offline
Registered User
 
Join Date: Mar 2011
Posts: 15
I created a new one because no one seems to be replying .
snare?duh are you insane?
Reply With Quote
  #14 (permalink)  
Old 03-29-11, 11:26
silvercats silvercats is offline
Registered User
 
Join Date: Mar 2011
Posts: 15
Quote:
Originally Posted by healdem View Post
posts #8 & #9 are from another thread started by Silvercats
i think it is #10 actually

and why did z admin/mod deleted my new thread?.i thought people will see a new thread more than therefor i will get answers which i didn't get in this after it is being old.
consider putting that new one back
Reply With Quote
  #15 (permalink)  
Old 03-29-11, 14:56
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
Quote:
Originally Posted by silvercats View Post
snare?duh are you insane?
actually, no, i'm not

but you, sir, are rude, and you won't be getting any help at all from me
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On