EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials DBMS Tutorial Data Models in DBMS
Secondary Sidebar
DBMS Tutorial
  • DBMS
    • What is DBMS?
    • Introduction To DBMS
    • DBMS ER Diagram
    • DBMS_RANDOM
    • DBMS_XPLAN
    • DBMS join
    • DBMS Functions
    • Data Administrator in DBMS
    • Checkpoint in DBMS
    • DBMS Table
    • Mapping Constraints in DBMS
    • DBMS Canonical Cover
    • DBMS Log-Based Recovery
    • DBMS Multivalued Dependency
    • View Serializability in DBMS
    • DBMS Concepts
    • DBMS Constraints
    • DBMS_Scheduler
    • B+ Tree in DBMS
    • DBMS_LOB
    • dbms entity
    • DBMS Foreign Key
    • DBMS Users
    • DBMS_Metadata.get_ddl
    • Relational Algebra in DBMS
    • DBMS Components
    • DBMS Features
    • DBMS Models
    • DBMS Relational Model
    • Hashing in DBMS
    • DBMS network model
    • Relationship in DBMS
    • ER Model in DBMS
    • Data Models in DBMS
    • Static Hashing in DBMS
    • Advantages of DBMS
    • dbms_output.put_line
    • DBMS Data Dictionary
    • dbms_xplan.display_cursor
    • Normal Forms in DBMS
    • DBMS helps achieve
    • DBMS 3 tier Architecture
    • Relational Calculus in DBMS
    • Serializability in DBMS
    • File Organization in DBMS
    • DBMS Transaction Processing
    • States of Transaction in DBMS
    • Functional Dependency in DBMS
    • Generalization in DBMS
    • Data Independence in DBMS
    • Lock Based Protocols in DBMS
    • Deadlock in DBMS
    • Integrity Constraints in DBMS
    • Concurrency Control in DBMS
    • Validation Based Protocol in DBMS
    • DBMS Locks
    • Normalization in DBMS
    • Transaction Property in DBMS
    • Specialization in DBMS
    • Aggregation in DBMS
    • Types of DBMS

Data Models in DBMS

By Priya PedamkarPriya Pedamkar

Data models in DBMS

Introduction to Data Models in DBMS

The Database models in the Database Management System explains the logic behind the structure of a Database system that should usually include all the tables, which are represented as entities in ER model, the relationships between the tables and objects, and the requirement provided by the project team in order to settle on how data can be stored & accessed, granted the aimed Database System needs to be designed with respect to the rules and notions of the given data model the Database Architect prefers to be implemented.

Different types of Data Models in DBMS

The different types that are used are as given below:

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (86,060 ratings)
  • Flat Data Model
  • Entity-Relationship Model
  • Relation Model
  • Record base Model
  • Network Model
  • Hierarchical Model
  • Object-oriented Data Model
  • Object Relation Model
  • Semi-structured Model
  • Associative Model
  • Context Data Model

Below are the detailed description of the above database models

1. Flat Data Model

The flat data model is the first introduced traditional data model where data is kept in the same plane. This is a very old model which is not much scientific.

2. Entity-Relationship Data Model

The Entity-relationship data model structure based on the impression of the real-world entities and the existing relationship between them. In the process of designing the real-world scenario into the database model the Entity sets are created in the beginning and then the model is dependent on the two below vital things which are entities consisting of the attributes and the relationship that exists among the entities.

An entity contains a real-world property called an attribute. Attributes are defined by a set of values known as domains. For example, in an office the employee is an entity, the office is the database, employee ID, name are the attributes. The logical association between the different entities are known as the relationship among them.

3. Relational Data Model

The most popular and extensively used data model is the relational data model. The data model allows the data to be stored in tables called a relation. The relations are normalized and the normalized relation values are known as atomic values. Each of the rows in a relation is called tuples which contains the unique value. The attributes are the values in each of the columns which are of the same domain.

4. Network Data Model

In the network data model, all the entities are organized in graphical representations. There may be several parts in the graph in which the entities can be accessed.

5. Hierarchical Data Model

The hierarchical model is based on the parent-child hierarchical relationship. In this model, there is one parent entity with several children entity. At the top, there should be only one entity which is called root. For example, an organization is the parent entity called root and it has several children entities like clerk, officer, and many more.

6. Object-oriented Data Model

An object-oriented data model is one of the most developed data models which contains video, graphical files, and audio. This consists of the data piece and the methods in the form of database management system instructions.

7. Record base Data Model

The record-based data model is used to determine the overall design of the database. This data model contains different kinds of record types. Each of the record types has a fixed length and a fixed number of fields.

8. Object-relational Data Model

The object-relational data model is a powerful data model but for the design of the object-relational data, the model is very complex. This model gives efficient results and widespread with huge application thus some parts of the complexity problem can be ignored because of this. It also offers features like working with other data models. Using the object-relational data model we can work with the relational model also.

9. Semi-structured Data Model

The semi-structured data model is a self-describing data model. The data stored in this model is generally associated with a scheme that is contained within the data property known as self-describing property.

10. Associative Data Model

Associative data model follows the principle of division which data in two ways between entities and association. Hence, the model is dividing the data for all the real-world scenarios into entities and associations.

11. Context Data Model

Context data models are very flexible as it contains a collection of several data models. It is a collection of data models like the relational model, network model, semi-structured model, object-oriented model. Thus, because of the versatile design of this database model different types of tasks can be accomplished. As a result, support for different types of users is added which may differ by the interaction of the users in the database.

The context data model brought a revolutionary change in the industries by properly handling relevant data. The main function of the data models in a database management system is helping the users to use and create databases. There are several types of data models depending on the kind of structure the users need and based on that we can select the data models in the database management system.

Conclusion

Data modeling is the method of developing the data model for the data to be stored in the database. This ensures consistent naming convention and different other security features to maintain the quality of the data. Because of data modeling, proper structure is defined for tables and different primary and foreign keys as well as stored procedures in the database. There are three main models of data modeling like conceptual, logical, and physical. A conceptual model is used to establish the entities, attributes, and relationships. A logical data model is to define the structure of the data elements and set the relationship between them. Finally, the physical model is used to specify the database-centric implementation of the model. The main motive of designing the data model is to ensure that the objects given by the functional team are represented properly and accurately. The main disadvantage of database modeling is that a minimum modification in the structure may result in the change in the entire application.

Recommended Articles

This has been a guide to Data models in DBMS. Here we discussed the Basic concepts and 11 different types of Data models in DBMS. You can also go through our other suggested articles to learn more –

  1. Introduction To DBMS
  2. What is Big Data
  3. Advantages of DBMS
  4. DBMS Interview Questions
  5. Different Operations related to Tuples
  6. Learn the Top 5 Types of Database Models
Popular Course in this category
SQL Training Program (7 Courses, 8+ Projects)
  7 Online Courses |  8 Hands-on Projects |  73+ Hours |  Verifiable Certificate of Completion
4.5
Price

View Course
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more