TYPES OF DATABASE MODELS

1. Flat model:

A flat file database is a type of database that stores data in a single table. Flat file databases are generally in plain-text form, where each line holds only one record. The fields in the record are separated using delimiters such as tabs and commas.

2. Hierarchical model:

In Hierarchical model, data is organized into a tree-like structure, implying a single upward link in each record to describe the nesting and a sort field to keep the records in a particular order in each same level list.

3. Network model:

Network Model organizes data using two fundamental constructs called records and sets. Records contains fields and sets define one-to-many relationships between records.

4. Relational model:

Relational Model is a database model based on first-order predicate logic. Its core idea is to describe a database as a collection of predicates over a finite set of predicate variables, describing constraints on the possible values and combinations of values.

5. Object-relational model:

Similar to a relational database model, but objects, classes and inheritance are directly supported in database schemas and in the query language.

6. Star schema:

Star schema is the simplest style of data warehouse schema. The star schema consists of a few “fact tables” (possibly only one, justifying the name) referencing any number of “dimension tables”. The star schema is considered an important special case of the snowflake schema.