Question

2) InstallmentPayment (Subclass) Sample data: Numbers of installment ApplicationID DaysInstalment DaysEntryPayment AMTofinstallment AMTofPayment 1570206 20 -761 -761 21.51 21.51 2723183 14 -197 -197 70.74 70.74 1003606 105 -174 -174 110.655 110.655 2778384 57 -1823 -1823 249.03 249.03 Key: ApplicationID FD1: INF: 2NF: 3NF:

Can you do normalization, 1NF, 2NF, and 3NF?

Thank you.

Answer 1

FD1: no. of installmenty and of payment INF: Repetition of Columns are not allowed only atomic values ghould Present sayslast calment & Days Entry payment Containe same contene. AMTOA Installment SAM DA paymes have same contento so one should presen Appuy el momento mene says laskdanell Alloh payment is tuto AD 20 -761 2723183 2.5 14 297 I 70174 -174 110.655 249.03 no 0 Must be an Inf INF: Dron prime attribute is dependent on the 1. Proper subset of any candidate key. Hene Chi SAPPED, dassion is talment} non prime attribute : game of payment so here and of payment depends on both - appl ID & day of installments 1.

To make the table on ons, en otoblog 3N1 N Must be in INF ② Transitive functional dependency of non-Prime attribute on any suponkey should be removed superkeys: Sapp?ID} {apple In, no on mene) . {apies, days of payment {all I to gether).... ck= sapphed} non prime attribute, all attributes encept appel od one non-prime tene paymentant is dependent on installment & no. of installment is dependent on -7 appin id. so INF is "IM í APPE ID I no. of days of rental Tin Hallment payment |