Is it possible to have more than one row on the same table
with the same foreign key?
- 2 Answers
- 5870 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 are the various file formats involved in reportnet?
three ways sql*loader could load data, what are those three types?
Where we use surrogate key explain with example?
Explain what are the various methods of getting incremental records or delta records from the source systems?
Explain the main difference between inmon and kimball philosophies of data warehousing?
What is drill-through?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
How to get the first 100 rows from the flat file into the target?
How to create different types of templates?
How to improve session performance in aggregator transformation?
Suggest a good author for hyperion in data warehousing?
Difference between PowerPlay transformer and power play reports?
Teradata 
