Report on Uses of Data Base in Different Sectors by Managers
REPORT ON USES OF DATA BASE IN DIFFERENT SECTORS BY MANAGERS
SUBJECT- MANAGEMENT INFORMATION SYSTEM
SUBMITTED TO: DR. RICHA MISRA
SUBMITTED BY: SHUBHADIP BISWAS ROLL NO.-FT-10-948 SEC-A GDM 10-12 IILM-GSM
DATE OF SUBMISSION- 19/01/11
REPORT ON USES OF DATA BASE IN DIFFERENT SECTORS BY MANAGERS---
DATABASE:
A database is a collection of information organized to provide efficient retrieval.
DBMS is a central system which provides a common interface between the data and the various front-end programs in the application. It also provides a central location for the whole data in the application to reside.
Due to its centralized nature, the database system can overcome the disadvantages of the file-based system as discussed below.
• Minimal Data Redundancy
Since the whole data resides in one central database, the various programs in the application can access data in different data files. Hence data present in one file need not be duplicated in another. This reduces data redundancy. However, this does not mean all redundancy can be eliminated. There could be business or technical reasons for having some amount of redundancy. Any such redundancy should be carefully controlled and the DBMS should be aware of it.
• Data Consistency
Reduced data redundancy leads to better data consistency.
• Data Integration
Since related data is stored in one single database, enforcing data integrity is much easier. Moreover, the functions in the DBMS can be used to enforce the integrity rules with minimum programming in the application programs.
• Data Sharing
Related data can be shared across programs since the data is stored in a centralized manner. Even new
SUBJECT- MANAGEMENT INFORMATION SYSTEM
SUBMITTED TO: DR. RICHA MISRA
SUBMITTED BY: SHUBHADIP BISWAS ROLL NO.-FT-10-948 SEC-A GDM 10-12 IILM-GSM
DATE OF SUBMISSION- 19/01/11
REPORT ON USES OF DATA BASE IN DIFFERENT SECTORS BY MANAGERS---
DATABASE:
A database is a collection of information organized to provide efficient retrieval.
DBMS is a central system which provides a common interface between the data and the various front-end programs in the application. It also provides a central location for the whole data in the application to reside.
Due to its centralized nature, the database system can overcome the disadvantages of the file-based system as discussed below.
• Minimal Data Redundancy
Since the whole data resides in one central database, the various programs in the application can access data in different data files. Hence data present in one file need not be duplicated in another. This reduces data redundancy. However, this does not mean all redundancy can be eliminated. There could be business or technical reasons for having some amount of redundancy. Any such redundancy should be carefully controlled and the DBMS should be aware of it.
• Data Consistency
Reduced data redundancy leads to better data consistency.
• Data Integration
Since related data is stored in one single database, enforcing data integrity is much easier. Moreover, the functions in the DBMS can be used to enforce the integrity rules with minimum programming in the application programs.
• Data Sharing
Related data can be shared across programs since the data is stored in a centralized manner. Even new