Normalisation
Step1 Remore calculated field For ex DOB t keep
I Age remove
IF there is repeatingfield choose 1 of them only
for EI Date borrowed I can be used to calculate the other
Due date Ble Fixed period is 14days
I
any of them but I only
Choose
Step 2 look for primary keys identify no of tables needed
Step3 look for attributes belong to each Pk
I
Identify attributes does not Fit any PK
might belong to a middle table
Steps tool for relationship between each table
f
Ex For Uni students c Starting with the keyelement table who receive the
i
fit patientmers
table that is essential to the business
is answer the where to put Fll question
g yy.yyy.my
Step1 Remore calculated field For ex DOB t keep
I Age remove
IF there is repeatingfield choose 1 of them only
for EI Date borrowed I can be used to calculate the other
Due date Ble Fixed period is 14days
I
any of them but I only
Choose
Step 2 look for primary keys identify no of tables needed
Step3 look for attributes belong to each Pk
I
Identify attributes does not Fit any PK
might belong to a middle table
Steps tool for relationship between each table
f
Ex For Uni students c Starting with the keyelement table who receive the
i
fit patientmers
table that is essential to the business
is answer the where to put Fll question
g yy.yyy.my
