Names and numbers of london-based suppliers

Assignment Help Basic Computer Science

Reference no: EM13936380

A. Give the relational algebra expression for the following English queries.
1. Get the supplier# who supply all the blue parts
2. Get the suppliers names who supply all the parts located in London
3. Give the details of suppliers in Athens
4. Give details of shipments where the quantity shipped is less than 200
5. Give details of parts stored in Paris
6. Give the names and numbers of London-based suppliers
7. Give the names of blue Parts
8. Give the part number for parts weighting less than 20
9. Give details of parts supplied by S2
10. Give the color of parts supplied by S3
11. Where are the suppliers of P2 located
12. Get supplier numbers for suppliers who supply parts located in either Paris or London
13. Get part numbers for parts supplied by a supplier in the same city as the part
14. Get part numbers for parts based in London, supplied by a London supplier
15. Get supplier numbers for suppliers not supplying red parts

B. Based on the database, show the result relation in each case (15 marks)
1. result:= select S where status >"20"
2. Result:= project P over city
3. R1:= project S over S#, city
R2:=project P over P#, city
result:=join R1, R2 over city
C. Show the result relation for each step. You must show how the divide operation works
to get full marks (10 marks).
R0:=select P where Pname="CAM"
R1:= project R0 over P#
R2:=project SP over S#, P#

Result:= divide R2 by R1

Reference no: EM13936380

Questions Cloud

Discuss company marketing-business communication strategy : application to of best practice model to discuss current company marketing and business communication strategy -summary

Calculates and displays the body mass index : Write a Java application that calculates and displays the body mass index (BMI) for N people. N should be declared as a constant and should be equal to the largest digit of your student id number (e.g. if your student id is s0705544 then N should ..

Create ifstream and ofstream objects called infile n outfile : Create ifstream and ofstream objects called "infile" and "outfile" respectively. Include 4 functions for initializing, copying text, counting, and writing the results to a file, respectively.

How might you get a handle on customer reaction to strategy : How might you get a handle on customer reaction to the strategy? What steps should you take before considering whether to roll out this strategy?

Names and numbers of london-based suppliers : Give the relational algebra expression for the following English queries. 1. Get the supplier# who supply all the blue parts

Create a digital marketing plan for an existent company : Students will create a digital marketing plan for either an existent company of their choice, or for a fictitious company. The focus of the report should be placed on a particular product or an event.

Defiine an unsorted type adt : Postconditions: list1 contains all the items of list whose keys are less than or equal to item's key; list2 contains all the items of list whose keys are greater than item's key.

Explain the concept of integrated risk management : How would you explain the concept of integrated risk management to the Executive Committee of your bank? If you were to implement integrated risk management at your bank, what criteria would you be looking for?

Develop a branding strategy for your product : 1. Develop a branding strategy for your product that covers the brand name, logo, slogan, and at least one (1) brand extension.

User Account

All Pages