Write the relational schema for UNF, 1NF, 2NF and 3NF for this table.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
100%

Database System

Write the relational schema for UNF, 1NF, 2NF and 3NF for this table.

HEALTH HISTORY REPORT
PET ID
PET TYPE PET AGE OWNER
VISIT DATE
PROCEDURE
01 - RABIES VACCINATION
PET NAME
246
ROVER
DOG
12
SAM COOK
JAN 13/2002
MAR 27/2002
10 - EXAMINE and TREAT WOUND
APR 02/2002
05 - HEART WORM TEST
08 - TETANUS VACCINATION
05 - HEART WORM TEST
298
SPOT
DOG
TERRY KIM
JAN 21/2002
MAR 10/2002
01 - RABIES VACCINATION
01 - RABIES VACCINATION
341
MORRIS
CAT
4
SAM COOK
JAN 23/2001
JAN 13/2002
519
TWEEDY
BIRD
2
TERRY KIM
APR 30/2002
20 - ANNUAL CHECK UP
APR 30/2002
12 - EYE WASH
Transcribed Image Text:HEALTH HISTORY REPORT PET ID PET TYPE PET AGE OWNER VISIT DATE PROCEDURE 01 - RABIES VACCINATION PET NAME 246 ROVER DOG 12 SAM COOK JAN 13/2002 MAR 27/2002 10 - EXAMINE and TREAT WOUND APR 02/2002 05 - HEART WORM TEST 08 - TETANUS VACCINATION 05 - HEART WORM TEST 298 SPOT DOG TERRY KIM JAN 21/2002 MAR 10/2002 01 - RABIES VACCINATION 01 - RABIES VACCINATION 341 MORRIS CAT 4 SAM COOK JAN 23/2001 JAN 13/2002 519 TWEEDY BIRD 2 TERRY KIM APR 30/2002 20 - ANNUAL CHECK UP APR 30/2002 12 - EYE WASH
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Single Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education