Counting in Tuple Relational Calculus
3
votes
0
answers
936
views
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.
Asked by Kyoma
(131 rep)
May 2, 2018, 09:56 AM
Last activity: May 2, 2018, 02:05 PM
Last activity: May 2, 2018, 02:05 PM