ER Diagram Flashcards

1
Q

What shapes represent entities in an ER Diagram?

A

Rectangles

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

What shapes represent attributes (field names) in an ER Diagram?

A

Ovals/Circles

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

What shapes represent relationships in an ER Diagram?

A

Diamond

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

What represents real-world objects or concepts in an ER diagram?

A

Entity

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

What are the properties or characteristics of entities called?

A

Attributes

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

What depicts how entities interact or relate to each other within a database?

A

Relationships.

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

What describes the numerical relationship between entities in a relationship?

A

Cardinality

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

What are attributes that uniquely identify each instance of an entity?

A

Identifying keys

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

What is the process of organizing a relational database to minimize redundancy and dependency?

A

Normalization

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