due in like 3 hrs please

Note: in all the below exercises you need to show only the structure of the BNCF: tables (not actual rows) Exercise 1 (6 points): Assume you have the following relation: Exercise 2 ( 6 points):: Assume you have the following report in a file format. HEALTH HISTORY REPORT PET ID PET NAME PETTYPE PETAGE OWNER VISIT DATE PROCEDURE 246 ROVER DOG 12 SAM COOK JAN 13/2002 01-RABIES VACCINATION Find the below: MAR 27/2002 10 - EXAMINE and TREAT WOUND APR 02/2002 05 - HEART WORM TEST 1NF: 298 SPOT DOG 2 TERRY KIM JAN 21/2002 08 -TETANUS VACCINATION MAR 10/2002 05 - HEART WORM TEST 2NF: 341 MORRIS CAT 4 SAM COOK JAN 23/2001 01-RABIES VACCINATION JAN 13/2002 01 - RABIES VACCINATION 519 TWEEDY BIRD 2 TERRY KIM APR 30/2002 20-ANNUAL CHECK UP APR 30/2002 12-EYE WASH 3NF: Assume you were asked to convert the file into relational database format. HILLTOP ANIMAL HOSPITAL DATE: JAN 13/2002 From your design, what would be your tables Find the below: INVOICE \# 987 1NF: MR. RICHARD COOK 123 THIS STREET myCity, myState 4zip 2NF: 3NF: BNCF: Exercise 3 ( 8 points):; Assume you were asked to convert those paper invoices into relational database. How many tables will you create? What are the columns in each table? Show each of: Assume you have a series of paper invoices that follow this format: 1NF: INVOICE 2NF : 3NF: BCNF: Submission: Upload your work on ECN by due date