Data model in dbms in Hindi | DBMS-Data models types | Database Model types in DBMS

preview_player
Показать описание
#datamodel #dbms #gate2021
Data model in DBMS: What are data models in dbms?What are the different categories of Data Models?
Examples of Data Models.
What are Data models?
Data Model is a collection of concept to describe the structure of a database.
Most data models also include a set of basic operations for specifying data retrieval and data updating.
Categories of Data Models:There are 3 Categories of Data Models:
1.High-level (conceptual) data model
2. Low-level (Physical) data model
3. Representational(Implementation) data model

What is High Level Data Model?
High Level Data models or conceptual data model provide concepts that are close to the way many users perceive data.
Conceptual data model uses concepts like entity, relation and attributes to describe the data model.
Describing the structure of a database such that even a kid or a lay man would understand it easily.
Low level Data model
Low level data model or physical data model describes how the data is stored on the physical storage.
Low level data model is not for common end user.
Physical data model is for computer specialist.
Representational data model:
Representational data model is an intermediate type of data model between the two extreme data model.
Representational data model is also called implementation data model because it is neither so difficult to understand for the end user nor at the same time it is not far from how the data is stored on the computer storage.
Representational data model hide details of data storage disk, but can be implemented on a computer directly.
What are we going to learn?
Categories of data models.
Types of data models

Categories of data models
There are 3 main categories of data models in which we can categorize data models.
High level or conceptual data model
Low level or physical data model
Representational or implementation data models
Types of data models
Entity-Relationship model
relational data model
Network model
Hierarchical model

Categories of data models
Entity-Relationship model
In entity relation data model, an entity represents a real world object or concept such as an employee or a student.
Every entity has its characteristics, which are represented as attributes.
The connection between different entities are represented with relations.

Example
Lets say we have two entities:
Employee and project
These two entities are represented like this:

Relational data model
Relational data model uses the concepts of database as a collection of tables, where each table can be stored separately as a file.
All the database operations are done with relations between the tables.
Most relational databases use high level language like SQL.
Example
Example
Hierarchical data model
Hierarchical data model organises data in a tree like structure.
Let’s say, we have a company and that company has multiple departments. Each department has multiple employees.
But one important factor of Hierarchical data model is that each child node will have a single parent node.
Example
Network data model
Network data model is like a graph and the difference between the Hierarchical data model and Network data model is that in Network data model, a child node can have multiple parent node.
Example
Рекомендации по теме
Комментарии
Автор

Thank you watching the video. SUbscribe if you liked this video and found it useful.

QuickCS
Автор

This solved my all doubts
Thanks for this video

ritik
Автор

Thank you brother for helping .thank you for explananing in simple way thanks a lot.

safalgautam.
Автор

thankyou so much sir please bihar super tet ke liye compuert teacher ka class start kijiye🙏🙏🙏🙏🙏🙏🙏

sadhnakumari
Автор

Thanks a lot sir... having watched so many videos on this topic found your video and I can proudly say I need not to visit another channel.

deepeshkatare
Автор

umm wrong shapes used in er model example, otherwise good

LostHero
Автор

To Fir conceptual data, model physical data mode, l and logical data model types hai ya FiR jo aap padha rahe ho woh data model ke type hai ?

murlikumar
Автор

Object oriented model kisme aayega fir

shailpriyaverma
Автор

Sir Phir Object Based Data Model Kis me aata

devender
Автор

Sir in ER diagrams
Entity are represented in rectangular boxes whereas attributes are denoted by oval symbols
In many of text books....
But you are saying it in reverse?
Pls clear this
Am I wrong with this query?
Pls reply

anilterapalli
Автор

Categories of data models ke video kaha h sr

naziaaaa
Автор

i can not found categories of data model please send the link

sudhirpajiyar