which pattern? [message #340] |
Fri, 27 October 2006 06:45 |
galdiolom
Messages: 3 Registered: October 2006 Location: Padova ITALIA
|
Junior Member |
|
|
Hi,
I still have a stupid question, but hope that someone can help me...
How can I implement the RADICORE architecture in a situation like this:
I have to insert (add) one(more) musical instrument(s) to one (more) musician(s) related to a specific track (that, in turn, is corrrelate to a specific musical record)
Which pattern I must use?
The structure is:
- table INSTRUMENTS is related to table LINK_MUSICIAN_TO_TRACK in a MANY-TO-MANY relationship where LINK_INSTRUMENT_TO_MUSICIANxTRACK is the link table;
- table MUSICIANS is related to table TRACKS in a MANY-TO-MANY relationship where LINK_MUSICIAN_TO_TRACK is the link table;
- table TRACKS is related to table RECORDS in a ONE-TO-MANY relationship.
|
|
|
Re: which pattern? [message #341 is a reply to message #340] |
Fri, 27 October 2006 09:13 |
AJM
Messages: 2363 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
When dealing with many-to-many relationships there are several alternatives. If you look in the menu systems maintenance tasks you will see 3 alternatives for dealing for dealing with menu items:
(1) pattern MULTI2
(2) pattern LINK1
(3) pattern LIST2
You need to look at how these operate then pick the one that suits your purposes best.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|