Do a normalization from 1NF to 3NF based on the table below

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

Do a normalization from 1NF to 3NF based on the table below

Table 1: Vaccine Records by State
Date
Vaccine
Total"
State
Johor
Dose 1*
2055
3048
Dose 2"
1098
2002
12/6/2021
Pfizer
Sinovac
3153
5050
AstraZeneca
5278
330
704
4356
9634
Melaka
Pfizer
Sinovac
AstraZeneca
95
425
205
909
203
1264
3609
4110
1034
13/6/2021
Johor
Pfizer
2600
1009
Sinovac
3090
1020
1500
AstraZeneca
7004
8504
Melaka
Pfizer
303
200
503
375
876
1511
Sinovac
501
AstraZeneca
806
705
*Numbers come from citizen record consist of name, identification number, handphone number.
Transcribed Image Text:Table 1: Vaccine Records by State Date Vaccine Total" State Johor Dose 1* 2055 3048 Dose 2" 1098 2002 12/6/2021 Pfizer Sinovac 3153 5050 AstraZeneca 5278 330 704 4356 9634 Melaka Pfizer Sinovac AstraZeneca 95 425 205 909 203 1264 3609 4110 1034 13/6/2021 Johor Pfizer 2600 1009 Sinovac 3090 1020 1500 AstraZeneca 7004 8504 Melaka Pfizer 303 200 503 375 876 1511 Sinovac 501 AstraZeneca 806 705 *Numbers come from citizen record consist of name, identification number, handphone number.
Expert Solution
steps

Step by step

Solved in 5 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