Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to have more than one row on the same table
with the same foreign key?
- 2 Answers
- 6570 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 |
Can we take backup when the database is opened?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Explain what is the difference between olap and datawarehosue?
What is latest version of power center / power mart?
Explain what is analytical or analytic mean?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What are the key features of chameleon that separates it from other algorithms?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What are fundamental stages of data warehousing?
What is the difference between view filter and report filter?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Teradata 
