Sample Header Ad - 728x90

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