A single file of records. Se parate files for each function. Student The Administration Faculty Database Database Student ID Student Name Student ID 2345324 Jane Blue 2345324 Student Name Jane Blue...

Activity 1

Task A:

Consider the following traditional file system, which shows a number of index cards stored in two separate databases (and possibly in two different locations/ departments). Student information for Jane Blue is shown below:

Compare the data found in each index card. State any discrepancies which may be found and explain what problems can occur because of the discrepancy.

See index card below

Extracted text: A single file of records. Se parate files for each function. Student The Administration Faculty Database Database Student ID Student Name Student ID 2345324 Jane Blue 2345324 Student Name Jane Blue Student Address Main Ave st. Georges Subjects Passed MGMT2005 MGMT2006 $32.50 Student Address Main Ave Subjects Enrolled MGMT3011 MGMT23 05 Fees paid Subjects Passed MGMT 1000 MGMT1001