Week 3 Flashcards

1
Q

The object in a database which has attributes.

A

Entity

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

These are the things that describe an entity

A

Attribute

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

This type of attribute may have many components to make it up.

A

Composite

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

An attribute that may have more than one value is said to be what?

A

multivalued

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

A value that has a binary degree has how many entities participating in the relationship?

A

2

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

The _____ is the upper and lower limits of a relationship

A

cardinality

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

A weak entity type is one that what?

A

Depends on another entity, and has that other entities Primary Key as part of its PK. This is a total participation constraint (existence dependency)

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