code_junkie

Is my Relational Algebra correct?

Nov 13th, 2011
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. RESULT <-- PROJECT<STUDENT.FirstName, STUDENT.LastName, STAFF.FirstName,
  2. STAFF.INCIDENT.LastName, INCIDENT.DateTimeReported,
  3. INCIDENT.NatureOfIllness(SELECTINCIDENT.DecisionMade =
  4. ''(Staff RIGHT JOIN<STAFF.StaffID = INCIDENT.StaffID>
  5. (INCIDENT LEFT JOIN<INCIDENT.StudentID = STUDENT.StudentID>(STUDENT))))
  6.  
  7. SELECT
  8. s.FirstName, s.LastName, st.FirstName, st.LastName
  9. , i.DateTimeReported, i.NatureOfIllness
  10. FROM Student s
  11. RIGHT JOIN Incident i ON s.StudentID = i.StudentID
  12. LEFT JOIN Staff st ON st.StaffID = i.StaffID
  13. WHERE i.DecisionMade = ''
  14.  
  15. RESULT <---
  16. PROJECT <STUDENT.FirstName, STUDENT.LastName,
  17. STAFF.FirstName, STAFF.LastName,
  18. INCIDENT.DateTimeReported, INCIDENT.NatureOfIllness>
  19. (SELECT <INCIDENT.DecisionMade = ''>
  20. ((STUDENT RIGHT JOIN <STUDENT.StudentID = INCIDENT.StudentID> INCIDENT)
  21. LEFT JOIN <INCIDENT.StaffID = STAFF.StaffID> STAFF)
  22.  
  23. SELECT s.FirstName, s.LastName, st.FirstName, st.LastName, i.DateTimeReported, i.NatureOfIllness
  24. FROM Incident i
  25. LEFT JOIN Student s ON s.StudentID = i.StudentID
  26. LEFT JOIN Staff st ON st.StaffID = i.StaffID
  27. WHERE i.DecisionMade = ''
Add Comment
Please, Sign In to add comment