c) Draw a 3NF dependency diagram.

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

c) Draw a 3NF dependency diagram.

Invoice No
Date
Due Date
Receiver Name
Address
Phone No
Description Item Qty Unit Price(MYR)
Total(MYR)
9/11/2014
16/11/2014
016-339 8877 Loafers in
29th Floor,
Menara Multi-Purpose,
Capital Square,
8 Jalan Munshi Abdullah,
50100 Kuala Lumpur,
Malaysia
1070
Sharon James
1
1
60
60
Houndstoot
h
/Black
w/Tassels [9
12 mnth)
1070
9/11/2014
16/11/2014
Sharon James
29th Floor,
016-339 8877 Loafers in
2
1
100
100
Menara Multi-Purpose,
Houndstoot
h/Black
Capital Square,
8 Jalan Munshi Abdullah,
w/Tassels
[21.Scm)
50100 Kuala Lumpur,
Malaysia
1055
26/10/2014
2/11/2015
Mohd Zulhilmi No. 2-3-6, Jalan 20/2A,
012-319 1611 Loafers in
1
1
60
60
Tama Wilayah,
68100 Kuala Lumpur,
Houndstoot
h
/Black
w/Tassels (6
9 mnth)
Malaysia
1019
24/7/2014
31/7/2014
Alia binti Rani
No 40, Rumah Rakyat
012-968 4123 Kako in
1
1
60
60
Pelangai, 72000 Kuala
Pilah, Negeri Sembilan,
Malaysia
Classic (12-
18 mths)
1012
22/7/2014
29/7/2014
Dayang Afiza
Lot 1248, Jalan Piasau
012-878 7611 Loafers in
1
1
60
60
Jaya 2F, Fasa 2, 98000 Miri,
Sarawak, Malaysia
Black/Snails
[12-18
mths)
1012
22/7/2014
29/7/2014
Dayang Afiza
Lot 1248, Jalan Piasau
012-878 7611 Felt Moccs
2
1
60
60
Jaya 2F, Fasa 2, 98000 Miri,
Sarawak, Malaysia
in Red (with
Flowers)[12-
18 mths)
Transcribed Image Text:Invoice No Date Due Date Receiver Name Address Phone No Description Item Qty Unit Price(MYR) Total(MYR) 9/11/2014 16/11/2014 016-339 8877 Loafers in 29th Floor, Menara Multi-Purpose, Capital Square, 8 Jalan Munshi Abdullah, 50100 Kuala Lumpur, Malaysia 1070 Sharon James 1 1 60 60 Houndstoot h /Black w/Tassels [9 12 mnth) 1070 9/11/2014 16/11/2014 Sharon James 29th Floor, 016-339 8877 Loafers in 2 1 100 100 Menara Multi-Purpose, Houndstoot h/Black Capital Square, 8 Jalan Munshi Abdullah, w/Tassels [21.Scm) 50100 Kuala Lumpur, Malaysia 1055 26/10/2014 2/11/2015 Mohd Zulhilmi No. 2-3-6, Jalan 20/2A, 012-319 1611 Loafers in 1 1 60 60 Tama Wilayah, 68100 Kuala Lumpur, Houndstoot h /Black w/Tassels (6 9 mnth) Malaysia 1019 24/7/2014 31/7/2014 Alia binti Rani No 40, Rumah Rakyat 012-968 4123 Kako in 1 1 60 60 Pelangai, 72000 Kuala Pilah, Negeri Sembilan, Malaysia Classic (12- 18 mths) 1012 22/7/2014 29/7/2014 Dayang Afiza Lot 1248, Jalan Piasau 012-878 7611 Loafers in 1 1 60 60 Jaya 2F, Fasa 2, 98000 Miri, Sarawak, Malaysia Black/Snails [12-18 mths) 1012 22/7/2014 29/7/2014 Dayang Afiza Lot 1248, Jalan Piasau 012-878 7611 Felt Moccs 2 1 60 60 Jaya 2F, Fasa 2, 98000 Miri, Sarawak, Malaysia in Red (with Flowers)[12- 18 mths)
1012
22/7/2014
29/7/2014
Dayang Afiza
Lot 1248, Jalan Piasau
012-878 7611 Little
1
60
60
Jaya 2F, Fasa 2, 98000 Miri,
Sarawak, Malaysia
Gentleman
in Brown(6-
9 mths)
1080
25/11/2014
2/12/2014
Fify Baharuddin Kuarters Guru SK.Bandar
3093-B Lorang Md Noh,
017-386 8123 Loafers in
1
60
60
Zidzag/Blac
Bakri Batu 2, 84000 Muar,
k
w/Tassels[3-
6 mnth]
012-886 9123 Military
Johor, Malaysia
1064
31/10/2014
7/11/2014
Amanina
1092, Lorong D6, Taman
Satria Jaya, BDC
Stampin,93350, Kuching,
Sarawak, Malaysia
1
1
85
85
Chelsea
Boats in
Red[18-24
mnth]
1053
25/10/2014
1/11/2014
Yuhanis Mohd No 22, Jalan4/SF, Bandar
013-273 0529 Loafers in
1
1
60
60
Baru Bangi, 43650
Selangor Darul Ehsan,
Malaysia
Ho undstoot
h/Black
w/Tassels (9
12 mnth]
Tesca Stares(M) SDN BHD 016-322 5422 Loafers in
Ha undstaot
h/Black
w/Tassels (9
1045
15/10/2014
22/10/2014
Akmar Jaff
1
1
60
60
Head office, Level 3, No. 3,
Jalan 7A/62A, Bandar
Menjalara, 52200,Kuala
Lumpur Wilayah
Persekutuan, Malaysia
Batu 10 3/4, Kampung
12 mnth]
1022
4/8/2014
11/8/2014
Nissa Anuar
012-221 2800 Loafers in
1
1
60
60
Kilang Padi, 71900
Seremban, Negeri
Sembilan, Malaysia
FOTM-
August/Blue
[3-6 mnth]
1030
8/9/2014
15/9/2019
Khayra Mohamed 28-1, Jalan 25/70A, Desa
012-243 7511 Loafers in
1
60
60
Sri Hartamas, S0480 Kuala
Lumpur, Malaysia
Plaid/Brown
(with
tassels)[3-6
mnth)
Transcribed Image Text:1012 22/7/2014 29/7/2014 Dayang Afiza Lot 1248, Jalan Piasau 012-878 7611 Little 1 60 60 Jaya 2F, Fasa 2, 98000 Miri, Sarawak, Malaysia Gentleman in Brown(6- 9 mths) 1080 25/11/2014 2/12/2014 Fify Baharuddin Kuarters Guru SK.Bandar 3093-B Lorang Md Noh, 017-386 8123 Loafers in 1 60 60 Zidzag/Blac Bakri Batu 2, 84000 Muar, k w/Tassels[3- 6 mnth] 012-886 9123 Military Johor, Malaysia 1064 31/10/2014 7/11/2014 Amanina 1092, Lorong D6, Taman Satria Jaya, BDC Stampin,93350, Kuching, Sarawak, Malaysia 1 1 85 85 Chelsea Boats in Red[18-24 mnth] 1053 25/10/2014 1/11/2014 Yuhanis Mohd No 22, Jalan4/SF, Bandar 013-273 0529 Loafers in 1 1 60 60 Baru Bangi, 43650 Selangor Darul Ehsan, Malaysia Ho undstoot h/Black w/Tassels (9 12 mnth] Tesca Stares(M) SDN BHD 016-322 5422 Loafers in Ha undstaot h/Black w/Tassels (9 1045 15/10/2014 22/10/2014 Akmar Jaff 1 1 60 60 Head office, Level 3, No. 3, Jalan 7A/62A, Bandar Menjalara, 52200,Kuala Lumpur Wilayah Persekutuan, Malaysia Batu 10 3/4, Kampung 12 mnth] 1022 4/8/2014 11/8/2014 Nissa Anuar 012-221 2800 Loafers in 1 1 60 60 Kilang Padi, 71900 Seremban, Negeri Sembilan, Malaysia FOTM- August/Blue [3-6 mnth] 1030 8/9/2014 15/9/2019 Khayra Mohamed 28-1, Jalan 25/70A, Desa 012-243 7511 Loafers in 1 60 60 Sri Hartamas, S0480 Kuala Lumpur, Malaysia Plaid/Brown (with tassels)[3-6 mnth)
Expert Solution
steps

Step by step

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