What are data models in dbms?

Answer 1

A data model is a collection of concepts that can be used to describe the structure of a database.

Data models can be broadly distinguished into 3 main categories-

1)high-level or conceptual data models (based on entities & relationships)

It provides concepts that are close to the way many users perceive data.

2)lowlevel or physical data models

It provides concepts that describe the details of how data is stored in the computer.

These concepts are meant for computer specialist, not for typical end users.

3)representational or implementation data models (record-based,object-oriented)

It provide concepts that can be understood by end users. These hide some details of data storage but can be implemented on a computer system directly.

Answer 2

Data models in DBMS represent the logical structure of the database by defining the relationships, constraints, and properties of the data stored. They provide a way to organize and structure data for efficient storage, retrieval, and manipulation. Common types of data models include relational, hierarchical, network, and object-oriented models.