2. Database Organization

2.1. Types of Database Organization

  • Flat: A simple format with a single record type and fixed fields, which can lead to data repetition and potential errors.
  • Hierarchical: Organizes data in a tree-like structure with parent-child relationships. This can make some queries easy but others difficult, and it may not work well for complex relationships.
  • Relational: Stores data in logically independent tables that can be joined together. This is a common model that uses rows and columns for efficient processing and retrieval.
  • Object-oriented: Models data as objects, which is another approach to representing real-world information.