際際滷

際際滷Share a Scribd company logo
DBMS
Zaheer uddin soomro
Data Modeling
Data Model
 Graphical documentation of Data
requirement is called data model.
 It is used to confirm understanding of
data requirement
 A data model is a graphical means of
documenting data requirements and
defining database design specifications.
Types of data model
 Conceptual model,
 Think of the conceptual model as an architects conceptual drawing
of a house. It provides a good idea of what is required with very
little additional detail;
 Enterprise data model /Global Business Model
 Enterprise Data Modeling is the practice of creating a
graphical model of the data used by an enterprise or company.
 Logical model,
 detailed representation of some or all of an organization's data;
 Dimensional Model,
 techniques and concepts used in data warehouse design.
 dimensions are groups of hierarchies and descriptors that define
the facts. For example, sales amount is a fact; timestamp, product,
register#, store#, etc. are elements of dimensions
 Physical Model,
 is the final representation of the data base structures that will be
generated from the model. It contains the detailed specifications
for the database design and, in a model driven environment, the
modeling tool will generate the data definition language (DDL) that
is used to create the database structure.
If Any Question
Thanks
zaheeruddinmscs@gmail.com

More Related Content

What's hot (20)

Data model
Data modelData model
Data model
Syed Zaid Irshad
Summary data modelling
Summary data modellingSummary data modelling
Summary data modelling
Novita Sari
Database model
Database modelDatabase model
Database model
Shashwat Shriparv
Data resource management
Data resource managementData resource management
Data resource management
Nirajan Silwal
Fundamentals of Data Modeling and Database Design by Dr. Kamal Gulati
Fundamentals of Data Modeling and Database Design by Dr. Kamal GulatiFundamentals of Data Modeling and Database Design by Dr. Kamal Gulati
Fundamentals of Data Modeling and Database Design by Dr. Kamal Gulati
Amity University | FMS - DU | IMT | Stratford University | KKMI International Institute | AIMA | DTU
Database model BY ME
Database model BY MEDatabase model BY ME
Database model BY ME
cristina jane penaso
Different data models
Different data modelsDifferent data models
Different data models
madhusha udayangani
Dbms Notes Lecture 4 : Data Models in DBMS
Dbms Notes Lecture 4 : Data Models in DBMSDbms Notes Lecture 4 : Data Models in DBMS
Dbms Notes Lecture 4 : Data Models in DBMS
BIT Durg
DBMS and its Models
DBMS and its ModelsDBMS and its Models
DBMS and its Models
AhmadShah Sultani
All data models in dbms
All data models in dbmsAll data models in dbms
All data models in dbms
Naresh Kumar
Database Management & Models
Database Management & ModelsDatabase Management & Models
Database Management & Models
Sunderland City Council
Lecture 04 data resource management
Lecture 04 data resource managementLecture 04 data resource management
Lecture 04 data resource management
Dynamic Research Centre & institute
Week 3 Classification of Database Management Systems & Data Modeling
Week 3 Classification of Database Management Systems & Data ModelingWeek 3 Classification of Database Management Systems & Data Modeling
Week 3 Classification of Database Management Systems & Data Modeling
oudesign
Artifacts, Data Dictionary, Data Modeling, Data Wrangling
Artifacts, Data Dictionary, Data Modeling, Data WranglingArtifacts, Data Dictionary, Data Modeling, Data Wrangling
Artifacts, Data Dictionary, Data Modeling, Data Wrangling
Faisal Akbar
Dbms models
Dbms modelsDbms models
Dbms models
devgocool
Managing data resources
Managing  data resourcesManaging  data resources
Managing data resources
Prof. Othman Alsalloum
Data models
Data modelsData models
Data models
Usman Tariq
Data resource management and DSS
Data resource management and DSSData resource management and DSS
Data resource management and DSS
RajThakuri
Data models
Data modelsData models
Data models
KIRANPREET KAUR
Bca examination 2017 dbms
Bca examination 2017 dbmsBca examination 2017 dbms
Bca examination 2017 dbms
Anjaan Gajendra
Summary data modelling
Summary data modellingSummary data modelling
Summary data modelling
Novita Sari
Data resource management
Data resource managementData resource management
Data resource management
Nirajan Silwal
Dbms Notes Lecture 4 : Data Models in DBMS
Dbms Notes Lecture 4 : Data Models in DBMSDbms Notes Lecture 4 : Data Models in DBMS
Dbms Notes Lecture 4 : Data Models in DBMS
BIT Durg
All data models in dbms
All data models in dbmsAll data models in dbms
All data models in dbms
Naresh Kumar
Week 3 Classification of Database Management Systems & Data Modeling
Week 3 Classification of Database Management Systems & Data ModelingWeek 3 Classification of Database Management Systems & Data Modeling
Week 3 Classification of Database Management Systems & Data Modeling
oudesign
Artifacts, Data Dictionary, Data Modeling, Data Wrangling
Artifacts, Data Dictionary, Data Modeling, Data WranglingArtifacts, Data Dictionary, Data Modeling, Data Wrangling
Artifacts, Data Dictionary, Data Modeling, Data Wrangling
Faisal Akbar
Dbms models
Dbms modelsDbms models
Dbms models
devgocool
Data resource management and DSS
Data resource management and DSSData resource management and DSS
Data resource management and DSS
RajThakuri
Bca examination 2017 dbms
Bca examination 2017 dbmsBca examination 2017 dbms
Bca examination 2017 dbms
Anjaan Gajendra

