Relational Schema Notation Examples: EMPLOYEE(EMP NUM, EMP_NAME, EMP_DEP1T) DEPARTMENTDEPT NUM, DEPT_NAME, MGR_EMPNUM) CLASS CR CO M) . COURSE(CRS CODE. DEPTNUM. CRSDESCR, CRS. CREDIT) DECLASS SECTION TIME,PREMEMNUNU - - Note: These examples do not necessarily correspond to an ERD from the book or other class material Part 1: Given the following reports you are to design the relational schema that could be used to create the reports shown. The tables must be 3NF. Write them out using our extended relational schema notation from the course supplemental notes. Yes, in some cases, you do not have all the information needed, so you will need to use your skills to analyze the reports and come up with a solution. This may require making assumptions and educated guesses. HEALTH HISTORY REPORT PET ID PET NAME 246 ROVER PET TYPE PET AGE OWNER DOG VISIT DATE SAM COOKJAN 13/2002 MAR 27/2002 APR 02/2002 12 01- RABIES VACCINATION 10-EXAMINE and TREAT WOUND 05- HEART WORM TEST Create a list of assumptions and explanations that led you to your solution: SPOT DOG TERRY KIM JAN 21/2002 MAR 10/2002 08-TETANUS VACCINATION 05-HEART WORM TEST 298 Relational Schema: CAT SAM COOK JAN 23/2001 JAN 13/2002 01-RABIES VACCINATION 01-RABIES VACCINATION 341 MORRIS Submit: 519 TWEEDY BIRD TERRY KIM APR 30/2002 APR 30/2002 20- ANNUAL CHECK UP 12 EYE WASH This document with your name at the top and your solutions INVOICE HILLTOP ANIMAL HOSPITAL INVOICE 987 DATE: JAN 13/2002 MR. RICHARD COOK 123 THIS STREET MY CITY, ONTARIO 25Z 6G6 PET AMOUNT ROVER MORRIS RABIES VACCINATION RABIES VACCINATION 30.00 24.00 TOTAL TAX 48%) 54.00 4.32 AMOUNT OWING 58.32