pure agony Flashcards

(5 cards)

1
Q

strong entites
weak entitys
attributes

A

existence ndot dependent. singlar box around text
existence dependent on other entity types.
circles(underlined if primary key)

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

Canidate key
Primary key

A

min # of attributes that uniquely identifies each occurence of an entity type

Canidate key chosen to ID each occurence of an entity.

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

should attribute be entity

A

multi valued attributes may be entity
Attributes with attributes
E-r diagram must be accurate for any instance in time. for example job applicatant—–Employee. (not valid)

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

Want to get rid of many to many relationship by using netity that connects them

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