SlideShare a Scribd company logo
DATABASE MANAGEMENT
SYSTEM
Prepared by
NIJAZ N
ORGANIZING DATA IN A TRADITIONAL FILE
ENVIRONMENT
 Organize data in fields ,records and files.
 Field - A grouping of characters into a word, a group of words or a
complete number (eg: person’s name or age) is called a field.
 Record – A group of related fields comprises a record (eg: student’s
name, course taken, date and grade)
 File - A group of records of the same type (eg: course file)
 Difficult to keep track of all the pieces of data.
 Different functional areas and groups were allowed to develop their own
files independently.
PROBLEMS WITH FILE SYSTEM
Data Redundancy • Presence of duplicate data in multiple files so that
the same data are stored in more than one place or
location.
Data Inconsistency • Same data may have different values.
Lack of flexibility • Difficult to deliver ad hoc reports or respond to
unanticipated information requirements in a timely
fashions.
Poor Security •Little control over data or access of data.
Lack of Data Sharing • Information cannot flow freely across different
functional areas
DATABASE
 Is a collection of data organized.
 Serve many applications efficiently by
 Centralizing the data
 Controlling the redundant data.
 A single database services multiple application rather than storing data in
separate files for each application.
 E.g.:-
 A University database through which university applications from the
Registrar’s office, the Accounting department, and the Examination
department access data
DBMS
 Software that defines a database, stores the data, supports a query
language, produces reports, and creates data-entry screens.
 A DBMS is software that:
 Acts as an interface between application programs and the data files.
 Helps to reduce data redundancy and eliminate data inconsistency by
allowing a central, shared data source
Physical view
DBMS
Logical View
LOGICAL & PHYSICAL VIEW
Data as perceived by
end users/business
specialists
How data are actually
organized on physical
storage media
DBMS
Data
definition
Language
DDL
Data
Dictionary
Data
Manipulation
Language
DML
DBMS – COMPONENTS/REQUIREMENTSFormal language used
by the programmers
to specify the
structure/content of
the database
Contains commands
that permit end users
to extract data from
the database to satisfy
information requests
Automated/manual
file that stores
definitions of data
elements and data
characteristics
DATABASE MODELS /TYPES
Database
Models
Relationship
Model
Hierarchical
Model
Network
Object
Oriented
RELATIONSHIP MODEL
 Proposed in 1969 by Edgar F. Codd
 Depicts data logically as many-to-many relationships
 All data is represented in terms of tuples, grouped into relations
Order list of elements
HIERARCHICAL MODEL
 Organizes data in a tree-like structure
 Supports one-to-many /parent-child relationships
 Prevalent in large legacy systems
NETWORK MODEL
 Depicts data logically as many-to-many relationships
 Object types are nodes and relationship types are arcs
OBJECT ORIENTED MODEL
 Organizes data in a tree-like structure
 Supports one-to-many parent-child relationships
 Prevalent in large legacy systems
Ad

More Related Content

What's hot (20)

Type of database models
Type of database modelsType of database models
Type of database models
SanthiNivas
 
Introduction to Database
Introduction to DatabaseIntroduction to Database
Introduction to Database
Syed Zaid Irshad
 
Data Models [DATABASE SYSTEMS: Design, Implementation, and Management]
Data Models [DATABASE SYSTEMS: Design, Implementation, and Management]Data Models [DATABASE SYSTEMS: Design, Implementation, and Management]
Data Models [DATABASE SYSTEMS: Design, Implementation, and Management]
Usman Tariq
 
Data models
Data modelsData models
Data models
Anuj Modi
 
Database management system
Database management system Database management system
Database management system
Shashikumar_chari
 
Dbms database models
Dbms database modelsDbms database models
Dbms database models
sanjeev kumar suman
 
Dbms slides
Dbms slidesDbms slides
Dbms slides
rahulrathore725
 
Dw & etl concepts
Dw & etl conceptsDw & etl concepts
Dw & etl concepts
jeshocarme
 
Data Base Management System
Data Base Management SystemData Base Management System
Data Base Management System
Dr. C.V. Suresh Babu
 
