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
- 6466 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 |
Explain difference between view and materialized view?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
what is the difference between etl tool and olap tools
How can we load the time dimension?
How can we schedule the graph in unix?
What is your spectra photometer working principles?
4.Explain Snowflkeschema ?
6 Answers EDS, HCL, IBM, iFlex, TCS,
What are target types on the server?
what is Materialized Views?
if you use oracle sql*loader , how do you transform data with it during loading?
What is a staging area? Do we need it? What is the purpose of a staging area?
What's a Cube in Rolap?
Teradata 
