04 ER Diagram Flashcards
1
Q
what is entity
A
- unique object
- has a set of attributes
- each attribute represented by a datatype
2
Q
what is entity set
A
a collection of entities
3
Q
what is a relationship
A
- association among 2 or more entities
2. can be identified by entity keys
4
Q
what is a relationship set
A
a collection of similar relations
5
Q
relationship types
A
1 - 1
1 - many
many - 1
many - many
6
Q
types of constraits
A
- participant constraint
- at least 1 - key constraint
- at most 1