Consider the Supplier Parts Catalog schema from the previous question State what the following queries compute 1 sname(sid((color 'red ' Parts) (cost 100Catalog)) Suppliers) 2 sname(sid((color 'red ' Parts) (cost 100Catalog) Suppliers)) 3 (sname((color 'red ' Parts) (cost 100Catalog) Suppliers)) (sname((color 'green ' Parts) (cost 100Catalog) Suppliers)) 4 (sid((color 'red ' Parts) (cost 100Catalog) Suppliers)) (sid((color 'green ' Parts) (cost 100Catalog) Suppliers)) 5 sname((sid,sname((color 'red ' Parts) (cost 100Catalog) Suppliers)) (sid,sname((color 'green ' Parts) (cost 100Catalog) Suppliers)))

Question: Consider the Supplier-Parts-Catalog schema from the previous question. State what the following queries compute: 1. sname(sid((color = 'red' Parts) (cost <100Catalog)) Suppliers) 2.

Consider the Supplier-Parts-Catalog schema from the previous question. State what the following queries compute:
1. πsname(πsid((σcolor = 'red' Parts) ⪻⪼ (σcost<100Catalog)) ⪻⪼ Suppliers)
2. πsname(πsid((σcolor = 'red' Parts) ⪻⪼ (σcost<100Catalog) ⪻⪼ Suppliers))
3. (πsname((σcolor = 'red' Parts) ⪻⪼ (σcost<100Catalog) ⪻⪼ Suppliers)) ∩
(πsname((σcolor = 'green' Parts) ⪻⪼ (σcost<100Catalog) ⪻⪼ Suppliers))
4. (πsid((σcolor = 'red' Parts) ⪻⪼ (σcost<100Catalog) ⪻⪼ Suppliers)) ∩
(πsid((σcolor = 'green' Parts) ⪻⪼ (σcost<100Catalog) ⪻⪼ Suppliers))
5. πsname((πsid,sname((σcolor = 'red' Parts) ⪻⪼ (σcost<100Catalog) ⪻⪼ Suppliers)) ∩
(πsid,sname((σcolor = 'green' Parts) ⪻⪼ (σcost<100Catalog) ⪻⪼ Suppliers)))

Step by Step Solution

★★★★★

3.59 Rating (170 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The statements can be interpreted as 1 Find the Supplier names of the suppliers ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

960-C-S-D (2430).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Consider the following BCNF relation, which lists the ids, types (e.g., nuts or bolts), and costs of various parts, along with the number available or in stock: Parts (pid, pname, cost, num avail)...

The following relations keep track of airline flight information: Flights (flno: integer, from: string, to: string, distance: integer, departs: time, arrives: time, price: real) Aircraft (aid:...

Consider the following BCNF relational schema for a portion of a company database (type information is not relevant to this question and is omitted): Project(pno, proj name, proj base dept, proj mgr,...

Exercise 4.4 Consider the Supplier-Parts-Catalog schema from the previous question. State what the following queries compute: 1. sname(nsid(ocolor-red' Parts) XI (O'cost) x1 Suppliers) 2....

Consider the Supplier-Parts-Catalog schema from the previous question. State what the following queries compute: Give the number of tuples in each table after the cross product and before the...

Consider the following schema: SUPPLIERS (SID: integer, SNAME: string, STREET: string, CITY: string, ZIP: string) PARTS (PID: integer, PNAME: string, COLOR: string) CATALOG (SID: integer, PID:...

CIS 631: DATA MANAGEMENT SYSTEMS DESIGN ASSIGNMENT 1 Consider the following schema: SUPPLIERS (SID: integer , SNAME: string, STREET: string, CITY: string, ZIP: string) PARTS (PID: integer , PNAME:...

Answer questions 2 and 4 Exercise 4.4 Consider the Supplier-Parts-Catalog schema from the previous ques tion. State what the following queries compute: 1. 8name(nsid(ocolor-'red, Parts)...

Consider the following schema: SUPPLIERS (SID: integer, SNAME: string, STREET: string, CITY: string, ZIP: string) PARTS (PID: integer, PNAME: string, COLOR: string) CATALOG (SID: integer, PID:...

12. Record keeping, payroll, and simple inventory problems are examples of a structured b. semistructured e unstructured d. pseudostructured decisions. 3. Which of the following functions is...

In the figure above, A=46, B-38, C-20, D=19, E-22.6, F=25.6, G=28.6, H=33.2. If the government auctioned off the quota licenses, what's the maximum revenue they could raise? Round to two decimal...

Question 1 7 5 pts The forward rate premium reflects the percentage by which the spot rate exceods the forwasd rate oe in annualized batin. True fAlse

Deflation is a (an) a. increase in most prices. b. decrease in the general price level. c. situation that has never occurred in U.S. history. d. decrease in the inflation rate.

Name some entities and attributes in an insurance company environment.

What is a relational query optimizer? Why are they important?

How do relational query optimizers work?

This question is about I/O redirection and pipes on the command-line. Explain what each of the following possible command-lines means. In each problem, you need to associate an appropriate meaning to...

8. Cash flow patterns and the modified rate of return calculation Blue Elk Manufacturing is analyzing a project with the following cash flows: This project has cash flows. Blue Elk Manufacturing's...

PRINTER VERSION BACK NEXT Brief Exercise 26-8 Viera Corporation is considering investing in a new facility. The estimated cost of the facility is $1,762,478. It will be used for 12 years, then sold...