Similar to Data modeling dbms (20)

Sample_Data_and_Data_Modules
Sample_Data_and_Data_ModulesSample_Data_and_Data_Modules
Sample_Data_and_Data_Modules
Michael Cook
Introduction to Data Warehouse Modelling
Introduction to Data Warehouse ModellingIntroduction to Data Warehouse Modelling
Introduction to Data Warehouse Modelling
riyasil2
LDM Webinar: Data Modeling & Business Intelligence
LDM Webinar: Data Modeling & Business IntelligenceLDM Webinar: Data Modeling & Business Intelligence
LDM Webinar: Data Modeling & Business Intelligence
DATAVERSITY
Exploring Data Modeling Techniques in Modern Data Warehouses
Exploring Data Modeling Techniques in Modern Data WarehousesExploring Data Modeling Techniques in Modern Data Warehouses
Exploring Data Modeling Techniques in Modern Data Warehouses
priyanka rajput
data modeling data modeling and its context .pptx
data modeling data modeling and its context .pptxdata modeling data modeling and its context .pptx
data modeling data modeling and its context .pptx
ssuser2690b8
data modelingEntity-Relationship (E-R) Models UML (unified modeling language)...
data modelingEntity-Relationship (E-R) Models UML (unified modeling language)...data modelingEntity-Relationship (E-R) Models UML (unified modeling language)...
data modelingEntity-Relationship (E-R) Models UML (unified modeling language)...
ssuser2690b8
types of data modeling tecnologyesy.pptx
types of data modeling tecnologyesy.pptxtypes of data modeling tecnologyesy.pptx
types of data modeling tecnologyesy.pptx
ssuser2690b8
types of data modelingEntity-Relationship (E-R) Models UML .pptx
types of data modelingEntity-Relationship (E-R) Models UML  .pptxtypes of data modelingEntity-Relationship (E-R) Models UML  .pptx
types of data modelingEntity-Relationship (E-R) Models UML .pptx
ssuser2690b8
BI architecture presentation and involved models (short)
BI architecture presentation and involved models (short)BI architecture presentation and involved models (short)
BI architecture presentation and involved models (short)
Thierry de Spirlet
Conceptual vs. Logical vs. Physical Data Modeling
Conceptual vs. Logical vs. Physical Data ModelingConceptual vs. Logical vs. Physical Data Modeling
Conceptual vs. Logical vs. Physical Data Modeling
DATAVERSITY
Data Architecture, Solution Architecture, Platform Architecture Whats the ...
Data Architecture, Solution Architecture, Platform Architecture  Whats the ...Data Architecture, Solution Architecture, Platform Architecture  Whats the ...
Data Architecture, Solution Architecture, Platform Architecture Whats the ...
DATAVERSITY
Database 2 External Schema
Database 2   External SchemaDatabase 2   External Schema
Database 2 External Schema
Ashwani Kumar Ramani
Dimensional Modeling
Dimensional ModelingDimensional Modeling
Dimensional Modeling
Sunita Sahu
Data modelling it's process and examples
Data modelling it's process and examplesData modelling it's process and examples
Data modelling it's process and examples
JayeshGadhave1
Canadian Experts Discuss Modern Data Stacks and Cloud Computing for 5 Years o...
Canadian Experts Discuss Modern Data Stacks and Cloud Computing for 5 Years o...Canadian Experts Discuss Modern Data Stacks and Cloud Computing for 5 Years o...
Canadian Experts Discuss Modern Data Stacks and Cloud Computing for 5 Years o...
Daniel Zivkovic
chapter5-220725172250-dc425eb2.pdf
chapter5-220725172250-dc425eb2.pdfchapter5-220725172250-dc425eb2.pdf
chapter5-220725172250-dc425eb2.pdf
MahmoudSOLIMAN380726
Chapter 5: Data Development
Chapter 5: Data Development Chapter 5: Data Development
Chapter 5: Data Development
Ahmed Alorage
Power BI for Big Data and the New Look of Big Data Solutions
Power BI for Big Data and the New Look of Big Data SolutionsPower BI for Big Data and the New Look of Big Data Solutions
Power BI for Big Data and the New Look of Big Data Solutions
James Serra
These Are The Data You Are Looking For
These Are The Data You Are Looking ForThese Are The Data You Are Looking For
These Are The Data You Are Looking For
Embarcadero Technologies
3._DWH_Architecture__Components.ppt
3._DWH_Architecture__Components.ppt3._DWH_Architecture__Components.ppt
3._DWH_Architecture__Components.ppt
BsMath3rdsem
Sample_Data_and_Data_Modules
Sample_Data_and_Data_ModulesSample_Data_and_Data_Modules
Sample_Data_and_Data_Modules
Michael Cook
Introduction to Data Warehouse Modelling
Introduction to Data Warehouse ModellingIntroduction to Data Warehouse Modelling
Introduction to Data Warehouse Modelling
riyasil2
LDM Webinar: Data Modeling & Business Intelligence
LDM Webinar: Data Modeling & Business IntelligenceLDM Webinar: Data Modeling & Business Intelligence
LDM Webinar: Data Modeling & Business Intelligence
DATAVERSITY
Exploring Data Modeling Techniques in Modern Data Warehouses
Exploring Data Modeling Techniques in Modern Data WarehousesExploring Data Modeling Techniques in Modern Data Warehouses
Exploring Data Modeling Techniques in Modern Data Warehouses
priyanka rajput
data modeling data modeling and its context .pptx
data modeling data modeling and its context .pptxdata modeling data modeling and its context .pptx
data modeling data modeling and its context .pptx
ssuser2690b8
data modelingEntity-Relationship (E-R) Models UML (unified modeling language)...
data modelingEntity-Relationship (E-R) Models UML (unified modeling language)...data modelingEntity-Relationship (E-R) Models UML (unified modeling language)...
data modelingEntity-Relationship (E-R) Models UML (unified modeling language)...
ssuser2690b8
types of data modeling tecnologyesy.pptx
types of data modeling tecnologyesy.pptxtypes of data modeling tecnologyesy.pptx
types of data modeling tecnologyesy.pptx
ssuser2690b8
types of data modelingEntity-Relationship (E-R) Models UML .pptx
types of data modelingEntity-Relationship (E-R) Models UML  .pptxtypes of data modelingEntity-Relationship (E-R) Models UML  .pptx
types of data modelingEntity-Relationship (E-R) Models UML .pptx
ssuser2690b8
BI architecture presentation and involved models (short)
BI architecture presentation and involved models (short)BI architecture presentation and involved models (short)
BI architecture presentation and involved models (short)
Thierry de Spirlet
Conceptual vs. Logical vs. Physical Data Modeling
Conceptual vs. Logical vs. Physical Data ModelingConceptual vs. Logical vs. Physical Data Modeling
Conceptual vs. Logical vs. Physical Data Modeling
DATAVERSITY
Data Architecture, Solution Architecture, Platform Architecture Whats the ...
Data Architecture, Solution Architecture, Platform Architecture  Whats the ...Data Architecture, Solution Architecture, Platform Architecture  Whats the ...
Data Architecture, Solution Architecture, Platform Architecture Whats the ...
DATAVERSITY
Dimensional Modeling
Dimensional ModelingDimensional Modeling
Dimensional Modeling
Sunita Sahu
Data modelling it's process and examples
Data modelling it's process and examplesData modelling it's process and examples
Data modelling it's process and examples
JayeshGadhave1
Canadian Experts Discuss Modern Data Stacks and Cloud Computing for 5 Years o...
Canadian Experts Discuss Modern Data Stacks and Cloud Computing for 5 Years o...Canadian Experts Discuss Modern Data Stacks and Cloud Computing for 5 Years o...
Canadian Experts Discuss Modern Data Stacks and Cloud Computing for 5 Years o...
Daniel Zivkovic
chapter5-220725172250-dc425eb2.pdf
chapter5-220725172250-dc425eb2.pdfchapter5-220725172250-dc425eb2.pdf
chapter5-220725172250-dc425eb2.pdf
MahmoudSOLIMAN380726
Chapter 5: Data Development
Chapter 5: Data Development Chapter 5: Data Development
Chapter 5: Data Development
Ahmed Alorage
Power BI for Big Data and the New Look of Big Data Solutions
Power BI for Big Data and the New Look of Big Data SolutionsPower BI for Big Data and the New Look of Big Data Solutions
Power BI for Big Data and the New Look of Big Data Solutions
James Serra
3._DWH_Architecture__Components.ppt
3._DWH_Architecture__Components.ppt3._DWH_Architecture__Components.ppt
3._DWH_Architecture__Components.ppt
BsMath3rdsem

