The relationship (with in relation) that describes how the value of one atrribute may be used to find the value of another attribute.
An attribute that can be used to find the value of another attribue in the relation.
- The value of a candidate key can be used to find the value of every other non-key attribute in the talbe.
- A simple candidate key consists of only one attribue.
- A composite candidate key consists of more than one attribue.
- The key from one relation is placed in the other as a foreign key.
- If both sides of the relationship are optional, it does not matter which table receives the foreign key.
- If only one side of the relationship is optional, the optional side receives the foreignkey.
In a one to more relationship, the foreign key always goes into the many side of the relationship
- The 1 side is called the parent
- The N side is called the child