Types of binary relationships in DBMS
Describe briefly three types of binary relationships in DBMS?
Expert
The three types of binary relationships which are used in DBMS are as follows:
a) 1: 1 - a single entity instance of one kind is linked to a single-entity instance of any other type.b) 1 : N - a single entity instance of one kind is linked to many-entity instances of another type.c) M : N - many-entity instances of one kind is linked to many-entity instances of another type.
Write down a short note on the difference between two and three-tier architectures?
Elucidate what are the tasks which Load manger process will do?
Name the methods and types of Collision Resolution Techniques used in each of the type?
State difference between Passive and Active transformation?
What are some of the demerits related with conventional file processing systems?
Elucidate how many kinds of dimensions are accessible in the Informatica?
In which circumstance should you recompile the package body after recompiling the package requirement?
Give a brief introduction of the term universe in SQL? Brief explain the kinds of universes in business objects?
Write down a short note on the difference between partial specialization and total specialization.
Explain the Expression transformation?
18,76,764
1936319 Asked
3,689
Active Tutors
1449459
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!