Normalize the below given Student Course Plan to First Normal Form, Second Normal Form and Third Normal Form.

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

Normalize the below given Student Course Plan to First Normal Form, Second Normal
Form and Third Normal Form.

Report ID.: 7686
Reporting period: Jan 2019-Mar 2019
Branch Code: 876
Supervisor ID: 12b14111
734
Branch Name: Al-Khoud
Supervisor Name: Abvaaa
Maryam al Zadjali
Penalty/traff Final Bill
ic Violation Amount
details(OMR) (OMR)
Car
Car Type
Car Desc
Bill No
Bill Date
Plate No
D54049
C3454
Toyata Camry
Pajero
BMW X5
SUV
453
23/1/2019
25/2/2019
2/2/2019
| 4/3/2019
6/3/2019
50
670
4WD
343
345
A43322
4WD
234
450
Toyota Camry
V5432
SUV
565
432
F43432
Mazda C9
4WD
342
15
400
Е34343
Toyota RAV4
4WD
222
4/2/2018
15
544
Overall Turnover: 2841 OMR
Note: Each Car may be billed many times during the reporting period. Penalty details are
the traffic violations recorded by the car for the bill.
Transcribed Image Text:Report ID.: 7686 Reporting period: Jan 2019-Mar 2019 Branch Code: 876 Supervisor ID: 12b14111 734 Branch Name: Al-Khoud Supervisor Name: Abvaaa Maryam al Zadjali Penalty/traff Final Bill ic Violation Amount details(OMR) (OMR) Car Car Type Car Desc Bill No Bill Date Plate No D54049 C3454 Toyata Camry Pajero BMW X5 SUV 453 23/1/2019 25/2/2019 2/2/2019 | 4/3/2019 6/3/2019 50 670 4WD 343 345 A43322 4WD 234 450 Toyota Camry V5432 SUV 565 432 F43432 Mazda C9 4WD 342 15 400 Е34343 Toyota RAV4 4WD 222 4/2/2018 15 544 Overall Turnover: 2841 OMR Note: Each Car may be billed many times during the reporting period. Penalty details are the traffic violations recorded by the car for the bill.
Expert Solution
steps

Step by step

Solved in 4 steps

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