Download to read offline
1 DATABASE MANAGEMENT SYSTEMS INTRODUCTION.pdf
- 1.
- 2.
- 3. Terms • Database (DB) –base for Data • Database Management System (DBMS) – Software Tool to manage Database(s) • Meta – Data – Data about the containers those hold the actual data • (User) Application – Program that is used by the users to access a database • SQL (Structures Query Language) – Language that is used to communication with the DBMS (like a programming language) • Query – Statement that follows the SQL rules (like a program in programming language concept)
- 4. What is Database •an integrated collection of digital data in a form that can be stored and processed by a computer. • an integrated collection of data in a form capable of, and for the purpose of, being stored in, processed, and operated on by a computer
- 5. Database Management System •Database management System (DBMS) is a software that serves users and applications, and uses data on the database as required; DBMS acts like an interface among them. • DBMS allows various operations like database creation, storing data in it, updating data, creating a table in the database etc. • It provides protection and security to the database • In the case of multiple users, it also maintains data consistency
- 6. • Data Definition:It is used for creation, modification, and removal of definition that defines the organization of data in the database. • Data Updating: It is used for the Creation, Update, Deletion of the data in the database. • Data Retrieval: It is also used to Retrieve the data from the database • Security including User Administration: It is used for registering and monitoring users, maintain data integrity, enforcing data security, dealing with concurrency control, monitoring performance and recovering information corrupted by unexpected failure. DBMS enables users to do:
- 7. Actors • System (Requirements)Analyst – Performs steps to collect requirements • DataBase Administrator – Database Expert to manage Database System • Database Designer (Architect) – Performs Database Design Steps • System Designer, Application Programmer – Prepares the application to access the database
- 8. Example: University Database •Tables to hold the data: – STUDENT – COURSE – INSTRUCTOR – ENROLLMENT • Meta Data about the Tables: – Column Name – Data Type of each Column – Size of each Column
- 9. How the DBMSis accessed
- 10. Database Design Steps •Requirement Analysis • Conceptual Design • Logical Design • Physical Design
- 11.
- 12.