Database - this article introduction the concept of database management system (DBMS) and its architecture, the concept of Relational Database Management System, and relational model terminology. this article also discusses the design and planning issues considered for designing a database and basic of structured Query Language.
The availability of Database management software enables easy creation of databases and database applications. However, creation without design usually leads to various database problem, disasters, and complete failures. Therefore, good knowledge of database design in both theoretical and practical aspects is essential.
A database is a collection of records. One of the major task in a computer system is to store and manage data. to handle this task, you need a specialized computer software known as a Database Management System (DBMS). DBMS are designed to maintain large volume of data. management of data involved :
1. Defining structure for data storage
2. Providing data security against unauthorized access
3. Providing mechanisms for data manipulation
Users
A DBMS user can perform the following activities on a database :
1. Add file.
2. Insert data.
3. Retrieve data.
4. Update data.
5. Delete data.
6. Remove the existing files from database.
7. Enforce security and integrity rules.
3 types of DBMS users:
1. The application programmers : write application programs that help an end user to use the database.
2. End Users :interact with a DBMS either by invoking an application program or by writing queries in a database query language.
3. Database Administrator (DBA) : coordinate the function of collecting information about the data to be stored, and designing and maintaining the database and its security.
The availability of Database management software enables easy creation of databases and database applications. However, creation without design usually leads to various database problem, disasters, and complete failures. Therefore, good knowledge of database design in both theoretical and practical aspects is essential.
 |
A database is a collection of records. One of the major task in a computer system is to store and manage data. to handle this task, you need a specialized computer software known as a Database Management System (DBMS). DBMS are designed to maintain large volume of data. management of data involved :
1. Defining structure for data storage
2. Providing data security against unauthorized access
3. Providing mechanisms for data manipulation
Users
A DBMS user can perform the following activities on a database :
1. Add file.
2. Insert data.
3. Retrieve data.
4. Update data.
5. Delete data.
6. Remove the existing files from database.
7. Enforce security and integrity rules.
3 types of DBMS users:
1. The application programmers : write application programs that help an end user to use the database.
2. End Users :interact with a DBMS either by invoking an application program or by writing queries in a database query language.
3. Database Administrator (DBA) : coordinate the function of collecting information about the data to be stored, and designing and maintaining the database and its security.
0 Response to "Introduction to Database Management System ( RDBMS ) "
Post a Comment
Note: Only a member of this blog may post a comment.