Data Model

• A data model is a collection of concepts for describing data
• A schema is an instance of a data model for specific application
• Common data models
  • A relational data model
  • Free text (ex: webpages)
  • Semi-structured (ex: XML, JSON)
• Types
  • ER Model
  • Relational Data Model
• Design Steps
  1. Requirements analysis
  2. Conceptual database design (ER model)
  3. Logical database design (relational model)
  4. Schema refinement (FDs & normalization)
  5. Physical database design (indexes)
  6. Application and security design