Global Value-Price team conducted a price survey from the internet and other information resources. The findings of the survey are gathered in an Excel worksheet, as follows: Item Item Company Item Weight Company Company Company Company Item In Name Name Price (gm) City Country PostalCode Tel No Model Stock DVD Optima $100.00 123 Ottawa Canada K2J4C3 876543 Sony Yes TV NCR $789.00 222 New York USA 12345 987654 Sony No Laptop Mac $321.00 322 Paris France 32456 1098765 R500 Yes Laptop Sony $555.00 433 Kingston Canada J2J6G5 1209876 S99 No DVD Orion $89.00 121 London UK 12345 1320987 Sony Yes Camera Future $321.00 144 Toronto Canada G2G5M2 1432098 Sony Yes Laptop IBM $300.00 322 London UK 12567 1543209 R500 No Laptop $400.00 322 Ottawa Canada K218V1 1654320 MM66 Yes Laptop BestBuy $299.00 322 Dallas USA 14566 1765431 HP44 Yes Laptop Algon $298.00 322 Toronto Canada G4G4M5 1876542 R500 No Iphone Optima $700.00 123 Ottawa Canada K2P1J7 1987653 Sony Yes Nexus 6 Sony $355.00 133 Kingston Canada J2J6G5 2098764 R99 Yes DVD Sony $155.00 233 Kingston Canada J2J6G5 2209875 JVC Each company has many items The Sale price of the same item is different from one company to another. You, as database designer, are asked to do the following: Dell Yes Study the business case (The Excel Data); classify the information into entities with proper primary key and/or foreign key (you may add extra field(s) as primary key, if necessary). Remember you have to avoid duplication in your DB design. Question 51 (4 points) Design the conceptual schema of the created entities from the table above? Global Value-Price team conducted a price survey from the internet and other information resources. The findings of the survey are gathered in an Excel worksheet, as follows: Item Item Company Item Weight Company Company Company Company Item In Name Name Price (gm) City Country PostalCode Tel No Model Stock DVD Optima $100.00 123 Ottawa Canada K2J4C3 876543 Sony Yes TV NCR $789.00 222 New York USA 12345 987654 Sony No Laptop Mac $321.00 322 Paris France 32456 1098765 R500 Yes Laptop Sony $555.00 433 Kingston Canada J2J6G5 1209876 S99 No DVD Orion $89.00 121 London UK 12345 1320987 Sony Yes Camera Future $321.00 144 Toronto Canada G2G5M2 1432098 Sony Yes Laptop IBM $300.00 322 London UK 12567 1543209 R500 No Laptop $400.00 322 Ottawa Canada K218V1 1654320 MM66 Yes Laptop BestBuy $299.00 322 Dallas USA 14566 1765431 HP44 Yes Laptop Algon $298.00 322 Toronto Canada G4G4M5 1876542 R500 No Iphone Optima $700.00 123 Ottawa Canada K2P1J7 1987653 Sony Yes Nexus 6 Sony $355.00 133 Kingston Canada J2J6G5 2098764 R99 Yes DVD Sony $155.00 233 Kingston Canada J2J6G5 2209875 JVC Each company has many items The Sale price of the same item is different from one company to another. You, as database designer, are asked to do the following: Dell Yes Study the business case (The Excel Data); classify the information into entities with proper primary key and/or foreign key (you may add extra field(s) as primary key, if necessary). Remember you have to avoid duplication in your DB design. Question 51 (4 points) Design the conceptual schema of the created entities from the table above