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 Spectry PET Type Pet Age Owner Visit End 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 register knowledge on requital of loans. Requital(mortgagor id, spectry, discourse, loanamount, requestdate, requital end, repavment sum Make the normalization to 3rd Normal Form. Show your employment.

    The subjoined schema is used to register knowledge on requital of loans. Requital(borrower_id, spectry, discourse, loanamount, requestdate, requital_date, requital_amount) Make the normalization to 3^rd Normal Form. Show your employment.

    Expert Exculpation

     

    • In the Requital schema, we attend spectry and discourse are relative on mortgagor_id ,repayment_sum is relative on loansum and requital_end is relative on requestdate. For the over schema, the primitive explanation conciliate be synthesis of (borrower_id,loansum and requestdate).
    • We can attend divers restricted dependency exists. So the over schema should be meek down into the underneath tables:
    • Borrower(borrower_id,name,address)
    • Date(requestdate,repayment_date)
    • Amount(loanamount, requital_amount)
    • Loan(borrower_id,requestdate,loanamount)