SHARE
TWEET

Untitled

a guest Nov 12th, 2019 110 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. “Student”
  3.  
  4. Create “Student”
  5. Users can create new students. Students have an ID, name, age, active.
  6. “active” determines if the student is active or not (shows up in listings).
  7. IDs are unique among students.
  8.  
  9.  
  10. Read “Student”
  11. Users can show the details of existing students by entering their ID.
  12. All “Application” of student shows up here.
  13.  
  14.  
  15. Read “Students”
  16. Users can list the IDs and names of all students in the system.
  17.  
  18.  
  19. Update “Student”
  20. Users can update the details of existing students by first entering their ID and then the information (name, age) to be updated.
  21. IDs cannot be updated.
  22.  
  23.  
  24. Activate/Deactivate “Student”
  25. Users can activate/deactivate students by entering their ID.
  26.  
  27.  
  28. Delete “Student”
  29. Users can delete existing students by entering their ID.
  30. Students cannot be deleted if they have an existing “Application”.
  31.  
  32. ---------------------------------------------------------------------------------------------------------------------------
  33. “Company”
  34.  
  35. Create “Company”
  36. Users can create new companies. Companies have an ID, name.
  37. IDs and names of companies are unique amongst other companies.
  38.  
  39.  
  40. Read “Company”
  41. Users can show the details of existing companies by entering their ID.
  42. All “Position” of a company shows up here.
  43.  
  44.  
  45. Read “Companies”
  46. Users can list the IDs and names of all companies in the system.
  47.  
  48.  
  49. Update “Company”
  50. Users can update the details of existing companies by first entering their ID and then the information (name) to be updated.
  51. IDs cannot be updated.
  52. Company names can be updated, but they should stay unique.
  53.  
  54.  
  55. Delete “Company”
  56. Users can delete existing companies by entering their ID.
  57. Companies cannot be deleted if they have an existing “Position”.
  58.  
  59.  
  60. ---------------------------------------------------------------------------------------------------------------------------
  61. “Position”
  62.  
  63. Create “Position”
  64. Users can create new positions. A position has an ID, description, number of seats and a “Company ID”.
  65. Position IDs are unique amongst other positions.
  66. Descriptions cannot be empty.
  67. The number of seats must be greater than 0.
  68. Company ID must exist.
  69.  
  70.  
  71. Read “Position”
  72. Users can show the details of existing positions by entering their ID.
  73. “Students” already applied are shown here.
  74.  
  75.  
  76. Read “Positions”
  77. Users can list existing positions. All attributes of a position are visible plus it’s displayed how many seats are already taken (e.g 2/1, one out of two seats are taken).
  78.  
  79.  
  80. Update “Position”
  81. Users can update the details of existing positions by first entering their ID and then the information needs to be updated.
  82. Only the description can be updated, nothing else.
  83.  
  84.  
  85. Delete “Position”
  86. Users can delete existing positions by entering their ID.
  87. Positions cannot be deleted if they have an existing “Application”.
  88.  
  89.  
  90. ---------------------------------------------------------------------------------------------------------------------------
  91. “Application”
  92.  
  93. Create “Application”
  94. Users can create new applications. An application has an ID, an “accepted” field, a “Student ID” and a “Position ID”.
  95. IDs are unique amongst other applications.
  96. Student and Position IDs must exist.
  97. The “accepted” field stores whether the application was accepted by a company or not.
  98.  
  99.  
  100. Update “Application”
  101. Users can update existing applications by entering their ID.
  102. Only the “accepted” status can be changed.
  103.  
  104.  
  105. Delete “Application”
  106. Users can delete existing applications by entering their IDs.
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top