Flashcards
Er models
Cards in this deck (3)
- 1What are the categories of attribute types?- key attr. type
- simple (atomic) vs composite
- singe-valued vs multivalued
- derived - 2What is the key attr type used for?- Can be used to uniquely identify each entity
examples: product nr, SSN..
- Can also be a combination of attr. types. E.g flight Nr + departure date - 3What is the possible relationship between a weak entity and its owner?The relationship to the owner entity is called identifying relationship and it might only be 1:1 or 1:N. (A owner can have N "children", but a child cant have several parents)
In the latter case, the weak entity type needs partial key – an attribute which together with the owner’s key can identify the weak entity.
Information
- Description
- Databas Flashcards on Er models, created by Emma Tysk on 17/12/2017.
- Created by
- Emma Tysk
- Views
- 1
- Rating
More on Entity-Relationship Model and Diagrams