Given the following schema:

  • Staff (sid, sname)
  • Project (pid, pdesc, pfrom, pto)
  • Asset (aid, acat, adesc)
  • Workfor (sid, pid, wfrom, wto)
  • Assignment (aid, sid, pid, afrom, ato)

Note: The bold attributes are the keys.

Find the names of the staffs who worked or are working for more than one project, in Tuple Relational Calculus.

I was thinking of using count() but it is not allowed in TRC (or according to my Prof). Any answers appreciated.

  • 2
    "working for more than one project" = "working for two projects (or more)" = "working for two different projects". Does that help? – ypercubeᵀᴹ May 2 '18 at 10:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.