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...
-
I hope that clears it up for you, Mr. Icarus. Enjoy your flight, and thanks for flying Premium. Mr. Icarus, whose desire to board the Premium plane has all but melted away during Glens long...
-
Multiple Choice Questions: 1. Pure monopoly is defined as a. An industry consisting of a single seller. b. A market structure that involves many substitute products. c. A market in which many rival...
-
1. CPA QUESTION When a common stock offering requires registration under the Securities Act of 1933: (a) The registration statement is automatically effective when filed with the SEC. (b) The issuer...
-
Anya Clark opened Anyas Cleaning Service on July 1, 2017. During July, the following transactions were completed. July 1 Anya invested $20,000 cash in the business. 1 Purchased used truck for...
-
1) You place an order for 500 bicycles at a unit price of $250. The supplier offers terms of 1/15, net 35. a) How long do you have to pay before the account is overdue? If you take the...
-
The cost of a single RD-6 satellite is $350 million. A MK-8 imaging satellite carries a price tag of $300 million. Another significant factor with satellites is the cost of the launch. In particular,...
-
2. Overhead is assigned to the manufacturing department at the rate of $10 per machine hour. There were 3,500 machine hours during October in the shaping department and 2,500 in the packaging...
-
An acquirer has a book value for its current assets of $25,000 and market value of current assets of $200,000. The target has a book value for its current assets of $3,500 and market value of current...
-
Alternative A is spending $125,000 on repairing the current machine the company owns. This would extend the life of the old machine for another 10 years and will yield savings of $19,000 per year....
-
The solution set for 6a - a-5 = 0 is
-
Question 2 Structured notes linked to either hedge funds or mutual funds are popular with investors but raise several unique issues for the bank structuring them when compared to structuring products...
-
Solve for y. 5y+6x= -25
-
Write a complete C++ program to display all data from the array below. You need to implement displayArray2 function. void displayArray2(int grades[4][3]); // prototype C++ int grades[4][3] =...
-
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...
-
The efficient use of assets is indicated by: a. Turnover ratios. b. Debt-related ratios. c. The ratio of debt to equity. d. The ratio of current assets to current liabilities.
-
Which of the following items is not included in the calculation of income from operations? a. Gains on the sale of short-term investments. b. Interest income. c. Interest expense. d. None of the...
-
Hedging (I) There are several schools of thought regarding hedging and its impact on the value of the firm. One school argues that, if the owners of the firm wish to hedge, they can do so in their...
Study smarter with the SolutionInn App