What is Data,
What is Database,
What is DBMS,
DBMS applications,
Advantages of DBMS,
Disadvantages of File System
Need of DBMS
Data:
It is a collection of information.
Example:
Customer
- cname.
- cno.
- city.
Database:
- It is a collection of interrelated data.
- These can be stored in the form of tables.
- A database can be of any size and varying complexity.
- A database may be generated and manipulated manually or it may be computerized.
Example:
Customer database consists the fields as cname, cno, and ccity
|
Cname |
Cno |
Ccity |
|
|
|
|
Database System:
It is computerized system, whose overall purpose is to maintain the information and to make that the information is available on demand.
DBMS Advantages:
1.Redundency can be reduced.
2.Inconsistency can be avoided.
3.Data can be shared.
4.Standards can be enforced.
5.Security restrictions can be applied.
6.Integrity can be maintained.
7.Data gathering can be possible.
8.Requirements can be balanced.
Database Management System (DBMS):
It is a collection of programs that enables user to create and maintain a database. In other words it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applications.
Disadvantages in File Processing
Data redundancy and inconsistency.
Difficult in accessing data.
Data isolation.
Data integrity.
Concurrent access is not possible.
Security Problems.
.
Advantages of DBMS:
1.Data Independence.
2.Efficient Data Access.
3.Data Integrity and security.
4.Data administration.
5.Concurrent access and Crash recovery.
6.Reduced Application Development Time.
Applications of DBMS
- Database Applications:
- Banking: all transactions
- Airlines: reservations, schedules
- Universities: registration, grades
- Sales: customers, products, purchases
- Online retailers: order tracking, customized recommendations
- Manufacturing: production, inventory, orders, supply chain Human resources: employee records, salaries, tax deductions
0 Comments