Database Management System: Concepts and Advantages, Slides of Database Management Systems (DBMS)

Download Database Management System: Concepts and Advantages and more Slides Database Management Systems (DBMS) in PDF only on Docsity!

• Slide

Slide 2

Over View of Last Lecture

Slide 4

Def. 2

• (^) A database is self describing collection of integrated record

Slide 5

Def. 3

• (^) A database Models a particular real world system in the computer in the form of data.

Slide 7

• (^) To represent or model in the computer in the form of data
• (^) Show all rules
• (^) If not represent all the database design in not true

Slide 8

Concept of shared

Organizational database

Slide 10

A bit of History

Slide 11

• (^) A Computers initially used for computational / Engineering Purpose
• (^) A After that Used for commercial used. ( not more calculations and computation) perform the activity of data processing)

Slide 13

File Processing System

• (^) Collection of Programs That perform services for the end users such as production of reports

Slide 14

File Processing System

Library Library Application Library Data Files Examination Exam Application Exam Data Files Registration Regist. Application Registration Data Files

Slide 16 Library Reg_Number Name Father_Name Books_issued Fine Examination Reg_Number Name Address Class Semester Grade Registration Reg_Number Name Father_Name Phone Address Class

• Duplicated Data
• Inconsistency

Slide 17

Database Approach

Library Library Application Examination Exam Application Uni Student Database Registration Regist. Application DBMS

Slide 19

• (^) Better Data Security
  • (^) Faster Development of new applications

Database Approach

Advantages

Slide 20

• (^) Better Concurrency control (ATM)
  • (^) Batter backup and recovery procedure

Database Approach

Advantages