Database Management System
4th semester
Unit :-1. DBMS
DATA:- data is any known facts or any smallest information that can be recorded and have implishit meaning.
Ex:- Polytechnic, Gautam,e.t.c.
Database:- Database is a collection of interrelated data stored together to serve multiple applications.
:- database can mainted manually or through electronic devices such as mobile phone, computer etc
Database management system:- dbms is a software.it is a collection of program.it is a collection of interrelated data.set of program to access those data.
Purpose of DBMS
It is a system in which any user uses the database technology in order to achieve and organised store a large number of dynamic, associated data with the help of hardware and software operating system and manipulate data at a time.
Characteristics of DBMS
1. Real world entity
2. Relation based table
3. Query language
4. Security
5. Multiple view
6. Multiuser and concurrent access
7. Consistency
8. Less redundancy
9. Isolation of data and application
10. Acid properties
Advantage of DBMS
1. Data abstraction
2. Data can be stored
3. Data manipulation easily
4. Data security
5. Controlling data redundancy
6. Minimise data in consistency
Disadvantages of DBMS
1. Coast of hardware and software
2. Coast of data conversion
3. Coast of staff training
[ Unit 1 complete ]
Gautam Kumar
4th semester
Unit :-1. DBMS
DATA:- data is any known facts or any smallest information that can be recorded and have implishit meaning.
Ex:- Polytechnic, Gautam,e.t.c.
Database:- Database is a collection of interrelated data stored together to serve multiple applications.
:- database can mainted manually or through electronic devices such as mobile phone, computer etc
Database management system:- dbms is a software.it is a collection of program.it is a collection of interrelated data.set of program to access those data.
Purpose of DBMS
It is a system in which any user uses the database technology in order to achieve and organised store a large number of dynamic, associated data with the help of hardware and software operating system and manipulate data at a time.
Characteristics of DBMS
1. Real world entity
2. Relation based table
3. Query language
4. Security
5. Multiple view
6. Multiuser and concurrent access
7. Consistency
8. Less redundancy
9. Isolation of data and application
10. Acid properties
Advantage of DBMS
1. Data abstraction
2. Data can be stored
3. Data manipulation easily
4. Data security
5. Controlling data redundancy
6. Minimise data in consistency
Disadvantages of DBMS
1. Coast of hardware and software
2. Coast of data conversion
3. Coast of staff training
Gautam Kumar
Tags:
DBMS