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 SID YourID Your age Your birth month Your birth date Invoiceld 0112 0223 0334 0445 Table: InvoiceInfo 2. 3. Name Abul Babul Karina Rahim Stor elD 1011 1021 Your birth year 1011 Onion Type Price SellerID Egypt 40 11 Bangla 130 13 India 90 11 Bangla 130 NT 24 QtyKE 6 2.5 3 2 1. Create the tables for above scenario with correct relationship. Insert all the data to tables. 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 SID YourID Your age Your birth month Your birth date Invoiceld 0112 0223 0334 0445 Table: InvoiceInfo 2. 3. Name Abul Babul Karina Rahim Stor elD 1011 1021 Your birth year 1011 Onion Type Price SellerID Egypt 40 11 Bangla 130 13 India 90 11 Bangla 130 NT 24 QtyKE 6 2.5 3 2 1. Create the tables for above scenario with correct relationship. Insert all the data to tables. 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)

Q1 Q2 SellerInfo SID Name StoreID Your ID Abul 1011 Your age Babul 1021 Your birt... View the full answer