Questions 1 & 2:
1. List AT LEAST three (3) disadvantages of the typical file processing system AND three (3) intended advantages of the DBMS approach (NOTE: the advantages DBMS approach should NOT simply be the opposite of the disadvantages of the file processing approach).
2. For the sake of fairness,
list AT LEAST one (1) disadvantage of the DBMS approach and one (1) advantage
of the file processing system. Again, the disadvantage of the DBMS approach
should NOT simply be the opposite of the advantage of the file processing
approach.
|
File Advantages |
File Disadvantages |
DBMS Advantages |
DBMS Disadv. |
|
Effectiveness |
Single Application |
Multiple Applications |
Complicated Code |
|
Fast Processing |
Prob. W/file Mgt. |
Data Consolidation |
Slower Execution |
|
Simple Coding |
Structural Dependence |
Minimal Duplication |
Efficiency |
|
User Ownership |
File Dependence |
Data Sharing |
Increase Code Store. |
|
|
Data Inconsistency |
Data Integrity |
DBA needed |
|
|
Data Redundancy |
Relational Integrity |
|
|
|
Increased Data Storage |
Data Security |
|
|
|
Inconsist. Data types |
Data Standards |
|
|
|
Lack of Standardization |
Easy maintenance |
|
|
|
Lack of Sharing |
Quicker Development |
|
|
|
Lack of user Involvement |
Cost Savings |
|
|
|
Lengthy Dev. Times |
Faster User Develop. |
|