Question

consider the following table supplier (sid, sname, address). parts (pis, pname, colour). catlog(sid, pid, log).
find the name of supplier who supply motor belt​

Answer 1

The database consists of Suppliers(sId,sName,address), Parts(pID,pName,color), and Catalog(sId,pId,cost). The solution to this question is given to be

The database consists of Suppliers(sId,sName,address), Parts(pID,pName,color), and Catalog(sId,pId,cost). The solution to this question is given to be

The database consists of Suppliers(sId,sName,address), Parts(pID,pName,color), and Catalog(sId,pId,cost). The solution to this question is given to beHowever, this seems wrong to me since then we are actually looking for suppliers that supply every red and green part. Am I just interpreting the logic

In Relational Algebra when ever we have to find sids,sname etc. and have the word 'every' in the question we use division method . In your question you have to find 'sids' which supply every red or green part. Now as 'color' is in "part" relation and sid is in "catalog" and "suppliers" relation but we can only connect part and catalog using pid and fortunately sid is in catalog so we will use these two relations form our relational algebra :

Answer 2

But only at first glance, because the interior of a ContiTech Timing Belt contains a lot of high-tech. Timing Belts. Fiber-glass tensile members provide excellent ..Parts(pid, pname, color). Catalog(sid, pid, cost). Write relational algebraic expression or SQL queries for the following : i) Find names of suppliers who supply ...Course)

Course)c) The following table gives the ordinates of a direct - runoff hydrograph resulting from two ... c) Explain selection of V belt from manufacturers catalogue. [6].