 |
In many to many ralationship is it neccesary that have to use both as foreignkey? |
Answer
In my experience yes it is necessary. That having been said, depending on the DBS in use, you can set up correspondence tables to allow abbreviated, according to hierarchy rules to represent the members. This cuts down on typing for manual queries and program space for automated ones. Any DBA manual (or person) should be able to lay out the sub-schema(s) for many-to-many abbreviations for you.
|
|
|
First answer by Hmn324. Last edit by Hmn324. Contributor trust: 17 [recommend contributor]. Question popularity: 31 [recommend question]
|
Research your answer: |
Can you answer other questions about databases and data management systems?
|
|
Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Databases > In many to many ralationship is it neccesary that have to use both as foreignkey?
Our contributors said this page should be displayed for the questions below. (Where do these come from ) |
| If any of these are not a genuine rephrasing of the question, please help out and edit these alternates. |
