DATA BASE MANAGEMENT SYSTEM (DBMS)
1 like163 views
This document provides an introduction to database management systems (DBMS). It discusses how a DBMS is used to create, store, organize and retrieve data from one or multiple databases. A DBMS includes four key components: users, database applications, the DBMS software, and the database itself. The DBMS software communicates with the database to perform functions like creating and modifying database structures and data. It also provides security, concurrency control and backup/recovery. Organizational DBMS are typically more complex, supporting multiple users, applications, computers, databases and tables simultaneously.
More Related Content
Similar to DATA BASE MANAGEMENT SYSTEM (DBMS) (20)
Recently uploaded (20)
DATA BASE MANAGEMENT SYSTEM (DBMS)
- 2. Intro to DBMS Data is a vital part of any organization. It needs to be stored, organized, managed, accessed, protected and manipulated. Operational Use databases to: Create a book Track book sales Set salaries and wages Pay employees
- 3. The purpose of a database is to keep track of things Unlike a list or spreadsheet, a database may store information that is more complicated than a simple list Intro to DBMS Purpose of DBMS
- 4. The Database Approach: Foundational Concepts DBMS Database Management Systems Use a DBMS software to create, store, organize, and retrieve data from a single database or several databases Example: Microsoft Access Intro to DBMS Database Management for Strategic Advantage
- 5. Advantages of the Database Approach Program-data independence Minimal data redundancy Improved data consistency Improved data sharing Increased productivity of application development Enforcement of standards Improved data quality Improved data accessibility Reduced program maintenance Intro to DBMS Database Management for Strategic Advantage
- 8. Intro to DBMS Database Systems The four components of a database system are: Users Database Application Database Management System (DBMS) Database
- 9. Intro to DBMS Database Systems
- 10. A user of a database system will Use a database application to track things Use forms to enter, read, delete and query data Produce reports Intro to DBMS Database Systems - Users
- 11. Intro to DBMS Database Systems Database Application A set of one or more computer programs that serves as an intermediary between the users and the DBMS Application program that read or modify database data by sending SQL statements to DBMS. Application program to present data to users in the format of forms and reports.
- 12. Database Systems Database Application : Functions Create and process forms Process user queries Create and process reports Execute application logic Control database applications Intro to DBMS
- 13. Intro to DBMS Database Systems DBMS A computer program used to create, process and administer the database DBMS receives request encoded in SQL and translates these requests into actions on the database DBMS is a large, complicated program that is licensed software. Almost majority of the companies never write their own DBMS program.
- 14. Intro to DBMS Database Systems Database The database is a collection of related tables and other structures. A database is a self-describing collection of related records
- 15. Create databases Create tables Create supporting structures Read database data Modify database data (insert, update, delete) Maintain database structures Enforce rules Control concurrency Provide security Perform backup and recovery Intro to DBMS Functions of DBMS
- 16. Organizational database systems typically: Support several users simultaneously Include more than one application Involve multiple computers Are complex in design Have many tables Have many databases Intro to DBMS Organizational DBMS