QUESTION 2 a) Damai College is a private institution that runs academic operation. Recently, the number of students and staffs are increasing in the college, thus, it has led to data redundancy. You...

QUESTION 2


a)    Damai College is a private institution that runs academic operation. Recently, the number of students and staffs are increasing in the college, thus, it has led to data redundancy. You have been hired as a database designer for the college. In your opinion, how can normalization process help to manage data redundancies?

b) TechTwentyOne Sdn. Bhd. has been appointed by Ayana Clinic to develop a software for their clinic. The software automates activities such as patient care, patient history, scheduling, billing, claims processing and other related operations for medical practices. However, the data and information between the doctors and patients are confidential and must be protected. As a developer, how do you ensure the data is protected?