Fichas
Er models
Fichas del conjunto (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.
Información
- Descripción
- Databas Fichas sobre Er models, creado por Emma Tysk el 17/12/2017.
- Creado por
- Emma Tysk
- Visitas
- 1
- Valoración
Más sobre Entity-Relationship Model and Diagrams