CSE :: Database System 2 - CS
- A synonym is two or more attributes that have different names but the same meaning.
- In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side.
- Normalization is a formal process for deciding which attributes should be grouped together in a relation.
- A foreign key may be null and still adhere to the referential integrity constraint.
- If a relation is in third normal form, it does not need to be in second normal form.
- The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.
Whatsapp
Facebook
