Answer to Question #158413 in Databases | SQL | Oracle | MS Access for Syed Mohammad Moize

Question

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   

Answer 1

a)
    time, prayed rakats , Ontime/offtime, time to pray
    all these come under updation/deletion anomaly
    B'coz other times depends on them also we need to update Prayed rakats and time to pray together.

b)
    prayed rakats, time to pray functionally dependent(if prayed rakat is that when we 
    had prayed)Time 
    time to pray, ontime/offtime transitively dependent

c)
    normalized form will look like
    table1 -> Person name, gender, age, date , time
    table2 -> Person name, prayed rakats
    table3 -> Person name ,on-time/offtime
    table4 -> Person name,  time to pray