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
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 | CompanyNo | CustiD CustName Brokerl 122 Ali CompanyType DateBought Share BoughtPrice |Dividend |Consumer Products 23/7/2009 450 BrokerName CompanyName Nestle (M) Sơn. Bhd. |Cheetah Holdings Sdn. Bhd. Properties Victory Manufacturing Sdn. Bhd |Manufacturing Berjaya Hotel Sdn. Bhd. Cheetah Holdings Sdn. Bhd. Properties |Berjaya Hotel Sdn. Bhd. Nestle (M) Sơn. Bhd. B22 Melaka Securities 23 0.80 1.10% 1/9/2009 100 15/10/2010 20/1/2011 30/5/2009 19/4/2010 45 2.00 2.00% 301 Mary B12 Kuala Lumpur City Securities 50 0.50 0.50% 11 21 Hotel 220 0.50 1.00% 45 50 3.10 2.00% 1001 Jeffry Hotel |Consumer Products 10/8/2011 | 1000 822 Melaka Securities 21 50 1.80 1.00% 23 1.20 1.10%
Step by step
Solved in 5 steps with 1 images
