Reporting Period 7686 January 2021 to March 2021 7686 January 2021 to March 2021 7686 January 2021 to March 2021 7686 January 2021 to March 2021 1056 October 2021 to December 20 1056 October 2021 to December 20 1056 October 2021 to December 20 1056 October 2021 to December 20 1056 October 2021 to December 20 4981 January 2022 to March 2022 4981 January 2022 to March 2022 7002 July 2021 to September 2021 7002 July 2021 to September 2021 7002 July 2021 to September 2021 7002 July 2021 to September 2021 7002 July 2021 to September 2021 3121 April 2021 to June 2021 3121 April 2021 to June 2021 3121 April 2021 to June 2021 eport ID Branch Code Branch Name 876734 london 876734 london 876734 london 876734 london 100023 manchester 100023 manchester 100023 manchester 100023 manchester 100023 manchester 456109 birmingham 456109 birmingham 981256 bristol 981256 bristol 981256 bristol 981256 bristol 981256 bristol 555901 swansea 555901 swansea 555901 swansea Supervisor ID Supervisor Name 300 jeff 300 jeff 300 jeff 300 jeff 400 louis 400 louis 400 louis 400 louis 400 louis 500 matt 500 matt 600 robert 600 robert 600 robert 600 robert 600 robert 700 tom 700 tom 700 tom BA1234 BA6753 DL3434 OP9817 SJ7182 BA1561 BA9878 BA9123 BN9745 LA5142 BA8177 CB0098 BA4545 BA1000 ZX7222 QW0128 BA8882 Car Plate Nr Car Description Car Type DS4049 SUV Sports Car SUV Hatchback SUV Sedan Sports Car Coupe Sedan SUV Hatchback Sedan Sports Car Sedan Hatchback Sedan SUV Sports Car Coupe BA5656 BA0012 BA3421 PO8123 IU7878 GF5612 NM8787 VC1111 FG7100 BA4545 BA8177 BA9123 BA9878 RE6000 TR6199 BA1561 DR1166 BA6753 BP9111 BA1234 480 Bill Nr Bill Date Penalty 166651 18.01.2021 123111 19.02.2021 561909 06.03.2021 565690 29.01.2021 128976 10.10.2021 511899 25.11.2021 141421 03.12.2021 514879 29.10.2021 771100 16.11.2021 675912 06.01.2022 991762 08.02.2022 110054 19.07.2021 378123 12.08.2021 808051 18.09.2021 100023 21.07.2021 611554 27.08.2021 888712 10.04.2021 343412 28.05.2021 222678 04.06.2021 Final Bill 50 1050 0 500 0 0 0 20 0 0 20 50 0 100 20 0 0 50 680 710 1500 850 1250 300 350 950 1400 450 670 1030 520 490 1230 0 20 0 1680

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 this table.

it's a traditional database. Should you keep it that way?

 

