Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

1009


What are cluster analysis in data warehousing?

1110


Can we have multiple application.cfm file in an application?

955


Define Data Warehousing?

1151


Explain ddl (data definition language)?

1007


What is a relationship?

993


what are the different views that are considered when building an object-oriented software system?

1031


What are steps we have to follow in designing the userfriendly universe?

978


What needs to be done when the database is shutdown?

1026


Explain how are the dimension tables designed?

1060


What are the data types present in bo?

1128


Who needs data warehousing?

1065


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?

902


What is VLDB?

1059


what are the major three types of modeling used?

1067