EDUCATION UGC NET
SCHOOL AND CLASSROOM MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Matching items
|
|
|
M.C.Q items
|
|
|
True / False items
|
|
|
Completion items
|
Detailed explanation-1: -The identifying relationship means the child entity is totally dependant on the existence of the parent entity. Example An account table person table and personAccount. The person account table is identified by the existence of account and person table only.
Detailed explanation-2: -Identifying relationships exist when the primary key of the parent entity is included in the primary key of the child entity. On the other hand, a non-identifying relationship exists when the primary key of the parent entity is included in the child entity but not as part of the child entity’s primary key.
Detailed explanation-3: -The double diamond box in ER diagram represents a relation between a weak entity and its owner strong entity, this relationship is called an identifying relationship.
Detailed explanation-4: -As the name implies, the identifying relationship establishes the parent as a way to identify and classify the child. In this type of relationship, the primary key from the parent migrates through the relationship to become part of the primary key, or identity, of the child.