Reporting Period
7686 January 2021 to March 2021
7686 January 2021 to March 2021
7686 January 2021 to March 2021
7686 January 2021 to March 2021
1056 October 2021 to December 20
1056 October 2021 to December 20
1056 October 2021 to December 20
1056 October 2021 to December 20
1056 October 2021 to December 20
4981 January 2022 to March 2022
4981 January 2022 to March 2022
7002 July 2021 to September 2021
7002 July 2021 to September 2021
7002 July 2021 to September 2021
7002 July 2021 to September 2021
7002 July 2021 to September 2021
3121 April 2021 to June 2021
3121 April 2021 to June 2021
3121 April 2021 to June 2021
Report ID
Branch Code Branch Name
876734 london
876734 london
876734 london
876734 london
100023 manchester
100023 manchester
100023 manchester
100023 manchester
100023 manchester
456109 birmingham
456109 birmingham
981256 bristol
981256 bristol
981256 bristol
981256 bristol
981256 bristol
555901 swansea
555901 swansea
555901 swansea
Supervisor ID Supervisor Name
300 jeff
300 jeff
300 jeff
300 jeff
400 louis
400 louis
400 louis
400 louis
400 louis
500 matt
500 matt
600 robert
600 robert
600 robert
600 robert
600 robert
700 tom
700 tom
700 tom
Car Plate Nr
DS4049
DL3434
OP9817
SJ7182
BN9745
LA5142
CB0098
ZX7222
QW0128
PO8123
IU7878
GF5612
NM8787
VC1111
FG7100
RE6000
TR6199
DR1166
BP9111
Car Description Car Type
BA1234
SUV
BA6753
Sports Car
BA1561
SUV
BA9878
Hatchback
BA9123
SUV
BA8177
Sedan
Sports Car
Coupe
Sedan
SUV
Hatchback
Sedan
Sports Car
Sedan
Hatchback
Sedan
SUV
Sports Car
Coupe
BA4545
BA1000
BA8882
BA5656
BA0012
BA3421
BA4545
BA8177
BA9123
BA9878
BA1561
BA6753
BA1234
Bill Nr Bill Date
166651 18.01.2021
123111 19.02.2021
561909 06.03.2021
565690 29.01.2021
128976 10.10.2021
511899 25.11.2021
141421 03.12.2021
514879 29.10.2021
771100 16.11.2021
675912 06.01.2022
991762 08.02.2022
110054 19.07.2021
378123 12.08.2021
808051 18.09.2021
100023 21.07.2021
611554 27.08.2021
888712 10.04.2021
343412 28.05.2021
222678 04.06.2021
Penalty Final Bill
50 1050
0
500
480
680
710
1500
850
1250
300
350
950
1400
450
670
1030
520
490
1230
1680
Ooo
0
20
0
0
20
50
0
100
20
0
0
50
0
20
0
Transcribed Image Text:Reporting Period 7686 January 2021 to March 2021 7686 January 2021 to March 2021 7686 January 2021 to March 2021 7686 January 2021 to March 2021 1056 October 2021 to December 20 1056 October 2021 to December 20 1056 October 2021 to December 20 1056 October 2021 to December 20 1056 October 2021 to December 20 4981 January 2022 to March 2022 4981 January 2022 to March 2022 7002 July 2021 to September 2021 7002 July 2021 to September 2021 7002 July 2021 to September 2021 7002 July 2021 to September 2021 7002 July 2021 to September 2021 3121 April 2021 to June 2021 3121 April 2021 to June 2021 3121 April 2021 to June 2021 Report ID Branch Code Branch Name 876734 london 876734 london 876734 london 876734 london 100023 manchester 100023 manchester 100023 manchester 100023 manchester 100023 manchester 456109 birmingham 456109 birmingham 981256 bristol 981256 bristol 981256 bristol 981256 bristol 981256 bristol 555901 swansea 555901 swansea 555901 swansea Supervisor ID Supervisor Name 300 jeff 300 jeff 300 jeff 300 jeff 400 louis 400 louis 400 louis 400 louis 400 louis 500 matt 500 matt 600 robert 600 robert 600 robert 600 robert 600 robert 700 tom 700 tom 700 tom Car Plate Nr DS4049 DL3434 OP9817 SJ7182 BN9745 LA5142 CB0098 ZX7222 QW0128 PO8123 IU7878 GF5612 NM8787 VC1111 FG7100 RE6000 TR6199 DR1166 BP9111 Car Description Car Type BA1234 SUV BA6753 Sports Car BA1561 SUV BA9878 Hatchback BA9123 SUV BA8177 Sedan Sports Car Coupe Sedan SUV Hatchback Sedan Sports Car Sedan Hatchback Sedan SUV Sports Car Coupe BA4545 BA1000 BA8882 BA5656 BA0012 BA3421 BA4545 BA8177 BA9123 BA9878 BA1561 BA6753 BA1234 Bill Nr Bill Date 166651 18.01.2021 123111 19.02.2021 561909 06.03.2021 565690 29.01.2021 128976 10.10.2021 511899 25.11.2021 141421 03.12.2021 514879 29.10.2021 771100 16.11.2021 675912 06.01.2022 991762 08.02.2022 110054 19.07.2021 378123 12.08.2021 808051 18.09.2021 100023 21.07.2021 611554 27.08.2021 888712 10.04.2021 343412 28.05.2021 222678 04.06.2021 Penalty Final Bill 50 1050 0 500 480 680 710 1500 850 1250 300 350 950 1400 450 670 1030 520 490 1230 1680 Ooo 0 20 0 0 20 50 0 100 20 0 0 50 0 20 0
Expert Solution
steps

Step by step

Solved in 2 steps with 5 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