DataBase CH2 Flashcards

1
Q

Represt what the database keeps track of

A

Entities

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

depict how many instances of one entity can be associated with another

A

Cardinality Constraints

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

The relationship between a weak entity and its owner is an ..

A

Identifying Relationship

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

What is a partial key?

A

Attribute of a weak entity that combined with the unique attribute of the owner entity

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

A 1 to Many Relationship must have…?

A

A partial key

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

Uses Singular nouns ..

A

Entity and Attributes

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

What’s a candidate key

A

Multiple Unique Attribute

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