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



Is it possible to have more than one row on the same table with the same foreign key?..

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

Is it possible to have more than one row on the same table with the same foreign key?..

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

Post New Answer

More Data Warehouse General Interview Questions

How to export mappings to the production environment?

0 Answers  


Explain what are conformed dimensions?

0 Answers  


If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?

3 Answers   Extech, Principal Finance,


How to join 3 database like flat file, oracle, db2 in informatrica?

0 Answers  


What is confirmed dimension?

7 Answers   JPMorgan Chase,


Explain meta data?

0 Answers  


What is Grain & Granularity in Data Warehouse.

2 Answers   TCS, TVS,


Explain what is difference between query studio and report studio?

0 Answers  


Where the applications and where

0 Answers  


what is the diffrence between psa and idoc

0 Answers   iGate,


What are the main steps to build the data warehouse?

0 Answers  


What is the difference between snowflake and star schema?

0 Answers  


Categories