Database management system lecture number 1

Database management system

1. Database
Management
Systems
Lecture -1

2. Lecture Overview
• Database Definition
•  Comparison with the prior Data
Processing approach
•  Pros & Cons of Databases

3. What is a
Database

4. Database Def-1
A database is a shared collection of
logically related data that is stored to
meet the requirements of different
users of an organization

5. A database is a self-describing collection of
integrated records
Database Def-2

6. A database models a particular real world
system in the computer in the form of data
Database Def-3

7. The concept of a shared organizational
database
Accounting
Accounts
Payable
Accounts
Receivable
Management
Control Planning
Manufacturing
Production Scheduling
Marketing
Product
Development
Sales
Corporate
Database

8. A bit of History
• Computer initially used for computational/
engineering purposes
• Commercial applications introduced File
Processing System

9. File Processing
System
A collection of programs that perform
services for the end-users such as
production of reports

10. File Processing Systems
Program and Data Interdependence
Registration
Applications
Registration
Data
Files
Registration
Examination
Applications
Examination
Data
Files
Examination
Library
Applications
Library
Data
Files
Library

11. Fine
Books Issued
Father Name
Name
Reg_Number
Library
Grade
Semester
Class
Address
Name
Reg_Number
Examination
Class
Address
Phone
Father Name
Name
Reg_Number
Registration
File Processing Systems
Duplication of Data
Vulnerable to Inconsistency

12. Advantages of Database Approach
Registration Examination
Library
Applications
Library
Examination
Applications
Registration
Applications
Database
Management
System
University
Students
Database
- Data Sharing - Data Independence
- Controlled Redundancy - Better Data Integrity

13. Data As Resource
Resource
Any asset that is of
value to an organization
and that incurs cost

14. Is Data
A Resource ? ? ?
Data As Resource

15. Levels of Data
• Real-world data
• Metadata
• Data Occurrence

16. Database Users
• Application Programmers
• End Users
– Naïve
– Sophisticated

17. Database Users
• Database Administrator (DBA)
A person who has central control over
data and programs that access this data

18. Functions of DBA
w Schema definition
w Granting data access

19. Functions of DBA
w Routine Maintenance
w Backups
w Monitoring disk space
w Monitoring jobs running

20. Data, Database, Data Model and DBMS
Database
DBMS
“How” to get
Application Programs
“What” to get
End users
interact
Application
Programmers
Database
Administrators
Database
Designers
develop
maintain
design
Software
Users
Data

21. LOOK
we are approaching
THE END

22. Common Terms
• Data
• Information
• Database Management system
(DBMS)

23. Common Terms
• Data: Facts concerning things, such as
people, objects, or events

24. Common Terms
• Information: Data that have been processed
and presented in a form suitable for human
interpretation

25. Data, Information
and Knowledge
Data Information Knowledge &
Customer Insight
Amir
Jahangir
B.A.
Amir
Mohsin
Tahira
Jahangir
50,000
46,800
29,200
75,500
Shoes
Scarves
Jewelry
Groceries
shoes
MoU
Qty
Income
Education
Database
Queries ?
Amir is most
likely to buy new
product
Tahira is profitable
customer and is likely
to switch carriers

26. DBMS:
A software that handles all access to
the database
Common Terms

27. DBMS:
A software that is responsible for applying
the authorisation checks and validation
procedures

Common Terms

28. Database
Management
Systems
Lecture -2