Page 63 - CITS - Computer Software Application -TT
P. 63
COMPUTER SOFTWARE APPLICATION - CITS
MODULE 2 : Database Concepts
LESSON 18 - 36 : Database concepts
Objectives
At the end of this lesson, you will be able to:
• understand basic concepts & applications of datebase system
• create & mange database file using MYSQL
• handle, store and organise facilitating information access and analysis.
Concept of DBMS, RDBMS
What is Database?
A database is a compilation of interconnected data that enables efficient operations such as data retrieval,
insertion, and deletion.
It serves as a means to systematically arrange information, often in the format of tables, schemas, views, and
reports.
For instance, consider a college database. This database arranges information concerning administrators, staff
members, students, and faculty in a coherent manner. By utilizing this database, you can seamlessly retrieve,
add, and remove information as needed.
Concept of DBMS and RDBMS
Database Management System
A Database Management System (DBMS) is software designed for the administration of databases. Widely
used commercial databases like MySQL and Oracle serve various applications. The DBMS offers an interface to
execute diverse tasks, such as crafting databases, storing data, data updates, and table creation.
This system ensures database security and protection, along with maintaining data consistency when multiple
users are involved.
The DBMS empowers users to undertake the following tasks:
1 Database Creation: DBMS enables the creation of new databases to organize and store data efficiently.
2 Data Storage: It provides a platform for storing a wide range of data types, ensuring data integrity and
accessibility.
3 Data Retrieval: Users can effortlessly retrieve specific information from the database using queries and
search operations.
4 Data Update and Modification: DBMS facilitates the modification and updating of existing data, ensuring
accuracy and relevance.
5 Table Creation: Users can define and create tables with specific structures to store data in a structured
manner.
6 Data Integrity: It enforces rules and constraints to maintain the integrity and consistency of the data.
7 Data Security:** DBMS offers security features to control access to the data, protecting it from unauthorized
users.
8 Data Backup and Recovery: Users can perform data backups regularly and recover data in case of system
failures or errors.
9 Indexing: DBMS allows the creation of indexes, enhancing data retrieval performance.
10 Query Optimization: It optimizes queries to improve the efficiency of data retrieval operations.
50