Database design Flashcards
1
Q
Describe the three phases of database design
A
Analysis, logical design, and physical design
2
Q
Describe the steps of Analysis
A
- Discover entities, relationships, and attributes
- Determine cardinality
- Distinguish strong and weak entities
- Create supertype and subtype entities
3
Q
Describe the steps of logical design
A
- Implement entities
- Implement relationships
- Implement attributes
- Apply normal form
4
Q
How are attribute maximum and minimum notated?
A
They follow the attribute name. Minimum appears in paranthesis
5
Q
What is the relationship between subtype and supertype entities called?
A
IsA relationships. manager-IsAn-employee
6
Q
How are subtype entities within partitions aligned?
A
Vertically
7
Q
How are subtype entities in different partitions aligned?
A
Horizontally
8
Q
What do partitions of supertype entities correspond to?
A
Partition attributes of the supertype entity.
9
Q
A
