Suppose Government of Bangladesh decided to sell onion in lower price than the local market, for...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Answer rating: 100% (QA)
Q1 Q2 SellerInfo SID Name StoreID Your ID Abul 1011 Your age Babul 1021 Your birt... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
Answer the following questions based on Tables 5P-1 and 5P-2. a. What is the quantity demanded at $10? What is the quantity supplied at $10? b. What is the quantity demanded at $25? What is the...
-
Answer the following questions based on two assumptions: (1) Inflation increases the prices of all goods by 20%. (2) Ina's income increases from $50,000 to $55,000. a. Has Ina's budget line become...
-
Answer the following questions based on Tables 5P-3 and 5P-4. a. What is the quantity demanded at $10? What is the quantity supplied at $10? b. What is the quantity demanded at $25? What is the...
-
Develop a data type ResizingArrayQueueOfStrings that implements a queue with a fixed-length array in such a way that all operations take constant time. Then, extend your implementation to use a...
-
Catherine Horton was an expert cook, and she immensely enjoyed the creative freedom of developing new dishes. Her specialty was desserts. For years, her friends had raved about her creations, and...
-
Name the following defects in TiO 2 and write their KrgerVink symbols: Al and Nb dopants at the Ti site; F and N dopants at the O site; oxygen and titanium atoms out of their regular sites.
-
The author collected sample data by randomly selecting 20 different pages from a printed version of the Merriam-Webster Dictionary and then counting the number of defined words on each of those...
-
Moore, Probst, and Tanski formed a partnership whose profit and loss agreement contained the following provisions: If the weighted-average capital is negative, interest at 10% will be charged against...
-
The subject matter of this Agreement is the sale by the Seller of the object described below and in the documents attached as Exhibit A (the "object): Object: Vachetta leather - highest quality and...
-
As the auditor of Clearwater County you learn that various assets are subject to spending constraints. Indicate how each of the following constraints would affect the countys reported fund balance...
-
describe in a bulleted list the order in which the step - by - step crisis action plan for containing a potential TB outbreak should follow?
-
Directions: Practice your banking skills by completing the following exercise. Don't forget to record all of your checks in the check register. 1. On October 3rd of this year, your received a...
-
Contrast the profitability that Dr. Lopez faces by using the cash basis of accounting with the profitability he faces by using the accrual basis of accounting for the month of July. What if Dr. Lopez...
-
TransLink has announced the Canada Line will be extended to Steveston. The train will take one of two routes No. 3 Road or Garden City. You have an opportunity to purchase some property on each of...
-
What skill sets do you need to carry out a good quantitative or qualitative critical appraisal? What are the three main purposes of the critical appraisal process? How would you explain rapid...
-
The town of Manwin has exactly 100 parking spaces, x, and the costs of supplying each space are zero (but no more than 100 spaces can be brought to market). Each person who parks pays a monthly...
-
a. Hidromek is a globally known manufacturer of construction machinery. The company wants to build a spare part storage facility in the Ankara. A civil engineer who is alumni of YTU has identified...
-
Nitrogen monoxide reacts with hydrogen as follows: 2NO(g)+ H2(g) N2O(g) + H2O(g) The rate law is [H2]/ t = k[NO]2[H2], where k is 1.10 107 L2/(mol2s) at 826oC. A vessel contains NO and H2 at...
-
According to an article in the Economist about the health care system in the United Kingdom: A defining principle of the National Health Service is that it is free at the point of delivery. What does...
-
What are the problems in measuring the unemployment rate? In what ways does the official BLS measure of the unemployment rate understate the true degree of unemployment? In what ways does the...
-
Look again at the information in Figure 2.4 on page 49. Choose a rate of trading cherries for apples different from the rate used in the text (15 pounds of cherries for 10 pounds of apples) that will...
-
Chris Matthews investments over the past several years have not lived up to his full return expectations. He is not particularly concerned, however, because his return is only about 2 percentage...
-
Recommend three financial goals and related activities for someone in each of the following circumstances: a. Junior in college b. 25-year-old computer programmer who plans to earn an MBA degree c....
-
During the Christmas break of his final year at Ohio State, Bill Bledsoe plans to put together his rsum in order to seek full-time employment as a medical technician during the spring semester. To...
Study smarter with the SolutionInn App