Inventory items stored in Sudbury

Reference no: EM13189346

Question 1: Use the attached database to provide the relational algebra which would list the requested information (showing the result relation for EACH STEP). (6 marks each - total 48 marks)

a. Give the details of all suppliers in the Sault Ste Marie.

b. List all inventory items with a quantity less than 100 units

c. List all the inventory items stored in Sudbury

d. Give the supplier details (name and id) for those located in Sudbury.

e. List all the supplier names who supply all the red parts.

f. List the details of parts supplied by Quality

g. List the part number of all parts supplied and located in the same city.

h. List the supplier details for suppliers who do not supply blue parts.

Reference no: EM13189346

Questions Cloud

Experiences with the social networking sites : Your experiences with the social networking sites like Craig list etc etc and Why do you think social networking sites are so popular? In other words, what is their stickiness?

Design the guide to the history of visual communication : Your next step as an intern helping to design the guide to the history of visual communication is to gather at least six pieces of art or design for the chapter on art forms throughout the ages. The pieces you pick should be pieces of art or design t..

Will fields with both oil and gas have greater difficulties : Some fields have large enough quantities of both oil and natural gas that coordination must be achieved for the production of both, rather than oil a in our examples. Will fields with both oil and gas have greater difficulties in unitization than ..

Describe effects of one chemical-biological and radiological : Describe the effects of one chemical, biological, and radiological agent; include the proper decontamination and treatment methods for each. Explain one dispersal device/delivery method for each selected chemical, biological, and radiological agent.

Inventory items stored in Sudbury : Give the details of all suppliers in the Sault Ste Marie, list all inventory items with a quantity less than 100 units and list all the inventory items stored in Sudbury

Write Relational Algebra queries : Attributes cid and fid in Reservation are foreign keys referencing homonymous attributes in Customer and Flight, respectively. Write Relational Algebra queries

Design an algorithm to find the selling price : To make a profit, the prices of the items sold in a furniture store are marked up by 60%. Design an algorithm to find the selling price of an item sold at the furniture store. What information do you need to find the selling price?

What is the direct labor rate variance? : The following data relate to direct labor costs for the current period:

What range of payments will the beekeeper accept : Assuming that the beekeeper gets that amount, what range of payments will the farmer accept (Remember that negative payments are also possible.) Answer the same questions for the fifth day.

User Account

All Pages