Homework Solution: The following schema is used to register information on repayment of loans. Repayment(borrower_id, name, address, loanamou…

    Pet id Pet Name PET Type Pet Age Owner Visit Date Procedure 01 RABIES VACCINATION 10 EXAMINE and TREAT JAN 13/2002 MAR 27/2002 APR 02/2002 JAN 21/2002 MAR 10/2002 JAN 23/2001 JAN 13/2002 APR 30/2002 APR 30/2002 Brown DOG 12 Sam WOUND 05 HEART WORM TEST Tucker DOG John 08 TETANUS VACCINATION 05 HEART WORM TEST Maggie CAT 4 Sam 01 RABIES VACCINATION 01 RABIES VACCINATION Tweety BIRD 2 John 4 20 ANNUAL CHECK UP 12 - EYE WASH 3. The following schema is used to register information on repayment of loans. Repayment(borrower id, name, address, loanamount, requestdate, repayment date, repavment amount Make the normalization to 3rd Normal Form. Show your work.
    The following schema is used to register information on repayment of loans. Repayment(borrower_id, name, address, loanamount, requestdate, repayment_date, repayment_amount) Make the normalization to 3^rd Normal Form. Show your work.

    Expert Answer

     
    • In the Repayment schema, we see name and address are depende

    Pet id Pet Designate PET Type Pet Age Owner Visit Bound Procedure 01 RABIES VACCINATION 10 EXAMINE and TREAT JAN 13/2002 MAR 27/2002 APR 02/2002 JAN 21/2002 MAR 10/2002 JAN 23/2001 JAN 13/2002 APR 30/2002 APR 30/2002 Brown DOG 12 Sam WOUND 05 HEART WORM TEST Tucker DOG John 08 TETANUS VACCINATION 05 HEART WORM TEST Maggie CAT 4 Sam 01 RABIES VACCINATION 01 RABIES VACCINATION Tweety BIRD 2 John 4 20 ANNUAL CHECK UP 12 - EYE WASH 3. The subjoined schema is used to record notification on reciprocation of loans. Reciprocation(borrower id, designate, discourse, loanamount, requestdate, reciprocation bound, repavment sum Make the normalization to 3rd Normal Form. Show your composition.

    The subjoined schema is used to record notification on reciprocation of loans. Reciprocation(borrower_id, designate, discourse, loanamount, requestdate, reciprocation_date, reciprocation_amount) Make the normalization to 3^rd Normal Form. Show your composition.

    Expert Retort

     

    • In the Reciprocation schema, we conceive designate and discourse are relative on borrower_id ,repayment_sum is relative on loansum and reciprocation_bound is relative on requestdate. For the aloft schema, the important clew obtain be co-operation of (borrower_id,loansum and requestdate).
    • We can conceive diverse restricted dependency exists. So the aloft schema should be mild down into the underneath tables:
    • Borrower(borrower_id,name,address)
    • Date(requestdate,repayment_date)
    • Amount(loanamount, reciprocation_amount)
    • Loan(borrower_id,requestdate,loanamount)