Dont put codes for the formuals writr in terms of sigma and pi please PROD_CODE PROD_NAME PROD_QTY
Fantastic news! We've Found the answer you've been seeking!
Question:
Dont put codes for the formuals writr in terms of sigma and pi please
Transcribed Image Text:
PROD_CODE PROD_NAME PROD_QTY PROD_PRICE 0123-H Hammer 10 0124-R Tool 300 25 0123-R Sheet Plastic 4500,2 2,5 0126-B Wrench 200 13 0127-Z Ply Wood 3500,5 35,7 0129-X Dog Food 100 0130-Z Cleaning Prod 250 1,2 3 PROD_CODE VEND CODE SVLINK DATE 0123-H 21 01/03/2021 0130-Z 26 24/03/2012 0130-Z 25 03/12/2021 0123-H 25 23/05/2022 21 VEND CODE VEND CONTACT VEND_PHONE 21 Ala 25 Meriem 26 972-3512 973-2753 0127-2 0123-H 26 Given the above three tables and supposing that the above is the only data contained in them, answer the following questions: 1. What would you name each table? 2. They are part of what database, do you think? 3. Are there any relations between the tables? Explain? 4. Are there any integrity problems with the above tables? Explain. 5. Give a formula for the relation listing products with a quantity < 15. Give the couples of these products with their prices. 6. In the easiest way, give a formula for the relation listing all the products that have vendors. Give product code, name and vendor's telephone. 7. In the easiest way, give a formula for the relation listing all the products that do not have vendors. Gives product codes and names. 8. In the easiest way list all the products that are sold by all vendors (just product code). PROD_CODE PROD_NAME PROD_QTY PROD_PRICE 0123-H Hammer 10 0124-R Tool 300 25 0123-R Sheet Plastic 4500,2 2,5 0126-B Wrench 200 13 0127-Z Ply Wood 3500,5 35,7 0129-X Dog Food 100 0130-Z Cleaning Prod 250 1,2 3 PROD_CODE VEND CODE SVLINK DATE 0123-H 21 01/03/2021 0130-Z 26 24/03/2012 0130-Z 25 03/12/2021 0123-H 25 23/05/2022 21 VEND CODE VEND CONTACT VEND_PHONE 21 Ala 25 Meriem 26 972-3512 973-2753 0127-2 0123-H 26 Given the above three tables and supposing that the above is the only data contained in them, answer the following questions: 1. What would you name each table? 2. They are part of what database, do you think? 3. Are there any relations between the tables? Explain? 4. Are there any integrity problems with the above tables? Explain. 5. Give a formula for the relation listing products with a quantity < 15. Give the couples of these products with their prices. 6. In the easiest way, give a formula for the relation listing all the products that have vendors. Give product code, name and vendor's telephone. 7. In the easiest way, give a formula for the relation listing all the products that do not have vendors. Gives product codes and names. 8. In the easiest way list all the products that are sold by all vendors (just product code).
Expert Answer:
Related Book For
Introduction To Actuarial And Financial Mathematical Methods
ISBN: 9780128001561
1st Edition
Authors: Stephen Garrett
Posted Date:
Students also viewed these programming questions
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
Addie's grandfather has left them a trust and the value of the money they receive depends on the age choose to collect this gift of money. Their options are given in the table below. Payoff at age 19...
-
Marvin is the executor and sole heir of his aunt's estate. The estate includes her furnished home, which Marvin is considering converting to rental property to generate additional cash flow. What are...
-
Human proteins can now be produced in bacteria such as E. coli. However, one cannot simply introduce a human gene into E. coli and expect it to be expressed. What steps must be taken to construct an...
-
What elements are generally included in an EDP system?
-
1. Identify several business strategies Dell has used so far, including the strategy that made the company famous. 2. Suggest a plan to Dell executives for continuing its past successes into the...
-
5. Use MATLAB to solve the following system of 3 linear equations in unknowns x, y and z. 4x+3y+2z = 44 5x+5y+7x=71 X+ Z = 11 Note that these equations can be written in matrix form as A x=b, where...
-
Peru Furniture City, Inc., sold $88,000 of furniture in May to customers who used their American Express Credit Cards. Such sales are subject to a 5% discount by American Express (a nonbank credit...
-
Adam consumes only beer (B) and whisky (W). His utility function is U(B,W) = B+5W, where B is the quantity of beer and W is the quantity of whisky. The price of beer is PB = 5, the price of whisky is...
-
What rate of interest compounded annually is involved if a. an investment of \($10\),000 made now will result in a receipt of \($23\),674 ten years from now? b. an investment of \($2\),000 made 18...
-
AutoFoundry has contacted Centrifugal Casting Company about the purchase of machines for the production of (1) Babbitt bearings, and (2) diesel cylinder liners (engine sleeves). The cost of the...
-
You have settled on a house for \($180\),000 and need a loan for \($171\),000. You have been offered a \($171\),000 loan for 6.25 percent, plus 2.375 points (applied to only the \($171\),000), plus...
-
What is the present value of the following future receipts? a. $19,000 five years from now at 9 percent compounded annually b. $8,300 twelve years from now at 15 percent compounded annually c. $6,200...
-
A subsidiary of a major furniture company manufactures wooden pallets. The plant has the capacity to produce 300,000 pallets per year. Presently, the plant is operating at 70 percent of capacity. The...
-
Find the Inverse fourier transform of following signals G(f)| G12 -B (a) (b)
-
Explain the term "Equivalent Units". Why are they calculated in process costing? [4 Marks] [minimum 350 words]
-
Use the Newton-Raphson method to determine all real roots of the function f(x) = e (x1) 2 2. An error tolerance of = 0.0001 should be used.
-
Repeat Example 13.18 using the central-difference formula of O(h 2 ). Example 13.18 Compute {D hk f(x)} at x = 2 for the following functions. You should use stepsize h k = 10 k for k = 1, 2, . . ....
-
State whether each of the following expressions are identities or equations. Where appropriate, use any method to identify the values of such that the equations hold. . y-16 = (y-4) (y + 4) a. b. y...
-
Random samples are taken from two normal populations with \(\sigma_{1}=9.6\) and \(\sigma_{2}=13.2\) to test the null hypothesis \(\mu_{1}-\mu_{2}=41.2\) against the alternative hypothesis...
-
With reference to part (a) of Exercise 8.33, how would you pair and then randomize for a paired test? Data From Exercise 8.33 8.33 How would you randomize, for a two sample test, in each of the...
-
How would you randomize, for a two sample test, in each of the following cases? (a) Forty combustion engines are available for a speed test and you want to compare a modified exhaust valve with the...
Study smarter with the SolutionInn App