Consider the following traditional file system, which shows a number of index ca
ID: 3792473 • Letter: C
Question
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:
Separate files for each function A Single file of record
Student Administration Database The faculty Database
Student Address Main Ave St.Georges
Subject Passed MGMT2 MGMT2006
Subject enrolled MGMT3011
MGMT2305
Subjects Passed MGMT1000
MGMT1001
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.
Student ID 2345324 Student ID 2345324Student Address Main Ave St.Georges
Student Address Main AveSubject Passed MGMT2 MGMT2006
Subject enrolled MGMT3011
MGMT2305
Fes Paid $32.50Subjects Passed MGMT1000
MGMT1001
Explanation / Answer
Discrepancies: The address is not complete in the faculty database. It also doesnt have the complete list of subjects enrolled in.
Problems which may arise: If the faculty wants to know about the list of courses enrolled by the student, it wont have a valid information. It will have inconsistent data.