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 Indicate PET Type Pet Age Owner Visit Duration 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 knowledge on requital of loans. Requital(borrower id, indicate, harangue, loanamount, requestdate, requital duration, repavment whole Make the normalization to 3rd Normal Form. Show your fruit.

    The subjoined schema is used to record knowledge on requital of loans. Requital(borrower_id, indicate, harangue, loanamount, requestdate, requital_date, requital_amount) Make the normalization to 3^rd Normal Form. Show your fruit.

    Expert Response

     

    • In the Requital schema, we attend indicate and harangue are relative on borrower_id ,repayment_whole is relative on loanwhole and requital_duration is relative on requestdate. For the over schema, the original solution gain be co-operation of (borrower_id,loanwhole and requestdate).
    • We can attend sundry unfair dependency exists. So the over schema should be subjugated down into the underneath tables:
    • Borrower(borrower_id,name,address)
    • Date(requestdate,repayment_date)
    • Amount(loanamount, requital_amount)
    • Loan(borrower_id,requestdate,loanamount)