Export date: Thu Apr 26 15:31:34 2018 / +0000 GMT

Data Model in DBMS

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 2 Home 3 Next 4
Identifying and Non Identifying Relationships 5 Hierarchical Model 6

  1. le:Data_modeling_context.svg
  2. fying-relationships/
  5. fying-relationships/

Export date: Thu Apr 26 15:31:34 2018 / +0000 GMT
This page was exported from EDUGRABS [ ]
Export of Post and Page has been powered by [ Universal Post Manager ] plugin from