Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Could someone explain many to many and one to many relationships

Thread Tools
 
Search this Thread
 
Old 28 August 2002, 10:14 PM
  #1  
super_si
Scooby Regular
Thread Starter
 
super_si's Avatar
 
Join Date: Feb 2002
Location: Lurkin Somewhere
Posts: 7,951
Likes: 0
Received 0 Likes on 0 Posts
Post

just revising and this has cropped up my notes arent clear!

also The three levels of the ANSI/SPARC architecture would be useful


Si
Old 28 August 2002, 10:33 PM
  #2  
MartinM
Scooby Regular
 
MartinM's Avatar
 
Join Date: Jun 1999
Posts: 1,496
Likes: 0
Received 0 Likes on 0 Posts
Post



You have started many threads on Scoobynet. Each of the threads you have started is only started by you. The relationship between you and the threads you have started is one-to-many.

Many people have contributed to many of the threads you have started. Any particular thread has many contributors. The relationship between people and the threads they have contributed to is many-to-many.

You can model a one-to-many data relationship in a physical database by putting a foreign key in the 'many' table that points back to the primary key in the 'one' table'.

You can't do this in a many-to-many data relationship. You need a 'linking' table that contains two foreign keys - one to the primary key of one of the tables and one to the primary key of the other table.

Easy eh?

PS Damn - I've broken my rule of never replying to any of your threads since you dissed me so much last time. But you did ask the other day to point out any simple questions you've ever asked on Scoobynet....


Old 28 August 2002, 10:39 PM
  #3  
DazV
Scooby Regular
 
DazV's Avatar
 
Join Date: Jun 2000
Posts: 3,783
Likes: 0
Received 0 Likes on 0 Posts
Post

Old 28 August 2002, 10:41 PM
  #4  
super_si
Scooby Regular
Thread Starter
 
super_si's Avatar
 
Join Date: Feb 2002
Location: Lurkin Somewhere
Posts: 7,951
Likes: 0
Received 0 Likes on 0 Posts
Post

i do appologies for last time, sorry!

Sometimes i get really pissed off with damm computers!!

Were you reffering to when i did the little Vb ADO program?

Thanks for the help very useful now to revise backus naurs form ,parse tables and finite Automata's

Si
Old 28 August 2002, 10:45 PM
  #5  
suba
Scooby Regular
 
suba's Avatar
 
Join Date: Mar 2000
Posts: 2,462
Likes: 0
Received 0 Likes on 0 Posts
Post

LOL .
Old 28 August 2002, 11:01 PM
  #6  
MartinM
Scooby Regular
 
MartinM's Avatar
 
Join Date: Jun 1999
Posts: 1,496
Likes: 0
Received 0 Likes on 0 Posts
Post

Ref your 2nd question.

http://www.cs.stir.ac.uk/~ahu/31q5/lecture2.pdf

..very (well, a little bit actually) interesting. Can't say I've ever come across it in any real world applications though..
Old 28 August 2002, 11:09 PM
  #7  
super_si
Scooby Regular
Thread Starter
 
super_si's Avatar
 
Join Date: Feb 2002
Location: Lurkin Somewhere
Posts: 7,951
Likes: 0
Received 0 Likes on 0 Posts
Post

cheers mate


Wished id gone there lot easier

http://www.cs.ncl.ac.uk

Tutor said were rated in the top 5, which is a bugger because its hard
Old 28 August 2002, 11:52 PM
  #8  
druddle
Scooby Regular
 
druddle's Avatar
 
Join Date: Mar 2001
Location: Berkshire
Posts: 5,528
Likes: 0
Received 0 Likes on 0 Posts
Post

Si

Look at this for SPARC info - http://www.sparc.com/

If you want any more info on these buggers which are the same as these buggers but the FSC ones are sold in Europe then let me know

Dave
Old 28 August 2002, 11:54 PM
  #9  
super_si
Scooby Regular
Thread Starter
 
super_si's Avatar
 
Join Date: Feb 2002
Location: Lurkin Somewhere
Posts: 7,951
Likes: 0
Received 0 Likes on 0 Posts
Post

cheers mate! Off to bed just just an exam on Software Architecure next year ive a whole module on database

Got nick for hardware/networking/quake3, gary for java, Hos for a laugh, Whats your msn id, your my database monkey

Forgot my mate Mark(Gravel Express, cruise person )

Si

[Edited by super_si - 8/28/2002 11:54:48 PM]
Old 29 August 2002, 12:00 AM
  #10  
druddle
Scooby Regular
 
druddle's Avatar
 
Join Date: Mar 2001
Location: Berkshire
Posts: 5,528
Likes: 0
Received 0 Likes on 0 Posts
Post

si - my MSN handle is the same as my email addy !

dave
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Tidgy
Computer & Technology Related
33
18 October 2015 09:59 AM
jonc
Non Scooby Related
18
23 September 2015 10:57 PM
ReallyReallyGoodMeat
Non Scooby Related
12
21 September 2015 11:34 AM
alcazar
Non Scooby Related
5
18 September 2015 11:49 PM
bparkes007
General Technical
5
11 September 2015 07:13 PM



Quick Reply: Could someone explain many to many and one to many relationships



All times are GMT +1. The time now is 09:53 AM.