Ppt
PptPpt
Ppt
bullsrockr666
 
DbMs
DbMsDbMs
DbMs
amanrock2012
 
Basic Concept Of Database Management System (DBMS) [Presentation Slide]
Basic Concept Of Database Management System (DBMS) [Presentation Slide]Basic Concept Of Database Management System (DBMS) [Presentation Slide]
Basic Concept Of Database Management System (DBMS) [Presentation Slide]
Atik Israk
 
Advanced Database System
Advanced Database SystemAdvanced Database System
Advanced Database System
sushmita rathour
 
Introduction to database
Introduction to databaseIntroduction to database
Introduction to database
Arpee Callejo
 
DBMS an Example
DBMS an ExampleDBMS an Example
DBMS an Example
Dr. C.V. Suresh Babu
 
Database management system presentation
Database management system presentationDatabase management system presentation
Database management system presentation
sameerraaj
 
1.4 data warehouse
1.4 data warehouse1.4 data warehouse
1.4 data warehouse
Krish_ver2
 
Complete dbms notes
Complete dbms notesComplete dbms notes
Complete dbms notes
Tanya Makkar
 
Chapter02
Chapter02Chapter02
Chapter02
sasa_eldoby
 
Files Vs DataBase
Files Vs DataBaseFiles Vs DataBase
Files Vs DataBase
Dr. C.V. Suresh Babu
 
Type of database models
Type of database modelsType of database models
Type of database models
SanthiNivas
 
Data Models [DATABASE SYSTEMS: Design, Implementation, and Management]
Data Models [DATABASE SYSTEMS: Design, Implementation, and Management]Data Models [DATABASE SYSTEMS: Design, Implementation, and Management]
Data Models [DATABASE SYSTEMS: Design, Implementation, and Management]
Usman Tariq
 
Dw & etl concepts
Dw & etl conceptsDw & etl concepts
Dw & etl concepts
jeshocarme
 
Basic Concept Of Database Management System (DBMS) [Presentation Slide]
Basic Concept Of Database Management System (DBMS) [Presentation Slide]Basic Concept Of Database Management System (DBMS) [Presentation Slide]
Basic Concept Of Database Management System (DBMS) [Presentation Slide]
Atik Israk
 
Introduction to database
Introduction to databaseIntroduction to database
Introduction to database
Arpee Callejo
 
Database management system presentation
Database management system presentationDatabase management system presentation
Database management system presentation
sameerraaj
 
1.4 data warehouse
1.4 data warehouse1.4 data warehouse
1.4 data warehouse
Krish_ver2
 
Complete dbms notes
Complete dbms notesComplete dbms notes
Complete dbms notes
Tanya Makkar
 

Similar to Database Management Systems - Management Information System (20)

Dbms9
Dbms9Dbms9
Dbms9
Nandi Institute of Technology and Management Sciences
 
6.2 software
6.2 software6.2 software
6.2 software
fahrie_khai_sab_taufiq
 
Data base
Data baseData base
Data base
Gc university faisalabad
 
Dbms mca-section a
Dbms mca-section aDbms mca-section a
Dbms mca-section a
Vaibhav Kathuria
 
Relational database revised
Relational database revisedRelational database revised
Relational database revised
mnodalo
 
Ch # 09 database management system
Ch # 09 database management systemCh # 09 database management system
Ch # 09 database management system
MuhammadRobeel3
 
Database Systems Lec 1.pptx
Database Systems Lec 1.pptxDatabase Systems Lec 1.pptx
Database Systems Lec 1.pptx
NishaTariq1
 
Database Management System Introduction
Database Management System IntroductionDatabase Management System Introduction
Database Management System Introduction
Smriti Jain
 
Ch-1-Introduction-to-Database.pdf
Ch-1-Introduction-to-Database.pdfCh-1-Introduction-to-Database.pdf
Ch-1-Introduction-to-Database.pdf
MrjJoker1
 
27 fcs157al2
27 fcs157al227 fcs157al2
27 fcs157al2
CHANDRA BHUSHAN
 
