KEMBAR78
DBMS Essentials for Students | PDF | Business | Databases
Scribd
Upload
157 views15 pages

DBMS Essentials for Students

The document discusses database management systems. It defines a DBMS as a collection of interrelated data and programs used to access the data. A DBMS contains information about a particular enterprise and provides an efficient environment. It then gives examples of database applications in industries like banking, airlines, universities, sales and manufacturing. The document outlines basic DBMS characteristics like file creation, data entry, retrieval, updating and reporting. It also discusses three-tier applications, data hierarchy, table/record structure, the role of a database administrator, shared data, and the relational model. Finally, it provides examples of querying and updating a database using SQL.

Uploaded by

Kunal Shukla
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
157 views15 pages

DBMS Essentials for Students

The document discusses database management systems. It defines a DBMS as a collection of interrelated data and programs used to access the data. A DBMS contains information about a particular enterprise and provides an efficient environment. It then gives examples of database applications in industries like banking, airlines, universities, sales and manufacturing. The document outlines basic DBMS characteristics like file creation, data entry, retrieval, updating and reporting. It also discusses three-tier applications, data hierarchy, table/record structure, the role of a database administrator, shared data, and the relational model. Finally, it provides examples of querying and updating a database using SQL.

Uploaded by

Kunal Shukla
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
You are on page 1/ 15

Databases Management System

Kunal Kishore
PGDM-I
S.M.S., Varanasi

Database Management System 1


Database Management System

 Collection of interrelated data


 Set of programs to access the data
 DBMS contains information about a
particular enterprise
 DBMS provides an environment that is both
convenient and efficient to use.

Database Management System 2


Database Applications:

 Banking:
 Airlines:
 Universities:
 Sales:
 Manufacturing:
 Human resources

 Databases touch all aspects of our lives

Database Management System 3


Basic Characteristics of DBMS

 File creation  Generate Reports


 Data entry  Respond to Queries
 Rapid data retrieval  NOTE: these also
 Updating/edit-ing apply to file
data managers

Database Management System 4


Three Tier Applications

 Tier One : Client


 e.g., web browser
 Tier Two : Application Server
 e.g. enhanced web server
 Tier Three: Database Server

Database Management System 5


Data Hierarchy
 Bit
 Byte/Character
 Field
 Record
 File/Table
 Database
Table Structure/Record
Structure/Record Format

 Defines the data. Tells the DBMS what to


expect.
 Consists of:
– Field Name
– Data Type (text, date, number, counter, memo)
– Field Size
– Field Description (optional)

Database Management System 7


Table Structure
 Field Name Type Width Description
 LNAME t 8 Last Name
 FNAME t 8 First Name
 STREET t 15 Street Add
 CITY t 10 City
 STATE t 2 State
 ZIP t 10 Zip
 PHONE t 12 Phone
 BDATE d 8 Birth Date
Database Management System 8
Database Administrator

 Design, operate, implement


 Coordinate with users
 System security
 Backup/Recovery
 Monitor Performance
Shared Data
 *Employee data (schema)
 Name Address Tele. Benefits
 *Personnel data (sub-schema)
 Name Address Tele.
 *Benefits data (sub-schema)
 Name Address Benefits

Database Management System 10


More DBMS Characteristics

 Able to share data


 More program independence
 Establish relationships
 Maintain data integrity/file security

Database Management System 11


Relational Model: Tabular Data
Account Name Address Balance
Number
23456 H. Mehta Madhuli, Mumbai 40,000,000
23457 Bill Gates Microsoft Corp 9999,999,999
23458 Kunal Kishore E-327, Ranchi-04 1,000
Date Acct Debit Credit Balance
Account Num
19/11/09 23458 2000 3000
19/11/09 23456 2000 3000
20/11/09 23456 9000 12000
Transactions
23/11/09 23456 200000 212000
23/11/09 23458 4000 7000
Database Management System 12
Querying/Updating the Database using
SQL
 SQL Query:
select name, balance
from account
where acct-num = 23456
 insert into transactions
values (3/5/99, 23456, 5000, -, 14000)

Database Management System 13


Database Ethics
 Accurate

 Complete

 Private
Thank You

You might also like