Is it possible to have more than one row on the same table
with the same foreign key?
- 2 Answers
- 5588 Views
- I also Faced
- E-Mail Answers
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 Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
What is the difference between constraind base load ordering and target load plan?
What is load manager?
What is edw?
What is ?Data Warehousing??
How can you set the client management?
What is Cognos script editor?
How to use the tool Ontobulider
Explain the differences between normalizer and normalizer transformation?
Explain why should you put your data warehouse on a different system than your oltp system?
What are the vaious etl tools in the market?
What are the main steps to build the data warehouse?
Teradata 
