Q.2. Suppose, for a Salat management system, you have the following information: (10 marks)

Person Name, Gender , Age, Date, Time, Prayed Rakats, Ontime/Offtime, Time to pray

a. Identify the associated updation/deletion anomalies if the data is stored as it is in a single table

b. Identify functional dependences/ transitive dependencies that can be used to normalize

c. Normalize the database into constituent tables