Geog 495: GIS Database Design

9/30/05

---

Benefit of DB system

• Data redundancy can be reduced
• Data consistency
• Standard can be enforced
• Security

---

Building block of db

• Entity
• Attributes
• Relation
• 1:1
• 1:M
• M:N

---

DB design seems to be extremely discretionary

You decide what is to be included, and so on.

Any guidance for this?

1. business rule
2. database model
3. design tools

---

Database model

• Hierarchical
• Network
• Relational
• Object-oriented
• Deductive

How does it evolve?

---

Architecture of DB system

• External
• Conceptual
• Internal
• Physical