Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose Government of Bangladesh decided to sell onion in lower price than the local market, for this reason a database is designed to implement

 

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

Step by Step Solution

3.34 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Chemistry The Central Science

Authors: Theodore Brown, Eugene LeMay, Bruce Bursten, Catherine Murphy, Patrick Woodward

12th edition

321696727, 978-0132175081, 978-0321696724

More Books

Students also viewed these Databases questions

Question

How does harmonization differ from convergence?

Answered: 1 week ago