Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to have more than one row on the same table
with the same foreign key?
- 2 Answers
- 6343 Views
- I also Faced
- E-Mail Answers
Answer Posted / pradeeshkumar
Yes, it's possible.
A foreign key in a table can have duplicate values.
For example, One or more employees can belong to same
project.EMPLOYEE_ID is the ptimary key of the Employee
table and PROJECT_ID is a foreign key that references
another table(Project).
EMPLOYEE_ID EMPLOYEE_NAME PROJECT_ID
----------------------------------------
0001 SAM DEX01
0002 MARK DEX01
0003 JUKE MKX02
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are fact, dimension, and measure?
How to test report in reportnet?
Could any one explain me how to create cascading prompts?
How can you set the session management?
What are steps we have to follow in designing the userfriendly universe?
What are the fundamental elements of the data warehouse?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Explain what is cost benefit analysis (cba)?
What is bi?
What are non-additive facts in detail?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What are the steps involved in designing a fact table?
What is the difference between dependent data warehouse and independent data warehouse?
How do you setup Lo-cockpit?
For faster process, what we will do with the universe?
