Friday, 31 July 2015

WHAT DO U MEAN BY RELATION SHIP TYPE?

Q-TYPE OF RELATIONSHIP IN DATA BASE ?
 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-many
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 

 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 

Q- WHAT DO U MEAN BY DEGREE OF RELATIONSHIP ?
ANS- No of entity participate in the relationship  is called degree of the relationship..

No comments:

Post a Comment