subject
Engineering, 25.03.2020 21:09 volocibel

Consider the following schema:Suppliers (sid: integer, sname: varchar, address: varchar)Parts (pid: integer, pname: varchar, color: varchar)Catalog (sid: integer, pid: integer, cost: real)Where sid is the supplier’s id (primary key in Suppliers), pid is the part’s id (primary key in Parts), and sid together with pid is the primary key of Catalog. The Catalog relation lists the prices charged for parts by Suppliers. A) Write the following queries using relational algebra:5 Find the sids of suppliers who supply every part6. Find the sids of suppliers who supply every red part7. Find the sids of suppliers who supply every red or green part.8. Find the sids of suppliers who supply every red part or supply every green part

ansver
Answers: 1

Another question on Engineering

question
Engineering, 04.07.2019 18:10
Calculate the bore of a cylinder that has a stroke of 18 inches and an extension time of 6 seconds at a flow rate of 4 gal/min.
Answers: 3
question
Engineering, 04.07.2019 18:20
Asolid cylinder is concentric with a straight pipe. the cylinder is 0.5 m long and has an outside diameter of 8 cm. the pipe has an inside diameter of 8.5 cm. the annulus between the cylinder ad the pipe contains stationary oil. the oil has a specific gravity of 0.92 and a kinematic viscosity of 5.57 x 10-4 m2/s. most nearly, what is the force needed to move the cylinder along the pipe at a constant velocity of 1 m/s?
Answers: 3
question
Engineering, 04.07.2019 18:20
Avolume of 2.65 m3 of air in a rigid, insulated container fitted with a paddle wheel is initially at 264 k, 5.6 bar. the air receives 432 kj by work from the paddle wheel. assuming the ideal gas model with cv = 0.71 kj/kg • k, determine for the air the amount of entropy produced, in kj/k
Answers: 2
question
Engineering, 04.07.2019 19:20
Amass-spring-viscous damper system of mass 3 kg has a frequency of 100 rad/s and is critically damped. its initial conditions are x(0)-3 mm and (0)-2.3 m/s. does the system overshoot its equilibrium position? prove your answer
Answers: 1
You know the right answer?
Consider the following schema:Suppliers (sid: integer, sname: varchar, address: varchar)Parts (pid:...
Questions
question
Mathematics, 11.10.2019 01:00
Questions on the website: 13722360