Presentation of DBMS (database management system) part 2
Presentation of DBMS (database management system) part 2Presentation of DBMS (database management system) part 2
Presentation of DBMS (database management system) part 2
Junaid Nadeem
 
Spatial Database and Database Management System
Spatial Database and Database Management SystemSpatial Database and Database Management System
Spatial Database and Database Management System
Lal Mohammad
 
DBS Theory Week 1 including relationships and relational database
DBS Theory Week 1 including relationships and relational databaseDBS Theory Week 1 including relationships and relational database
DBS Theory Week 1 including relationships and relational database
walaahuluu
 
Introduction to Database (Lecture 1).ppt
Introduction to Database (Lecture 1).pptIntroduction to Database (Lecture 1).ppt
Introduction to Database (Lecture 1).ppt
RuelDogma1
 
Database Management
Database ManagementDatabase Management
Database Management
Ali Khalid
 
Database_Concepts_Final.pptx.pdf for class 12
Database_Concepts_Final.pptx.pdf for class 12Database_Concepts_Final.pptx.pdf for class 12
Database_Concepts_Final.pptx.pdf for class 12
pramodcoder1319
 
Database 1 Introduction
Database 1   IntroductionDatabase 1   Introduction
Database 1 Introduction
Ashwani Kumar Ramani
 
DATABASE SYSTEMS VS ROUTINE FILE SYSTEMS
DATABASE SYSTEMS VS ROUTINE FILE SYSTEMSDATABASE SYSTEMS VS ROUTINE FILE SYSTEMS
DATABASE SYSTEMS VS ROUTINE FILE SYSTEMS
MunawarAhmad22
 
LEARNING OBJECTIVES education relational.pptx
LEARNING OBJECTIVES education relational.pptxLEARNING OBJECTIVES education relational.pptx
LEARNING OBJECTIVES education relational.pptx
OmarOmar731335
 
Dbms
Dbms Dbms
Dbms
Tej Kiran
 
Relational database revised
Relational database revisedRelational database revised
Relational database revised
mnodalo
 
Ch # 09 database management system
Ch # 09 database management systemCh # 09 database management system
Ch # 09 database management system
MuhammadRobeel3
 
Database Systems Lec 1.pptx
Database Systems Lec 1.pptxDatabase Systems Lec 1.pptx
Database Systems Lec 1.pptx
NishaTariq1
 
Database Management System Introduction
Database Management System IntroductionDatabase Management System Introduction
Database Management System Introduction
Smriti Jain
 
Ch-1-Introduction-to-Database.pdf
Ch-1-Introduction-to-Database.pdfCh-1-Introduction-to-Database.pdf
Ch-1-Introduction-to-Database.pdf
MrjJoker1
 
Presentation of DBMS (database management system) part 2
Presentation of DBMS (database management system) part 2Presentation of DBMS (database management system) part 2
Presentation of DBMS (database management system) part 2
Junaid Nadeem
 
Spatial Database and Database Management System
Spatial Database and Database Management SystemSpatial Database and Database Management System
Spatial Database and Database Management System
Lal Mohammad
 
DBS Theory Week 1 including relationships and relational database
DBS Theory Week 1 including relationships and relational databaseDBS Theory Week 1 including relationships and relational database
DBS Theory Week 1 including relationships and relational database
walaahuluu
 
Introduction to Database (Lecture 1).ppt
Introduction to Database (Lecture 1).pptIntroduction to Database (Lecture 1).ppt
Introduction to Database (Lecture 1).ppt
RuelDogma1
 
Database Management
Database ManagementDatabase Management
Database Management
Ali Khalid
 
Database_Concepts_Final.pptx.pdf for class 12
Database_Concepts_Final.pptx.pdf for class 12Database_Concepts_Final.pptx.pdf for class 12
Database_Concepts_Final.pptx.pdf for class 12
pramodcoder1319
 
DATABASE SYSTEMS VS ROUTINE FILE SYSTEMS
DATABASE SYSTEMS VS ROUTINE FILE SYSTEMSDATABASE SYSTEMS VS ROUTINE FILE SYSTEMS
DATABASE SYSTEMS VS ROUTINE FILE SYSTEMS
MunawarAhmad22
 
LEARNING OBJECTIVES education relational.pptx
LEARNING OBJECTIVES education relational.pptxLEARNING OBJECTIVES education relational.pptx
LEARNING OBJECTIVES education relational.pptx
OmarOmar731335
 
Ad

More from Nijaz N (20)

Organising skills
Organising skillsOrganising skills
Organising skills
Nijaz N
 
Non-Verbal Communication
Non-Verbal Communication Non-Verbal Communication
Non-Verbal Communication
Nijaz N
 
Feasibility planning
Feasibility planningFeasibility planning
Feasibility planning
Nijaz N
 
Business plan - Entrepreneurship
Business plan - EntrepreneurshipBusiness plan - Entrepreneurship
Business plan - Entrepreneurship
Nijaz N
 
Small business
Small businessSmall business
Small business
Nijaz N
 
Entrepreneurship
EntrepreneurshipEntrepreneurship
Entrepreneurship
Nijaz N
 
Research methods for managers - Questions
Research methods for managers - QuestionsResearch methods for managers - Questions
Research methods for managers - Questions
Nijaz N
 
Non verbal communication
Non verbal communicationNon verbal communication
Non verbal communication
Nijaz N
 
Neuro linguestic programming
Neuro linguestic programmingNeuro linguestic programming
Neuro linguestic programming
Nijaz N
 
Life cycle of an entrpreneural venture
Life cycle of an entrpreneural ventureLife cycle of an entrpreneural venture
Life cycle of an entrpreneural venture
Nijaz N
 
Group discussion
Group discussionGroup discussion
Group discussion
Nijaz N
 
Franchising
FranchisingFranchising
Franchising
Nijaz N
 
Communication digitally
Communication digitallyCommunication digitally
Communication digitally
Nijaz N
 
Business communication module 5 - Kerala University
Business communication module 5 - Kerala UniversityBusiness communication module 5 - Kerala University
Business communication module 5 - Kerala University
Nijaz N
 
Business communication module 4 - Kerala University
Business communication module 4 - Kerala UniversityBusiness communication module 4 - Kerala University
Business communication module 4 - Kerala University
Nijaz N
 
Business communication module 3 - Kerala University
Business communication module 3 - Kerala UniversityBusiness communication module 3 - Kerala University
Business communication module 3 - Kerala University
Nijaz N
 
Business communication -Assignment - Kerala University
Business communication  -Assignment - Kerala UniversityBusiness communication  -Assignment - Kerala University
Business communication -Assignment - Kerala University
Nijaz N
 
Business communication module 2 - Kerala University
Business communication module 2 - Kerala UniversityBusiness communication module 2 - Kerala University
Business communication module 2 - Kerala University
Nijaz N
 
Business communication module 1 - Kerala University
Business communication module 1 - Kerala UniversityBusiness communication module 1 - Kerala University
Business communication module 1 - Kerala University
Nijaz N
 
Acquiring an established venture
Acquiring an established ventureAcquiring an established venture
Acquiring an established venture
Nijaz N
 
Organising skills
Organising skillsOrganising skills
Organising skills
Nijaz N
 
Non-Verbal Communication
Non-Verbal Communication Non-Verbal Communication
Non-Verbal Communication
Nijaz N
 
Feasibility planning
Feasibility planningFeasibility planning
Feasibility planning
Nijaz N
 
Business plan - Entrepreneurship
Business plan - EntrepreneurshipBusiness plan - Entrepreneurship
Business plan - Entrepreneurship
Nijaz N
 
Small business
Small businessSmall business
Small business
Nijaz N
 
Entrepreneurship
EntrepreneurshipEntrepreneurship
Entrepreneurship
Nijaz N
 
Research methods for managers - Questions
Research methods for managers - QuestionsResearch methods for managers - Questions
Research methods for managers - Questions
Nijaz N
 
Non verbal communication
Non verbal communicationNon verbal communication
Non verbal communication
Nijaz N
 
Neuro linguestic programming
Neuro linguestic programmingNeuro linguestic programming
Neuro linguestic programming
Nijaz N
 
Life cycle of an entrpreneural venture
Life cycle of an entrpreneural ventureLife cycle of an entrpreneural venture
Life cycle of an entrpreneural venture
Nijaz N
 
Group discussion
Group discussionGroup discussion
Group discussion
Nijaz N
 
Franchising
FranchisingFranchising
Franchising
Nijaz N
 
Communication digitally
Communication digitallyCommunication digitally
Communication digitally
Nijaz N
 
Business communication module 5 - Kerala University
Business communication module 5 - Kerala UniversityBusiness communication module 5 - Kerala University
Business communication module 5 - Kerala University
Nijaz N
 
Business communication module 4 - Kerala University
Business communication module 4 - Kerala UniversityBusiness communication module 4 - Kerala University
Business communication module 4 - Kerala University
Nijaz N
 
Business communication module 3 - Kerala University
Business communication module 3 - Kerala UniversityBusiness communication module 3 - Kerala University
Business communication module 3 - Kerala University
Nijaz N
 
Business communication -Assignment - Kerala University
Business communication  -Assignment - Kerala UniversityBusiness communication  -Assignment - Kerala University
Business communication -Assignment - Kerala University
Nijaz N
 
Business communication module 2 - Kerala University
Business communication module 2 - Kerala UniversityBusiness communication module 2 - Kerala University
Business communication module 2 - Kerala University
Nijaz N
 
Business communication module 1 - Kerala University
Business communication module 1 - Kerala UniversityBusiness communication module 1 - Kerala University
Business communication module 1 - Kerala University
Nijaz N
 
Acquiring an established venture
Acquiring an established ventureAcquiring an established venture
Acquiring an established venture
Nijaz N
 
Ad

Recently uploaded (20)

Shoehorning dependency injection into a FP language, what does it take?
Shoehorning dependency injection into a FP language, what does it take?Shoehorning dependency injection into a FP language, what does it take?
Shoehorning dependency injection into a FP language, what does it take?
Eric Torreborre
 
Integrating FME with Python: Tips, Demos, and Best Practices for Powerful Aut...
Integrating FME with Python: Tips, Demos, and Best Practices for Powerful Aut...Integrating FME with Python: Tips, Demos, and Best Practices for Powerful Aut...
Integrating FME with Python: Tips, Demos, and Best Practices for Powerful Aut...
Safe Software
 
Zilliz Cloud Monthly Technical Review: May 2025
Zilliz Cloud Monthly Technical Review: May 2025Zilliz Cloud Monthly Technical Review: May 2025
Zilliz Cloud Monthly Technical Review: May 2025
Zilliz
 
Enterprise Integration Is Dead! Long Live AI-Driven Integration with Apache C...
Enterprise Integration Is Dead! Long Live AI-Driven Integration with Apache C...Enterprise Integration Is Dead! Long Live AI-Driven Integration with Apache C...
Enterprise Integration Is Dead! Long Live AI-Driven Integration with Apache C...
Markus Eisele
 
AI Agents at Work: UiPath, Maestro & the Future of Documents
AI Agents at Work: UiPath, Maestro & the Future of DocumentsAI Agents at Work: UiPath, Maestro & the Future of Documents
AI Agents at Work: UiPath, Maestro & the Future of Documents
UiPathCommunity
 
Dark Dynamism: drones, dark factories and deurbanization
Dark Dynamism: drones, dark factories and deurbanizationDark Dynamism: drones, dark factories and deurbanization
Dark Dynamism: drones, dark factories and deurbanization
Jakub Šimek
 
RTP Over QUIC: An Interesting Opportunity Or Wasted Time?
RTP Over QUIC: An Interesting Opportunity Or Wasted Time?RTP Over QUIC: An Interesting Opportunity Or Wasted Time?
RTP Over QUIC: An Interesting Opportunity Or Wasted Time?
Lorenzo Miniero
 
AI-proof your career by Olivier Vroom and David WIlliamson
AI-proof your career by Olivier Vroom and David WIlliamsonAI-proof your career by Olivier Vroom and David WIlliamson
AI-proof your career by Olivier Vroom and David WIlliamson
UXPA Boston
 
Developing System Infrastructure Design Plan.pptx
Developing System Infrastructure Design Plan.pptxDeveloping System Infrastructure Design Plan.pptx
Developing System Infrastructure Design Plan.pptx
wondimagegndesta
 
Could Virtual Threads cast away the usage of Kotlin Coroutines - DevoxxUK2025
Could Virtual Threads cast away the usage of Kotlin Coroutines - DevoxxUK2025Could Virtual Threads cast away the usage of Kotlin Coroutines - DevoxxUK2025
Could Virtual Threads cast away the usage of Kotlin Coroutines - DevoxxUK2025
João Esperancinha
 
Limecraft Webinar - 2025.3 release, featuring Content Delivery, Graphic Conte...
Limecraft Webinar - 2025.3 release, featuring Content Delivery, Graphic Conte...Limecraft Webinar - 2025.3 release, featuring Content Delivery, Graphic Conte...
Limecraft Webinar - 2025.3 release, featuring Content Delivery, Graphic Conte...
Maarten Verwaest
 
How to Install & Activate ListGrabber - eGrabber
How to Install & Activate ListGrabber - eGrabberHow to Install & Activate ListGrabber - eGrabber
How to Install & Activate ListGrabber - eGrabber
eGrabber
 
IT488 Wireless Sensor Networks_Information Technology
IT488 Wireless Sensor Networks_Information TechnologyIT488 Wireless Sensor Networks_Information Technology
IT488 Wireless Sensor Networks_Information Technology
SHEHABALYAMANI
 
Design pattern talk by Kaya Weers - 2025 (v2)
Design pattern talk by Kaya Weers - 2025 (v2)Design pattern talk by Kaya Weers - 2025 (v2)
Design pattern talk by Kaya Weers - 2025 (v2)
Kaya Weers
 
Bepents tech services - a premier cybersecurity consulting firm
Bepents tech services - a premier cybersecurity consulting firmBepents tech services - a premier cybersecurity consulting firm
Bepents tech services - a premier cybersecurity consulting firm
Benard76
 
Build With AI - In Person Session Slides.pdf
Build With AI - In Person Session Slides.pdfBuild With AI - In Person Session Slides.pdf
Build With AI - In Person Session Slides.pdf
Google Developer Group - Harare
 
GDG Cloud Southlake #42: Suresh Mathew: Autonomous Resource Optimization: How...
GDG Cloud Southlake #42: Suresh Mathew: Autonomous Resource Optimization: How...GDG Cloud Southlake #42: Suresh Mathew: Autonomous Resource Optimization: How...
GDG Cloud Southlake #42: Suresh Mathew: Autonomous Resource Optimization: How...
James Anderson
 
AI 3-in-1: Agents, RAG, and Local Models - Brent Laster
AI 3-in-1: Agents, RAG, and Local Models - Brent LasterAI 3-in-1: Agents, RAG, and Local Models - Brent Laster
AI 3-in-1: Agents, RAG, and Local Models - Brent Laster
All Things Open
 
Challenges in Migrating Imperative Deep Learning Programs to Graph Execution:...
Challenges in Migrating Imperative Deep Learning Programs to Graph Execution:...Challenges in Migrating Imperative Deep Learning Programs to Graph Execution:...
Challenges in Migrating Imperative Deep Learning Programs to Graph Execution:...
Raffi Khatchadourian
 
Building the Customer Identity Community, Together.pdf
Building the Customer Identity Community, Together.pdfBuilding the Customer Identity Community, Together.pdf
Building the Customer Identity Community, Together.pdf
Cheryl Hung
 
Shoehorning dependency injection into a FP language, what does it take?
Shoehorning dependency injection into a FP language, what does it take?Shoehorning dependency injection into a FP language, what does it take?
Shoehorning dependency injection into a FP language, what does it take?
Eric Torreborre
 
Integrating FME with Python: Tips, Demos, and Best Practices for Powerful Aut...
Integrating FME with Python: Tips, Demos, and Best Practices for Powerful Aut...Integrating FME with Python: Tips, Demos, and Best Practices for Powerful Aut...
Integrating FME with Python: Tips, Demos, and Best Practices for Powerful Aut...
Safe Software
 
Zilliz Cloud Monthly Technical Review: May 2025
Zilliz Cloud Monthly Technical Review: May 2025Zilliz Cloud Monthly Technical Review: May 2025
Zilliz Cloud Monthly Technical Review: May 2025
Zilliz
 
Enterprise Integration Is Dead! Long Live AI-Driven Integration with Apache C...
Enterprise Integration Is Dead! Long Live AI-Driven Integration with Apache C...Enterprise Integration Is Dead! Long Live AI-Driven Integration with Apache C...
Enterprise Integration Is Dead! Long Live AI-Driven Integration with Apache C...
Markus Eisele
 
AI Agents at Work: UiPath, Maestro & the Future of Documents
AI Agents at Work: UiPath, Maestro & the Future of DocumentsAI Agents at Work: UiPath, Maestro & the Future of Documents
AI Agents at Work: UiPath, Maestro & the Future of Documents
UiPathCommunity
 
Dark Dynamism: drones, dark factories and deurbanization
Dark Dynamism: drones, dark factories and deurbanizationDark Dynamism: drones, dark factories and deurbanization
Dark Dynamism: drones, dark factories and deurbanization
Jakub Šimek
 
RTP Over QUIC: An Interesting Opportunity Or Wasted Time?
RTP Over QUIC: An Interesting Opportunity Or Wasted Time?RTP Over QUIC: An Interesting Opportunity Or Wasted Time?
RTP Over QUIC: An Interesting Opportunity Or Wasted Time?
Lorenzo Miniero
 
AI-proof your career by Olivier Vroom and David WIlliamson
AI-proof your career by Olivier Vroom and David WIlliamsonAI-proof your career by Olivier Vroom and David WIlliamson
AI-proof your career by Olivier Vroom and David WIlliamson
UXPA Boston
 
Developing System Infrastructure Design Plan.pptx
Developing System Infrastructure Design Plan.pptxDeveloping System Infrastructure Design Plan.pptx
Developing System Infrastructure Design Plan.pptx
wondimagegndesta
 
Could Virtual Threads cast away the usage of Kotlin Coroutines - DevoxxUK2025
Could Virtual Threads cast away the usage of Kotlin Coroutines - DevoxxUK2025Could Virtual Threads cast away the usage of Kotlin Coroutines - DevoxxUK2025
Could Virtual Threads cast away the usage of Kotlin Coroutines - DevoxxUK2025
João Esperancinha
 
Limecraft Webinar - 2025.3 release, featuring Content Delivery, Graphic Conte...
Limecraft Webinar - 2025.3 release, featuring Content Delivery, Graphic Conte...Limecraft Webinar - 2025.3 release, featuring Content Delivery, Graphic Conte...
Limecraft Webinar - 2025.3 release, featuring Content Delivery, Graphic Conte...
Maarten Verwaest
 
How to Install & Activate ListGrabber - eGrabber
How to Install & Activate ListGrabber - eGrabberHow to Install & Activate ListGrabber - eGrabber
How to Install & Activate ListGrabber - eGrabber
eGrabber
 
IT488 Wireless Sensor Networks_Information Technology
IT488 Wireless Sensor Networks_Information TechnologyIT488 Wireless Sensor Networks_Information Technology
IT488 Wireless Sensor Networks_Information Technology
SHEHABALYAMANI
 
Design pattern talk by Kaya Weers - 2025 (v2)
Design pattern talk by Kaya Weers - 2025 (v2)Design pattern talk by Kaya Weers - 2025 (v2)
Design pattern talk by Kaya Weers - 2025 (v2)
Kaya Weers
 
Bepents tech services - a premier cybersecurity consulting firm
Bepents tech services - a premier cybersecurity consulting firmBepents tech services - a premier cybersecurity consulting firm
Bepents tech services - a premier cybersecurity consulting firm
Benard76
 
GDG Cloud Southlake #42: Suresh Mathew: Autonomous Resource Optimization: How...
GDG Cloud Southlake #42: Suresh Mathew: Autonomous Resource Optimization: How...GDG Cloud Southlake #42: Suresh Mathew: Autonomous Resource Optimization: How...
GDG Cloud Southlake #42: Suresh Mathew: Autonomous Resource Optimization: How...
James Anderson
 
AI 3-in-1: Agents, RAG, and Local Models - Brent Laster
AI 3-in-1: Agents, RAG, and Local Models - Brent LasterAI 3-in-1: Agents, RAG, and Local Models - Brent Laster
AI 3-in-1: Agents, RAG, and Local Models - Brent Laster
All Things Open
 
Challenges in Migrating Imperative Deep Learning Programs to Graph Execution:...
Challenges in Migrating Imperative Deep Learning Programs to Graph Execution:...Challenges in Migrating Imperative Deep Learning Programs to Graph Execution:...
Challenges in Migrating Imperative Deep Learning Programs to Graph Execution:...
Raffi Khatchadourian
 
Building the Customer Identity Community, Together.pdf
Building the Customer Identity Community, Together.pdfBuilding the Customer Identity Community, Together.pdf
Building the Customer Identity Community, Together.pdf
Cheryl Hung
 

Database Management Systems - Management Information System

  • 2. ORGANIZING DATA IN A TRADITIONAL FILE ENVIRONMENT  Organize data in fields ,records and files.  Field - A grouping of characters into a word, a group of words or a complete number (eg: person’s name or age) is called a field.  Record – A group of related fields comprises a record (eg: student’s name, course taken, date and grade)  File - A group of records of the same type (eg: course file)  Difficult to keep track of all the pieces of data.  Different functional areas and groups were allowed to develop their own files independently.
  • 3. PROBLEMS WITH FILE SYSTEM Data Redundancy • Presence of duplicate data in multiple files so that the same data are stored in more than one place or location. Data Inconsistency • Same data may have different values. Lack of flexibility • Difficult to deliver ad hoc reports or respond to unanticipated information requirements in a timely fashions. Poor Security •Little control over data or access of data. Lack of Data Sharing • Information cannot flow freely across different functional areas
  • 4. DATABASE  Is a collection of data organized.  Serve many applications efficiently by  Centralizing the data  Controlling the redundant data.  A single database services multiple application rather than storing data in separate files for each application.  E.g.:-  A University database through which university applications from the Registrar’s office, the Accounting department, and the Examination department access data
  • 5. DBMS  Software that defines a database, stores the data, supports a query language, produces reports, and creates data-entry screens.  A DBMS is software that:  Acts as an interface between application programs and the data files.  Helps to reduce data redundancy and eliminate data inconsistency by allowing a central, shared data source
  • 6. Physical view DBMS Logical View LOGICAL & PHYSICAL VIEW Data as perceived by end users/business specialists How data are actually organized on physical storage media
  • 7. DBMS Data definition Language DDL Data Dictionary Data Manipulation Language DML DBMS – COMPONENTS/REQUIREMENTSFormal language used by the programmers to specify the structure/content of the database Contains commands that permit end users to extract data from the database to satisfy information requests Automated/manual file that stores definitions of data elements and data characteristics
  • 9. RELATIONSHIP MODEL  Proposed in 1969 by Edgar F. Codd  Depicts data logically as many-to-many relationships  All data is represented in terms of tuples, grouped into relations Order list of elements
  • 10. HIERARCHICAL MODEL  Organizes data in a tree-like structure  Supports one-to-many /parent-child relationships  Prevalent in large legacy systems
  • 11. NETWORK MODEL  Depicts data logically as many-to-many relationships  Object types are nodes and relationship types are arcs
  • 12. OBJECT ORIENTED MODEL  Organizes data in a tree-like structure  Supports one-to-many parent-child relationships  Prevalent in large legacy systems
  翻译: