Changes between Version 10 and Version 11 of RelationalDesign

Timestamp:

12/13/22 15:00:38 (2 years ago)

Author:

201100

Comment:

--

RelationalDesign

@@ -18 +18 @@
 •       Quiz Taker(__**userID__***(user))
 
-•       Tournament Organizer(__**tournamentOrganizerID__**, __**userID__***(moderator))
+•       Tournament Organizer(__**tournamentOrganizerID__**, __**userID__***(moderator), **tournamentID***(tournament))
 
 •       Tournament(__**tournamentID**__, **tournamentName**)
@@ -28 +28 @@
 •       Category(__**categoryID**__, **name**, **subjectID***(subject))
 
-•       Quiz(__**quizID**__, **categoryID***(category), **quizName**, tournamentID*(tournament), tournamentPhaseID*(tournament Phase))
+•       Quiz(__**quizID**__, **categoryID***(category), **quizName**, tournamentPhaseID*(tournament Phase))
 
 •       Medal(__**medalID**__, **tournamentID***(tournament), **medalName**, **description**)
@@ -40 +40 @@
 •       Selection Question(__**questionID**__*(question))
 
-•       Choice(__**choiceID**__, **questionID***(question), **isCorrect**, **choiceText**)
+•       Choice(__**choiceID**__, **questionID***(selectionQuestion), **isCorrect**, **choiceText**)
 
 •       Selected Choice(__**selectedChoiceID**__, __**choiceID**__*(choice), **attemptID***(attempt))
@@ -60 +60 @@
 •       quizTaker_participates_in_tournamentPhase(__**userID**__*(quizTaker), __**tournamentPhaseID**__*(tournament Phase))
 
-•       medal_is_awarded_to_quizTaker(__**medalID**__*(medal), __**userID**__*(user))
+•       medal_is_awarded_to_quizTaker(__**medalID**__*(medal), __**userID**__*(quizTaker))
 
-•       badge_is_awarded_to_quizTaker(__**badgeID**__*(medal), __**userID**__*(user))
+•       badge_is_awarded_to_quizTaker(__**badgeID**__*(medal), __**userID**__*(quizTaker))