DB Relationships

DB Relationships

1. Weak Entity

   • Depends on some other entity type
   • e.g. next of kin dependent on entity staff

2. Multi valued attribute

   • Holds multiple values for a single entity

3. Recursive

   • Entity type that is in a relationship with itself

4. Ternary

   • Where three entity types are related

5. Strong Entity

   • Entity that is not dependent on another entity

6. Single valued attribute

   • Holds a single value for a single entity

7. Derived Attribute

   • Derivable from the value of a related attribute