Data Models & Their Types

Data Models & Their Types in DBMS:

• Hierarchical Model: Organizes data in a tree-like structure with parent-child relationships. Each child record has only one parent. It's simple but inflexible.
• Network Model: An extension of the hierarchical model, allowing a child record to have multiple parent records. This creates a more flexible graph-like structure but is complex to manage.
• Relational Model: The most widely used model. It organizes data into tables (relations) consisting of rows and columns. Relationships between tables are maintained using keys. It is flexible and straightforward.
• Object-Oriented Model: Data is represented as objects, similar to object-oriented programming. Each object encapsulates data and behavior (methods). It's good for complex data types but less common for general business applications.
• Entity-Relationship (ER) Model: A high-level conceptual model used to design databases by representing real-world entities and their relationships.