04 ER Diagram Flashcards

1
Q

what is entity

A
  1. unique object
  2. has a set of attributes
  3. each attribute represented by a datatype
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

what is entity set

A

a collection of entities

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

what is a relationship

A
  1. association among 2 or more entities

2. can be identified by entity keys

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

what is a relationship set

A

a collection of similar relations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

relationship types

A

1 - 1
1 - many
many - 1
many - many

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

types of constraits

A
  1. participant constraint
    - at least 1
  2. key constraint
    - at most 1
How well did you know this?
1
Not at all
2
3
4
5
Perfectly