Is it possible to have more than one row on the same table
with the same foreign key?
- 2 Answers
- 5826 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 edw?
What is the difference between filter and lookup transformation?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
Compare ?Data mining? and ?Data Warehousing??
Explain what are fact, dimension, and measure?
Explain a linked cube?
Difference between ODS and Staging
What are the steps to build the datawarehouse?
What is meant by metadata in context of a data warehouse and how it is important?
Explain what are necessary tasks to install reportnet software?
Could any one explain me how to create cascading prompts?
Explain what are non-additive facts in detail?
Teradata 
