database management systems lecture 01
TRANSCRIPT
![Page 1: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/1.jpg)
![Page 2: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/2.jpg)
![Page 3: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/3.jpg)
Lecture -1
![Page 4: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/4.jpg)
Introduction to Very basics Guides through Different design stages Familiarize with a tool Emphasis on Design stages of Databases
![Page 5: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/5.jpg)
![Page 6: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/6.jpg)
Assignment + Quizes = 10% Mid Term = 25% Terminal = 40% Practical = 25%
Passing Criteria = 50% (In each Terminal & Practical Exams)
![Page 7: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/7.jpg)
Database Definition
Comparison with the prior Data Processing approach
Pros & Cons of Databases
![Page 8: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/8.jpg)
What is a Database
![Page 9: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/9.jpg)
A database is a shared collection of logically related data that is stored to meet the requirements of different users of an organization
![Page 10: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/10.jpg)
A database is a self-describing collection of integrated records
![Page 11: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/11.jpg)
A database models a particular real world system in the computer in the form of data
![Page 12: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/12.jpg)
Accounting
AccountsPayable
Accounts Receivable
Management
ControlPlanning
Manufacturing
ProductionScheduling
Marketing
Product Development
Sales
CorporateDatabase
![Page 13: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/13.jpg)
Computer initially used for computational/ engineering purposes
Commercial applications introduced File Processing System
![Page 14: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/14.jpg)
A collection of programs that perform services for the end-users such as production of reports
![Page 15: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/15.jpg)
Program and Data Interdependence
RegistrationApplications
Registrat ionDataFiles
Registration
ExaminationApplications
ExaminationDataFiles
Examination
LibraryApplications
LibraryDataFiles
Library
![Page 16: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/16.jpg)
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
Duplication of Data
Vulnerable to Inconsistency
![Page 17: Database management systems lecture 01](https://reader034.vdocuments.us/reader034/viewer/2022042611/58ae82ba1a28abea4f8b64d5/html5/thumbnails/17.jpg)
Advantages of Database ApproachAdvantages of Database ApproachRegistrationExamination
LibraryApplications
Library
ExaminationApplications
RegistrationApplications
Database Management
System
University StudentsDatabase
- Data Sharing - Data Independence
- Controlled Redundancy - Better Data Integrity