Bydefaultrelationshipsareestablishedbyhavingthe

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Entities: If an entity can exist apart from all its related entities, then it is existence‐independent and it is referred to as strong entity or regular entity. Relationship Strengths: (Strong Relationships) The concept of relationship strength is related on how primary keys (PK) are defined among entities. To implement a relationship, the primary key of one entity ( the parent entity , normally on the “one” side of the one‐to‐many relationship) appears as a foreign key (FK)in the related entity (the “many” side on the one‐to‐many relationship). Sometimes, the foreign key is also a primary key in the related entity. Weak or Non_identifying Relationships: A weak relationship exists if the primary key of the related entity does not contain a primary key component of the parent entity. By default, relationships are established by having the primary key of the parent entity appear as a foreign key on the related entity(child entity) Example, suppose we have a 1:M relationship between COURSE and CLASS as: COURSE(CRS_CODE,DEPT_CODE,CRS_DESCRIPTION,CRS_CREDIT) CLASS(CLASS_CODE, CRS_CODE,...
View Full Document

Ask a homework question - tutors are online