Q-TYPE OF RELATIONSHIP IN DATA BASE ?
ANS-
Q- WHAT DO U MEAN BY DEGREE OF RELATIONSHIP ?
ANS-
Explain the types of relationships in database.
One-to-one
One to one is implemented using single table by establishing relationship between same type of columns in a table.
One to one is implemented using single table by establishing relationship between same type of columns in a table.
One-to-many
Implemented using two tables with primary key and foreign key relationships.
Implemented using two tables with primary key and foreign key relationships.
Many-to-many
Implemented using a junction table.
The keys from both the tables form composite primary key of the junction table
Implemented using a junction table.
The keys from both the tables form composite primary key of the junction table
OR WE CAL CLASSIFY RELATIONSHIP AS
(A)- UNARY RELATIONSHIP -
RELATISONSHIP WITHIN SAME TABLE
(B) - BINARY RELATION SHIP
RELATION SHIP B/W TWO TABLES
(C) TERNARY RELATIONSHIP
ANS- No of entity participate in the relationship is called degree of the relationship..
No comments:
Post a Comment