3. Database Design

Question 1

Stages of a DB design?

Answer 1

1. Requirement analysis
2. Conceptual DB design
3. Choice of DBMS
4. Data model mapping
5. Physical design
6. Implementation

Question 2

What are the 3 primitive notions of an ER model ?

Answer 2

Entities (rectangles), attributes (ovals), and relationships (diamonds).

Question 3

What types of degrees are there of a relationship?

Answer 3

• Binary (degree 2): person owns a car

- Ternary (degree 3): lecturer teaches a course to a student

Question 4

Give the 4 types of structures?

Answer 4

• Simple (oval)
• Complex (structure)
• Multivalued (double oval)
• Derived (dotted oval)