DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Lengthy development times
|
|
|
Complex system administration
|
|
|
Lack of security and limited data sharing
|
|
|
Difficulty of getting quick answers
|
|
|
Extensive programming
|
Detailed explanation-1: -Problems resulting from the traditional file environment include: Data redundancy: duplicate data in multiple files, leading to data inconsistency, different values used for the same attribute. Program-data dependency: Changes in programs requiring changes to the data. Lack of flexibility.
Detailed explanation-2: -File systems require extensive programming in a third-generation language (3GL). As the number of files expands, system administration becomes difficult. Making changes in existing file structures is important and difficult. Security features to safeguard data are difficult to program and usually omitted.
Detailed explanation-3: -The resulting problems are data redundancy and inconsistency, program-data dependence, inflexibility, poor data security, and an inability to share data among applications.
Detailed explanation-4: -File management system is having data redundancy, data dependency and inconsistency problems.