Data Model in DBMS

A model is an abstraction process that represent essential features without including the background details or explanations. It hides superfluous details while highlighting details pertinent to the application at hand.
A data model is a mechanism that provides this abstraction for database applications. Data modelling is used for representing entities of  interest and their relationships in the data base.
A data model defines the logical structure of a data base means that how data is connected to each other and how they are processed and stored inside a system.

A number of models for representing data have been developed. As with programming languages, there is no best choice for all applications but the models maintains the integrity of the by enforcing a set of constraints.
Data models differ in their method of representing the associations amongst entities and attributes. The main models or approach are:

Click on these models to know more .

Data Model Structure and Constraints –

  • To define the database structure, Constructs are used
  • Constructs typically include elements (and their data types) as well as group of elements (Example- Entity, Record, Table), and relationships among such groups.
  • Constraints specify some restriction on valid data; These constraints must be enforced at all times.

Data Model Operations –

These operations are used for specifying database retrievals and updates by referring to constructs of the data model. The Operations may include basic model operations as well as user defined operations.

Basic Model Operations :

  • Insert
  • Delete
  • Update

User Defined Operations Example :

  • compute_student_CGPA
  • compute_student_marks
  • compute_student_SGPA
  • update_inventory etc.

The hierarchical model is the oldest DBMS model and the object oriented DBMS being the newest data model.


Previous Home Next
Identifying and Non Identifying Relationships Hierarchical Model

     

Incoming search terms:

  • what is entity relational data model in dbms in edugrab com
  • plex structure in dbms
  • data models in dbms
  • Plex stru
  • semantic data model in edugrabs com

Leave a Reply