Suppose Government of Bangladesh decided to sell onion in lower price than the local market, for...

 

Transcribed Image Text:

Suppose Government of Bangladesh decided to sell onion in lower price than the local market, for this reason a database is designed to implement the software. Now answer the following questions based on the tables below: Table: Sellerinfo Table: Invoicelnfo SID Invoiceld OnionType Price SellerID QtyKG Date Name StorelD Egypt Bangla Abul 0112 40 11 6. 11 Dec 2019 YourlD Your age 1011 Babul 1021 0223 130 13 2.5 10 Dec 2019 Your birth Karina Your birth 0334 India 90 11 8 Dec 2019 month year 0445 Bangla 130 24 10 Dec 2019 Your birth Rahim 1011 date 1. Create the tables for above scenario with correct relationship. 2. Insert all the data to tables. 3. Show the name of Seller who works in same shop. 4. Find the Onion which has highest price than all others. 5. Show the information of seller who sold Indian onion. 6. Find the store id which have more than one employee. 7. Show the price of onion which is more than 40 taka per kg. 8. Find which seller earned maximum amount selling onion. 9. Find the invoice info which price is in between 40and 190. 10. Find the sellers whose name contains h in 3rd position Suppose Government of Bangladesh decided to sell onion in lower price than the local market, for this reason a database is designed to implement the software. Now answer the following questions based on the tables below: Table: Sellerinfo Table: Invoicelnfo SID Invoiceld OnionType Price SellerID QtyKG Date Name StorelD Egypt Bangla Abul 0112 40 11 6. 11 Dec 2019 YourlD Your age 1011 Babul 1021 0223 130 13 2.5 10 Dec 2019 Your birth Karina Your birth 0334 India 90 11 8 Dec 2019 month year 0445 Bangla 130 24 10 Dec 2019 Your birth Rahim 1011 date 1. Create the tables for above scenario with correct relationship. 2. Insert all the data to tables. 3. Show the name of Seller who works in same shop. 4. Find the Onion which has highest price than all others. 5. Show the information of seller who sold Indian onion. 6. Find the store id which have more than one employee. 7. Show the price of onion which is more than 40 taka per kg. 8. Find which seller earned maximum amount selling onion. 9. Find the invoice info which price is in between 40and 190. 10. Find the sellers whose name contains h in 3rd position

Answer rating: 100% (QA)

I am assuming the following values of SID Your Id 01 Your Age 24 Your Birth Month 11 Your Birth Date 13 The queries are 1create table SellerInfo creat... View the full answer