Page 152 - DMGT505_MANAGEMENT_INFORMATION_SYSTEM

Unit 8: Databases and Data Warehouses

 Acts as interface between application programs and physical data files Notes
 Separates logical and physical views of data

Advantages of Database Approach

 All the managers can view database as per their needs.
 Data validation and updation will be once and same for all.
 All the users share data.
 Security and privacy can be managed.
 Control of data redundancy.
 Data consistency.

 More information from the same amount of data.
 Sharing of data.
 Improved data integrity.
 Improved security.
 Enforcement of standards.
 Economy of scale.
 Balance of confliction requirements.

 Improved data accessibility and responsiveness.
 Increased productivity.
 Improved maintenance through data independence.
 Increased concurrency.
 Improved backup and recovery services.

Figure 8.2: Database Approach

Student Financial
Administration Management

Data
Base

Course Faculty
Administration Administration

Self Assessment

Fill in the blanks:
3. .................................. occurs because the same data items which appear in more than one file
do not get updated simultaneously in all the data files.

LOVELY PROFESSIONAL UNIVERSITY 147