INF2603 ASSIGNMENT 2 SOLUTIONS 2021 SEMESTER 1 AND 2
Question 1.
a)
Data redundancy exists when the same data is stored unnecessarily at different places.
Data-entry errors. Data-entry errors are more likely to occur when complex entries (such
as 10-digit phone numbers) are made in several different files or recur frequently in one
or more files.
Data integrity problems. It is possible to enter a nonexistent sales agent’s name and
phone number into the CUSTOMER file, but customers are not likely to be impressed if
the insurance agency supplies the name and phone number of an agent who does not
exist.
Poor data security - Having multiple copies of data increases the chances for a copy of
the data to be susceptible to unauthorized access.
Data inconsistency - Data inconsistency exists when different and conflicting versions of
the same data appear in different places.
Question 1.
a)
Data redundancy exists when the same data is stored unnecessarily at different places.
Data-entry errors. Data-entry errors are more likely to occur when complex entries (such
as 10-digit phone numbers) are made in several different files or recur frequently in one
or more files.
Data integrity problems. It is possible to enter a nonexistent sales agent’s name and
phone number into the CUSTOMER file, but customers are not likely to be impressed if
the insurance agency supplies the name and phone number of an agent who does not
exist.
Poor data security - Having multiple copies of data increases the chances for a copy of
the data to be susceptible to unauthorized access.
Data inconsistency - Data inconsistency exists when different and conflicting versions of
the same data appear in different places.
