Based on the following table, write the relational schema that meets 1NF, 2NF and 3NF requirements. You are required to draw the dependency diagram for 2NF. TABLE 6: CUSTOMER-SHARE RECORDS SAMPLE | CustiD CustName Brokerl 122 Ali CompanyType DateBought Share BoughtPrice Dividend |Consumer Products 23/7/2009 | 450 BrokerName CompanyNo CompanyName Nestle (M) Sdn. Bhd. |Cheetah Holdings Sdn. Bhd. Properties Victory Manufacturing Sdn. Bhd |Manufacturing Berjaya Hotel Sdn. Bhd. |Cheetah Holdings Sdn. Bhd. Berjaya Hotel Sdn. Bhd. Nestle (M) Sdn. Bhd. B22 Melaka Securities 23 0.80 1.10% 1/9/2009 15/10/2010 50 20/1/2011 30/5/2009 19/4/2010 45 100 2.00 2.00% 301 Mary B12 Kuala Lumpur City Securities 0.50 0.50% 11 Hotel |Properties Hotel Consumer Products 10/8/2011 21 220 0.50 1.00% 45 50 3.10 2.00% 1001 Jeffry 822 Melaka Securities 21 50 1.80 1.00% 23 1000 1.20 1.10%
Based on the following table, write the relational schema that meets 1NF, 2NF and 3NF requirements. You are required to draw the dependency diagram for 2NF. TABLE 6: CUSTOMER-SHARE RECORDS SAMPLE | CustiD CustName Brokerl 122 Ali CompanyType DateBought Share BoughtPrice Dividend |Consumer Products 23/7/2009 | 450 BrokerName CompanyNo CompanyName Nestle (M) Sdn. Bhd. |Cheetah Holdings Sdn. Bhd. Properties Victory Manufacturing Sdn. Bhd |Manufacturing Berjaya Hotel Sdn. Bhd. |Cheetah Holdings Sdn. Bhd. Berjaya Hotel Sdn. Bhd. Nestle (M) Sdn. Bhd. B22 Melaka Securities 23 0.80 1.10% 1/9/2009 15/10/2010 50 20/1/2011 30/5/2009 19/4/2010 45 100 2.00 2.00% 301 Mary B12 Kuala Lumpur City Securities 0.50 0.50% 11 Hotel |Properties Hotel Consumer Products 10/8/2011 21 220 0.50 1.00% 45 50 3.10 2.00% 1001 Jeffry 822 Melaka Securities 21 50 1.80 1.00% 23 1000 1.20 1.10%
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...
Related questions
Question
Transcribed Image Text:Based on the following table, write the relational schema that meets 1NF, 2NF and 3NF
requirements. You are required to draw the dependency diagram for 2NF.
TABLE 6: CUSTOMER-SHARE RECORDS SAMPLE
CustiD CustName BrokerlD
122 Ali
CompanyType DateBought Share BoughtPrice Dividend
|Consumer Products 23/7/2009
Properties
BrokerName
CompanyNo
CompanyName
Nestle (M) Sdn. Bhd.
Cheetah Holdings Sdn. Bhd.
Victory Manufacturing Sdn. Bhd |Manufacturing
Berjaya Hotel Sdn. Bhd.
Cheetah Holdings Sdn. Bhd.
|Berjaya Hotel Sdn. Bhd.
Nestle (M) Sdn. Bhd.
B22 Melaka Securities
1.10%
23
450
0.80
2.00
1/9/2009
15/10/2010
45
100
2.00%
301 Mary
B12 Kuala Lumpur City Securities
11
0.50%
50
0.50
Hotel
Properties
Hotel
Consumer Products 10/8/2011| 1000
20/1/2011
30/5/2009
21
220
0.50
1.00%
45
50
3.10
2.00%
1001 Jeffry
B22 Melaka Securities
21
19/4/2010
50
1.80
1.00%
23
1.20
1.10%
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps with 1 images
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY