Is it possible to have more than one row on the same table
with the same foreign key?
Answers were Sorted based on User's Feedback
Answer / naveen
Yes, it is possible.
Eg., EMP table consists of many employee records where each
employee is designated to one department#.Here the
department# is the foreign key in the emp table.
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / 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 |
What is the difference between narmal load and bulk load?
What is the difference between junk dimension and degenerated dimension?
What are aggregate fact tables ? why they are needed? give an example
Explain what is the limit to the number of sources and targets you can have in a mapping?
What is edw?
What are the advantages of query studio compared to report studio?
Explain what are the different methods of loading dimension tables?
Why is business intelligence (bi) important in data warehousing?
2.What is staging area ?
4 Answers HCL, IBM, iFlex, TCS,
difference between bo 6.5 and bo xi r2
How many ways we test the universe & Report?
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?