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
- 6569 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
What is the data type of the surrogate key?
How do we design a universe?
Explain meta data?
Explain the difference between oltp and olap?
Explain a linked cube?
What is the difference between view materialized view and view?
How can you implement many relations in star schema model?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
How do you define data block size?
Explain difference between e-r modeling and dimentional modeling?
Explain what is a cube in data warehousing concept?
Explain how to export mappings to the production environment?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Explain what are the advantages and disadvantages of reporting directly against the database?
How can we load the time dimension?
