Is it possible to have more than one row on the same table
with the same foreign key?
Answer Posted / 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 |
Post New Answer View All Answers
What is the purpose of Dataware Control?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
What is the difference between olap and datawarehosue?
What is surrogate key? Explain with examples.
What is the difference between agglomerative and divisive hierarchical clustering?
What is data validation strategies for data mart v?
Suggest a good author for hyperion in data warehousing?
Compare and contrast aggregates & indexes
What are situations where snowflake schema is better than star schema when the opposite is true?
what are the major three types of modeling used?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Explain about core dimension, balanced dimension, and dirty dimension?
What is degenerate dimension table?
what are relationships?
How to limit the max no of rows retrieved in the report?