Recently uploaded (20)

Chapter 4. Environmental Scanning and Industry Analysis.pdf
Chapter 4. Environmental Scanning and Industry Analysis.pdfChapter 4. Environmental Scanning and Industry Analysis.pdf
Chapter 4. Environmental Scanning and Industry Analysis.pdf
Rommel Regala
Pests of Cruciferous Crops, their Damage Symptoms and Management Practices.pptx
Pests of Cruciferous Crops, their Damage Symptoms and Management Practices.pptxPests of Cruciferous Crops, their Damage Symptoms and Management Practices.pptx
Pests of Cruciferous Crops, their Damage Symptoms and Management Practices.pptx
Deepali Shid
Shibpur_ IIEST_Preliminary Round Impetus Quiz Fest by Rudra Chakraborty BQC
Shibpur_ IIEST_Preliminary Round Impetus Quiz Fest by Rudra Chakraborty BQCShibpur_ IIEST_Preliminary Round Impetus Quiz Fest by Rudra Chakraborty BQC
Shibpur_ IIEST_Preliminary Round Impetus Quiz Fest by Rudra Chakraborty BQC
Rudra Chakraborty
Q-Factor General Quiz-2nd March 2025, Quiz Club NITW
Q-Factor General Quiz-2nd March 2025, Quiz Club NITWQ-Factor General Quiz-2nd March 2025, Quiz Club NITW
Q-Factor General Quiz-2nd March 2025, Quiz Club NITW
Quiz Club NITW
National Policy On Education-1986 (Objectives And Major Recommendations).pptx
National Policy On Education-1986 (Objectives And Major Recommendations).pptxNational Policy On Education-1986 (Objectives And Major Recommendations).pptx
National Policy On Education-1986 (Objectives And Major Recommendations).pptx
Dr. JN Gorai, PhD
Introduction of secondary metabolities.pptx
Introduction of secondary metabolities.pptxIntroduction of secondary metabolities.pptx
Introduction of secondary metabolities.pptx
Ms. Pooja Bhandare
How to Manage Reporting in Events of Odoo 18
How to Manage Reporting in Events of Odoo 18How to Manage Reporting in Events of Odoo 18
How to Manage Reporting in Events of Odoo 18
Celine George
Executive Function of Neurodivergent learners
Executive Function of Neurodivergent learnersExecutive Function of Neurodivergent learners
Executive Function of Neurodivergent learners
Pooky Knightsmith
Unit 3_Hash function and MD5 working.pdf
Unit 3_Hash function and MD5 working.pdfUnit 3_Hash function and MD5 working.pdf
Unit 3_Hash function and MD5 working.pdf
KanchanPatil34
Primary metabolites(Carbohydrates Acacia, Agar, Tragacanth, Honey).pptx
Primary metabolites(Carbohydrates Acacia, Agar, Tragacanth, Honey).pptxPrimary metabolites(Carbohydrates Acacia, Agar, Tragacanth, Honey).pptx
Primary metabolites(Carbohydrates Acacia, Agar, Tragacanth, Honey).pptx
Ms. Pooja Bhandare
The Paradox of Perfection - Publecture (EOS VU Amsterdam)
The Paradox of Perfection - Publecture (EOS VU Amsterdam)The Paradox of Perfection - Publecture (EOS VU Amsterdam)
The Paradox of Perfection - Publecture (EOS VU Amsterdam)
Wico Mulder
quarter 4 detailed lesson plan in science 7
quarter 4 detailed lesson plan in science 7quarter 4 detailed lesson plan in science 7
quarter 4 detailed lesson plan in science 7
BarcelonElaine
Abigail Sageev presents at the OECD webinar 'Improving skills outcomes throug...
Abigail Sageev presents at the OECD webinar 'Improving skills outcomes throug...Abigail Sageev presents at the OECD webinar 'Improving skills outcomes throug...
Abigail Sageev presents at the OECD webinar 'Improving skills outcomes throug...
EduSkills OECD
Fillable Strategies for Understanding and Supporting Neurodivergent Multiling...
Fillable Strategies for Understanding and Supporting Neurodivergent Multiling...Fillable Strategies for Understanding and Supporting Neurodivergent Multiling...
Fillable Strategies for Understanding and Supporting Neurodivergent Multiling...
Sean Fisher
How to Add Notes, Sections & Catalog in Odoo 18
How to Add Notes, Sections & Catalog in Odoo 18How to Add Notes, Sections & Catalog in Odoo 18
How to Add Notes, Sections & Catalog in Odoo 18
Celine George
Pharmacognosy in various systems of medicine.pptx
Pharmacognosy in various systems of medicine.pptxPharmacognosy in various systems of medicine.pptx
Pharmacognosy in various systems of medicine.pptx
Ms. Pooja Bhandare
Pests of Cucurbitaceous Vegetables, Colocasia and Moringa their Damage Sympto...
Pests of Cucurbitaceous Vegetables, Colocasia and Moringa their Damage Sympto...Pests of Cucurbitaceous Vegetables, Colocasia and Moringa their Damage Sympto...
Pests of Cucurbitaceous Vegetables, Colocasia and Moringa their Damage Sympto...
Deepali Shid
Subscription plan in odoo 17 - Odoo 際際滷s
Subscription plan in odoo 17 - Odoo 際際滷sSubscription plan in odoo 17 - Odoo 際際滷s
Subscription plan in odoo 17 - Odoo 際際滷s
Celine George
Mayo, DG March 8-Emory AI Systems and society conference slides.pdf
Mayo, DG March 8-Emory AI Systems and society conference slides.pdfMayo, DG March 8-Emory AI Systems and society conference slides.pdf
Mayo, DG March 8-Emory AI Systems and society conference slides.pdf
jemille6
Chapter 4. Environmental Scanning and Industry Analysis.pdf
Chapter 4. Environmental Scanning and Industry Analysis.pdfChapter 4. Environmental Scanning and Industry Analysis.pdf
Chapter 4. Environmental Scanning and Industry Analysis.pdf
Rommel Regala
Pests of Cruciferous Crops, their Damage Symptoms and Management Practices.pptx
Pests of Cruciferous Crops, their Damage Symptoms and Management Practices.pptxPests of Cruciferous Crops, their Damage Symptoms and Management Practices.pptx
Pests of Cruciferous Crops, their Damage Symptoms and Management Practices.pptx
Deepali Shid
Shibpur_ IIEST_Preliminary Round Impetus Quiz Fest by Rudra Chakraborty BQC
Shibpur_ IIEST_Preliminary Round Impetus Quiz Fest by Rudra Chakraborty BQCShibpur_ IIEST_Preliminary Round Impetus Quiz Fest by Rudra Chakraborty BQC
Shibpur_ IIEST_Preliminary Round Impetus Quiz Fest by Rudra Chakraborty BQC
Rudra Chakraborty
Q-Factor General Quiz-2nd March 2025, Quiz Club NITW
Q-Factor General Quiz-2nd March 2025, Quiz Club NITWQ-Factor General Quiz-2nd March 2025, Quiz Club NITW
Q-Factor General Quiz-2nd March 2025, Quiz Club NITW
Quiz Club NITW
National Policy On Education-1986 (Objectives And Major Recommendations).pptx
National Policy On Education-1986 (Objectives And Major Recommendations).pptxNational Policy On Education-1986 (Objectives And Major Recommendations).pptx
National Policy On Education-1986 (Objectives And Major Recommendations).pptx
Dr. JN Gorai, PhD
Introduction of secondary metabolities.pptx
Introduction of secondary metabolities.pptxIntroduction of secondary metabolities.pptx
Introduction of secondary metabolities.pptx
Ms. Pooja Bhandare
How to Manage Reporting in Events of Odoo 18
How to Manage Reporting in Events of Odoo 18How to Manage Reporting in Events of Odoo 18
How to Manage Reporting in Events of Odoo 18
Celine George
Executive Function of Neurodivergent learners
Executive Function of Neurodivergent learnersExecutive Function of Neurodivergent learners
Executive Function of Neurodivergent learners
Pooky Knightsmith
Unit 3_Hash function and MD5 working.pdf
Unit 3_Hash function and MD5 working.pdfUnit 3_Hash function and MD5 working.pdf
Unit 3_Hash function and MD5 working.pdf
KanchanPatil34
Primary metabolites(Carbohydrates Acacia, Agar, Tragacanth, Honey).pptx
Primary metabolites(Carbohydrates Acacia, Agar, Tragacanth, Honey).pptxPrimary metabolites(Carbohydrates Acacia, Agar, Tragacanth, Honey).pptx
Primary metabolites(Carbohydrates Acacia, Agar, Tragacanth, Honey).pptx
Ms. Pooja Bhandare
The Paradox of Perfection - Publecture (EOS VU Amsterdam)
The Paradox of Perfection - Publecture (EOS VU Amsterdam)The Paradox of Perfection - Publecture (EOS VU Amsterdam)
The Paradox of Perfection - Publecture (EOS VU Amsterdam)
Wico Mulder
quarter 4 detailed lesson plan in science 7
quarter 4 detailed lesson plan in science 7quarter 4 detailed lesson plan in science 7
quarter 4 detailed lesson plan in science 7
BarcelonElaine
Abigail Sageev presents at the OECD webinar 'Improving skills outcomes throug...
Abigail Sageev presents at the OECD webinar 'Improving skills outcomes throug...Abigail Sageev presents at the OECD webinar 'Improving skills outcomes throug...
Abigail Sageev presents at the OECD webinar 'Improving skills outcomes throug...
EduSkills OECD
Fillable Strategies for Understanding and Supporting Neurodivergent Multiling...
Fillable Strategies for Understanding and Supporting Neurodivergent Multiling...Fillable Strategies for Understanding and Supporting Neurodivergent Multiling...
Fillable Strategies for Understanding and Supporting Neurodivergent Multiling...
Sean Fisher
How to Add Notes, Sections & Catalog in Odoo 18
How to Add Notes, Sections & Catalog in Odoo 18How to Add Notes, Sections & Catalog in Odoo 18
How to Add Notes, Sections & Catalog in Odoo 18
Celine George
Pharmacognosy in various systems of medicine.pptx
Pharmacognosy in various systems of medicine.pptxPharmacognosy in various systems of medicine.pptx
Pharmacognosy in various systems of medicine.pptx
Ms. Pooja Bhandare
Pests of Cucurbitaceous Vegetables, Colocasia and Moringa their Damage Sympto...
Pests of Cucurbitaceous Vegetables, Colocasia and Moringa their Damage Sympto...Pests of Cucurbitaceous Vegetables, Colocasia and Moringa their Damage Sympto...
Pests of Cucurbitaceous Vegetables, Colocasia and Moringa their Damage Sympto...
Deepali Shid
Subscription plan in odoo 17 - Odoo 際際滷s
Subscription plan in odoo 17 - Odoo 際際滷sSubscription plan in odoo 17 - Odoo 際際滷s
Subscription plan in odoo 17 - Odoo 際際滷s
Celine George
Mayo, DG March 8-Emory AI Systems and society conference slides.pdf
Mayo, DG March 8-Emory AI Systems and society conference slides.pdfMayo, DG March 8-Emory AI Systems and society conference slides.pdf
Mayo, DG March 8-Emory AI Systems and society conference slides.pdf
jemille6

Data modeling dbms

  • 2. Data Model Graphical documentation of Data requirement is called data model. It is used to confirm understanding of data requirement A data model is a graphical means of documenting data requirements and defining database design specifications.
  • 3. Types of data model Conceptual model, Think of the conceptual model as an architects conceptual drawing of a house. It provides a good idea of what is required with very little additional detail; Enterprise data model /Global Business Model Enterprise Data Modeling is the practice of creating a graphical model of the data used by an enterprise or company. Logical model, detailed representation of some or all of an organization's data; Dimensional Model, techniques and concepts used in data warehouse design. dimensions are groups of hierarchies and descriptors that define the facts. For example, sales amount is a fact; timestamp, product, register#, store#, etc. are elements of dimensions Physical Model, is the final representation of the data base structures that will be generated from the model. It contains the detailed specifications for the database design and, in a model driven environment, the modeling tool will generate the data definition language (DDL) that is used to create the database structure.