How do I go about writing the relational algebra for this SQL query?
Select p.name, p.ward, m.name, p.quantity, f.frequency
From patient, medicine, prescription
Where frequency = "3perday" AND p.end-date="08-06-2010" AND canceled = "Y".
views:
154answers:
1
+1
A:
Educated guess: Maybe you write out all the p's, f's and m's to their actual meaning, i.e. patient or prescription instead of p and so on. But really don't understand what the problem is unless you tell us...
Andreas
2010-06-20 22:16:10
sorry, i tried to know how to write an relational algebra of that sql query
tike
2010-06-20 22:34:07
Since this topic is closed it might be convenient to ask for reopen or start a new topic.
Andreas
2010-06-20 22:38:17
It has 2 reopen votes. Needs another 3. @tike Can you edit the question to supply the columns for patient, medicine, and prescription
Martin Smith
2010-06-20 22:41:01