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

what are the types of dimension tables

19 Answers   Infotech,


Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1 Answers  


What is the use of tabular model, tabular sql, tabular reference in real time application?

1 Answers  


What is data warehosuing hierarchy?

1 Answers  


what is the difference between MOLAP and ROLAP?

3 Answers  


What is metadata in context of a datawarehouse?

1 Answers  


Explain the data types present in bo n wht happens if we implement view in the designer n report?

1 Answers  


What is metadata in context of a datawarehouse and how it is important?

1 Answers  


How can we schedule the graph in unix?

1 Answers  


what are the similarities between ROLAP and MOLAP

2 Answers   Siemens,


Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

1 Answers  


What are cursors?

4 Answers  


Categories