Answer
See explanation
Work Step by Step
A Database model defines the logical design and structure of a database and defines how data will be stored, accessed and updated in a database management system.
There are various types of database models, some of them are given below:
1. Flat Model : In the flat database model, there is a single two-dimensional array of the data elements in which columns are assumed to have a similar type of values and in the row, the elements should have relational value relational to one another.
2. Hierarchical Model
In the hierarchical model, the data is stored in the tree-like structure in which there is a root node where the data is started to store. The sort field is used for the sibling record to maintain some order while storing data in the hierarchical model. The hierarchical database model is mostly used when there is a need for maintaining an information management system. In this database model there exist a one-to-many relationship among data. The retrieval of data has a different technique in the hierarchical model.
3. Relational Model
The relational database model is designed to remove the dependency in the database management system. The development of the relational database model is targeted for mostly microcomputer systems. The three keys which are used in relational database models are domains, attributes, and relations. The relation is defined as a table that contains rows and columns.
4. Dimensional Model
The dimensional database model is defined as a specialized version of the relational database model. This model is used to represent data in the data warehouses in such a manner so that data can be summarized using OLAP queries and online analytical processing. In the dimensional database model, the database schema consists of a single table of a huge size which contains facts and dimensions.
