Advertisement
Guest User

Untitled

a guest
Aug 27th, 2016
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. group: grades dataset
  2. description[[ Dataset for some questions in Ex2
  3.  
  4. * the relation _Studied_ contains grades of sid per course
  5. * the relation _Course_ contains tid and room per course
  6. * the relation _Teacher_ contains name and department per teacher
  7. ]]
  8.  
  9. Studied = { sid course grade
  10. 1, db, 10
  11. 1, web, 7
  12. 1, se, 6.5
  13. 2, db, 4
  14. 2, web, 10
  15. 2, se, 9
  16. 2, ds, 9
  17. 2, prog,8.5
  18. 3, db, 8
  19. 3, web, 10
  20. 3, se, 9
  21. 3, ds, 9
  22. 3, prog,8.5
  23. 4, ds, 6.5
  24. 4, prog, 4
  25. }
  26.  
  27. Course = {
  28. course, tid, room
  29. db, 1, 3
  30. web, 2, 3
  31. se, 2, 3
  32. ds, 3, 2
  33. prog, 3, 1
  34. }
  35.  
  36. Teacher = {
  37. tid, name, dep
  38. 1, Albert, math
  39. 2, Girard, cs
  40. 3, Max, cs
  41. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement