Pet id Pet NamPETTypePet Age Owner Visit Date JAN 13/2002 MAR 27/2002 APR 02/200

Question

Pet id Pet NamPETTypePet Age Owner Visit Date 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 Procedure 01 RABIES VACCINATION 10 EXAMINE and TREAT 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 4 IweetyBIRD John 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. Be sure that your name and “Assignment 2" appear at the top of your submitted file.

Explanation / Answer

Assignment 2:

To make a table into 3NF, which can be dome in 3 steps

1NF:We have to remove duplicates by creating multiple tables, 2NF: We have to assign primary key for each table and

3NF: remove functional or column dependencies

To make the table you have given I created 3 different tables and one linked table to remove duplicates as below.

Each table has primary key with name as repayment_I'd, borrower_Id, person_Id for the repayment, borrower and person table respectively.

Repayment_borrower is the linked table to remove the functional dependencies in each table.

Repayment (repayment_id(pk), repayment date, repayment_amount)

Borrower (borrower_id(pk),loanamount,requestdate)

Person (person_Id(pk) name,address)

Repayment_Borrower (repayment_Id(fk), borrower_id(fk),person_id(fk))

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.