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
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Explain some of modeling tools available in the market?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What is the metadata extension?
How we are using this function?
What are fundamental stages of data warehousing?
How are the dimension tables designed?
What are the advantages of cold fusion?
What are the advantages of query studio compared to report studio?
How do we design a universe?
What are the key columns in Fact and dimension tables?
What are the various tools? Explain name a few?
What are the other names given to data warehousing?
Explain the hierarchies level data warehousing.
What is a Decision Tree Algorithm?