Database Models - JSS3 Computer Studies Lesson Note

1. Hierarchical Model: The hierarchical database model organizes data in a tree-like structure with a top-down hierarchy. Each record is linked to a parent record, except for the root record. While efficient for one-to-many relationships, it can be rigid and challenging to modify.

2. Network Model: The network database model represents data as a collection of records connected by various types of relationships. Unlike the hierarchical model, it allows for more flexible relationships, facilitating many-to-many connections. However, it can be complex to design and implement.

3. Relational Model: The relational database model organizes data into tables with rows and columns, creating a two-dimensional structure. It uses a set of mathematical principles and is highly flexible, scalable, and efficient. Popular relational database management systems (RDBMS) include MySQL, PostgreSQL, and Microsoft SQL Server.