Dont put codes for the formuals writr in terms of sigma and pi please PROD_CODE PROD_NAME PROD_QTY

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).