DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
It causes sync with all the data synchronization
|
|
|
It causes data redundancy
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The data is not very secure in a file based system and may be corrupted or destroyed. The data files in the file based system may be stored across multiple locations. Consequently, it is difficult to share the data easily with multiple users.
Detailed explanation-2: -What is data redundancy, and which characteristics of the file system can lead to it? Data redundancy occurs when the same data are stored in multiple places unnecessarily. The use of spreadsheets and tables in different parts of the organization can cause it.
Detailed explanation-3: -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-4: -Redundancy causes higher storage. This situation can also result in data inconsistency. Inconsistency means that two files may contain different data of the same student. For example, if the address of astudent is changed, it must be changed in both fles.
Detailed explanation-5: -Disadvantages of the file-based approach. Data redundancy. Data isolation. Integrity problems. Security problems.