With the following information format the data into 1st, 2nd, and 3rd normal form. Case ID Test Date Result Date Test Result Days Waited for Results Patient ID Patient Name Patient Address Patient City Centre ID Centre Name Test Type ID Test Description Test Cost Total Testing Cost Case Comments 563 2020-03-21 2020-03-24 Negative 3 723 Rory Green 555 Mewt Ave Lorette 101 Downtown 1 Throat Swab 24 24   2001 2020-04-30 2020-05-01 Negative 1 500 Tiffany Cleas 499 Smith Road Winnipeg 202 South 1 Throat Swab 25 25   3668 2020-05-19 2020-05-22 Negative 3 899 Mimi Parks 123 Night St Winnipeg 202 South 1

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
100%

With the following information format the data into 1st, 2nd, and 3rd normal form.

Case ID Test Date Result Date Test Result Days Waited for Results Patient ID Patient Name Patient Address Patient City Centre ID Centre Name Test Type ID Test Description Test Cost Total Testing Cost Case Comments
563 2020-03-21 2020-03-24 Negative 3 723 Rory Green 555 Mewt Ave Lorette 101 Downtown 1 Throat Swab 24 24  
2001 2020-04-30 2020-05-01 Negative 1 500 Tiffany Cleas 499 Smith Road Winnipeg 202 South 1 Throat Swab 25 25  
3668 2020-05-19 2020-05-22 Negative 3 899 Mimi Parks 123 Night St Winnipeg 202 South 1 Throat Swab 25 25  
4856 2020-06-07 2020-06-13 Positive 6 411 Branon Skies 11 Mandalay Ave Winnipeg 101 Downtown 1
2
Throat Swab
Blood Sample
25
50
75 Unable to perform swab after several attempts.
5563 2020-06-07 2020-06-11 Negative 4 153 Francisco Manuel 74 Powers Bay Winnipeg 202 South 1 Throat Swab 26 26  
8562 2020-08-15 2020-08-29 Positive 14 723 Rory Green 555 Mewt Ave Lorette 303 North End 1
2
3
Throat Swab
Blood Sample
Stool Sample
27
55
80
162 Patient demanded multiple tests be performed.
Expert Solution
steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY