What is a derived (artificial) primary key
What is a derived (artificial) primary key? When must this be used?
Expert
Using a name like the primary key violates the principle of stability. The social security number may be a valid choice, other than a foreign employee may not have a social security number. It is a case where a derived, quite than a natural, primary key is suitable. A derived key is an artificial key which you create. A natural key is one which is already part of the database.
Write down the differentiation between Informatica8.0 and 7.0?
Elucidate briefly what is batch and also give explanation about the types of batches?
Explain Triggers and Rules?
State the different advantages of the data warehousing?
Write brief note on E.F. Codd, and why is he noteworthy in the development of modern database systems?
What is BCA? Discuss its features?
Explain the about market structures and price output determination.
Provide a brief introduction of the term cubes?
Write a short note on the difference between a dynamic and materialized view?
States the term Mirror Activator Disk mirroring?
18,76,764
1952687 Asked
3,689
Active Tutors
1422528
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!