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


Please Help Members By Posting Answers For Below Questions

What is the differences between star and snowflake schemas?

551


Explain is olap databases are called decision support system true/false?

566


What is the difference between static cache and dynamic cache?

528


What according to you might be the future of data warehousing?

536


Explain datawarehousing?

562






What are the types of dimensional modeling?

628


Explain what is the metadata extension?

590


Explain what is the extension of file to save template?

520


What is the difference between star and snowflake schemas?

610


Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

524


Store (and count) non-fact records?

530


Explain can report net connect multiple datasource at a time in report creation time?

504


Explain what are the various transformation available?

547


What is defined as partial backup?

630


What is the difference between olap and oltp?

566