| 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.
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
