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.
Explain difference types of the stages?
Define the Fully Functional dependency.
Describe briefly Aggregate transformation?
Explain the reusable transformation?
Write about the independent and dependent data marts.
Distinguish between the query answering and direct query answering.
You have two tables, STUDENT and COMPUTER which are in a one-to-one relationship. The foreign key is StudNumber in COMPUTER that references StudNumber as the primary key of STUDENT. Describe what must be done to convert the one--to-one STUDENT -COMPUT
Illustrates the term explain and how does this work?
Under what conditions should indexes are employed?
What are the main tasks of a Server?
18,76,764
1944854 Asked
3,689
Active Tutors
1414037
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!