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
- 6467 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 fact less fact table? Where you have used it in your project?
What is the difference between olap and datawarehosue?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Explain what is full load & incremental or refresh load?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
What is cfapplication tag?
What are the difference between snow flake and star schema?
How to design file watch jobs?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
Explain what are the various methods of getting incremental records or delta records from the source systems?
Explain how are the dimension tables designed?
Suppose we want to display zero when null values coming to report how can we do that?
