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 Era 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 advice on reprisals of loans. Reprisals(borrower id, indicate, discourse, loanamount, requestdate, reprisals era, repavment sum Make the normalization to 3rd Normal Form. Show your production.

    The subjoined schema is used to record advice on reprisals of loans. Reprisals(borrower_id, indicate, discourse, loanamount, requestdate, reprisals_date, reprisals_amount) Make the normalization to 3^rd Normal Form. Show your production.

    Expert Solution

     

    • In the Reprisals schema, we attend indicate and discourse are contingent on borrower_id ,repayment_sum is contingent on loansum and reprisals_era is contingent on requestdate. For the overhead schema, the principal clew conquer be league of (borrower_id,loansum and requestdate).
    • We can attend divers inequitable dependency exists. So the overhead schema should be domesticated down into the adown tables:
    • Borrower(borrower_id,name,address)
    • Date(requestdate,repayment_date)
    • Amount(loanamount, reprisals_amount)
    • Loan(borrower_id,requestdate,loanamount)