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
- 6373 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Explain can report net connect multiple datasource at a time in report creation time?
How to create different types of templates?
What is data mart in data warehouse?
What is the difference between power center and power mart?
Store (and count) non-fact records?
What is surrogate key? Where we use it?
Describe a data warehouse.
Explain what are the different types of data warehousing?
What are algorithms provided by Microsoft in SQL Server?
What are the types of dimensional modeling?
Where do we use semi and non additive facts?
Explain hybrid slowly changing dimension?
Explain er diagram?
What is the very basic difference between data warehouse and operational databases?
Do you view contain data?
