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

Answers: 1

Show answers

Another question on Engineering

Engineering, 03.07.2019 15:10

Ahouse has the following electrical appliance usage (1) single 40w lamp used for 4 hours per day (2) single 60w fan used for 12 hours per day (3) single 200w refrigerator that runs 24 hours per day with compressor run 12 hours and off 12 hours find the solar power inverter size in watt with correction factor of 1.25.

Answers: 1

Answer

Engineering, 04.07.2019 18:10

Steel is coated with a thin layer of ceramic to protect against corrosion. what do you expect to happen to the coating when the temperature of the steel is increased significantly? explain.

Answers: 1

Answer

Engineering, 04.07.2019 18:10

Afour cylinder four-stroke in-line engine has a stroke of 160mm, connecting rod length of 150mm, a reciprocating mass of 3kg and its firing order is 1-3-4-2. the spacing between cylinders is 100mm. i. show that the engine is in balance with regard to the primary inertia forces and primary 3. a and secondary inertia couples. li determine the out of balance secondary inertia force ii. propose ways of balancing this out of balance force and discuss the challenges that will arise

Answers: 3

Answer

Engineering, 04.07.2019 18:10

Aplate clutch has a single pair of mating friction surfaces 250-mm od by 175-mm id. the mean value of the coefficient of friction is 0.30, and the actuating force is 4 kn. a) find the maximum pressure and the torque capacity using the uniform-wear model. b) find the maximum pressure and the torque capacity using the uniform-pressure model.

Answers: 3

Answer

You know the right answer?

Consider the following schema:Suppliers (sid: integer, sname: varchar, address: varchar)Parts (pid:...

Questions