Page 444 - Computer_Science_F5
P. 444
Traditional file approach creates
redundancy and over the time leads to
inconsistency comparing to database Master file Data
approach illustrated further bellow elements A-Z
Derivateve files Chapter Eight: Databases and Database Management Systems
FOR ONLINE READING ONLY
Accounting Application 1 A B C D
and Finance Users
Human Application 2 A B D E
Resources Users
Sales and
Marketing Application 3 A B E G
Users
Manufacturing Application 4
Users A B F G
Figure 8. 1(a): The traditional file approach
APP1 APP2
E.g., Benefits view E.g., Payroll view
In database, ''a system to create manipulate,
approach data is access databases (mediate access
stored centrally DBMS to the data )''
independent of
applications involved
thus avoids
redundancy/ E.g., HR Database
inconsistency ''a collection of
DB structure data''
Figure 8.1 (b): The database approach
Activity 8.1:
Exploring information storage systems at your school
Aim:
To explore and compare different storage methods—physical files, database
systems, and file-based systems—to understand their advantages and
disadvantages.
435
Student’s Book Form Five
Computer Science Form 5.indd 435 23/07/2024 12:34
