Changes between Version 3 and Version 4 of RelationalDesign

Timestamp:

12/07/22 16:19:33 (2 years ago)

Author:

201100

Comment:

--

RelationalDesign

@@ -18 +18 @@
 •       Quiz Taker(__**userID__***(user), tournamentID*(tournament), tournamentPhaseID*(tournament Phase))
 
-•       Tournament Organizer(__**userID__***(user), **tournamentID***(tournament))
+•       Tournament Organizer(__**userID__***(moderator), **tournamentID***(tournament))
 
 •       Tournament(__**tournamentID**__, **tournamentName**)
@@ -30 +30 @@
 •       Quiz(__**quizID**__, **categoryID***(category), **quizName**, tournamentPhaseID*(tournament Phase))
 
-•       Medal(__**medalID**__, **userID***(user), **tournamentID***(tournament), **medalName**, **description**)
+•       Medal(__**medalID**__, **userID***(quizTaker), **tournamentID***(tournament), **medalName**, **description**)
 
 •       Question(__**questionID**__, **questionText**, **quizID***(quiz))
@@ -44 +44 @@
 •       Selected Choice(__**choiceID**__*(choice))
 
-•       Attempt(__**attemptID**__, **userID***(user), **attemptDate**, **quizID***(quiz))
+•       Attempt(__**attemptID**__, **userID***(quizTaker), **attemptDate**, **quizID***(quiz))
 
 •       Result(__**resultID**__, **attemptID***(attempt), **points**)
@@ -52 +52 @@
 •       quiz_is_part_of_tournament(__**quizID**__*(quiz), __**tournamentID**__*(tournament))
 
-•       tournamentOrganizer_hosts _tournament(__**userID**__*(user), __**tournamentID**__*(tournament))
+•       tournamentOrganizer_hosts _tournament(__**userID**__*(tournamentOrganizer), __**tournamentID**__*(tournament))
 
 •       question_is_part_of_quiz(__**questionID**__*(question), __**quizID**__*(quiz))
 
-•       quizTaker_participates_in_tournament(__**userID**__*(user), __**tournamentID**__*(tournament))
+•       quizTaker_participates_in_tournament(__**userID**__*(quizTaker), __**tournamentID**__*(tournament))
 
-•       quizTaker_participates_in_tournamentPhase(__**userID**__*(user), __**tournamentPhaseID**__*(tournament Phase))
+•       quizTaker_participates_in_tournamentPhase(__**userID**__*(quizTaker), __**tournamentPhaseID**__*(tournament Phase))
 
 •       medal_is_awarded_to_quizTaker(__**medalID**__*(medal), __**userID**__*(user))