Is it possible to have more than one row on the same table
with the same foreign key?
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
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
What are cluster analysis in data warehousing?
Can we have multiple application.cfm file in an application?
Define Data Warehousing?
Explain ddl (data definition language)?
What is a relationship?
what are the different views that are considered when building an object-oriented software system?
What are steps we have to follow in designing the userfriendly universe?
What needs to be done when the database is shutdown?
Explain how are the dimension tables designed?
What are the data types present in bo?
Who needs data warehousing?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
What is VLDB?
what are the major three types of modeling used?