Changes between Initial Version and Version 1 of RelationalDesign

Timestamp:

12/07/22 15:06:18 (3 years ago)

Author:

201060

Comment:

--

RelationalDesign

@@ +1 @@
+= Логички и физички дизајн
+
+=== Релациска шема (со мапирачка трансформација)
+
+•       ''Primary key: __Underline__''
+•       ''Foreign key: *''
+•       ''not null: **Bold**''
+
+
+----
+
+•       User(__**userID**__, fullName, **username**, **password**)
+
+•       Administrator(__**userID__*(user)**)
+
+•       Moderator(__**userID__*(user)**)
+
+•       QuizTaker(__**userID__*(user)**, tournamentID*(tournament), tournamentPhaseID*(tournament Phase))
+
+•       Tournament Organizer(__**userID__*(user)**, **tournamentID***(tournament))
+
+•       Tournament(__**tournamentID**__, **tournamentName**)
+
+•       Tournament Phase(__**tournamentPhaseID**__, **tournamentID***(tournament), **tournamentPhaseName**)
+
+•       Subject(__**subjectID**__, **name**)
+
+•       Category(__**categoryID**__, name, **subjectID***(subject))
+
+•       Quiz(__**quizID**__, **categoryID***(category), **quizName**, tournamentPhaseID*(tournament Phase))
+
+•       Medal(__**medalID**__, **userID***(user), **tournamentID***(tournament), **medalName**, **description**)
+
+•       Question(__**questionID**__, **questionText**, **quizID***(quiz))
+
+•       Hint(__**hintID**__, **hintText**, **questionID***(question))
+
+•       Text Question(__**questionID**__*(question))
+
+•       Selection Question(__**questionID**__*(question))
+
+•       Choice(__**choiceID**__, **questionID***(question), **isCorrect**, **choiceText**)
+
+•       Selected Choice(__**choiceID**__*(choice))
+
+•       Attempt(__**attemptID**__, **userID***(user), **attemptDate**, **quizID***(quiz))
+
+•       Result(__**resultID**__, **attemptID***(attempt), **points**)
+
+•       Badge(__**badgeID**__, **badgeName**, **description**, **resultID***(result))
+
+•       quiz_is_part_of_tournament(__**quizID**__*(quiz), __**tournamentID**__*(tournament))
+
+•       tournamentOrganizer_hosts _tournament(__**userID**__*(user), __**tournamentID**__*(tournament))
+
+•       question_is_part_of_quiz(__**questionID**__*(question), __**quizID**__*(quiz))
+
+•       quizTaker_participates_in_tournament(__**userID**__*(user), __**tournamentID**__*(tournament))
+
+•       quizTaker_participates_in_tournamentPhase(__**userID**__*(user), __**tournamentPhaseID**__*(tournament Phase))
+
+•       medal_is_awarded_to_quizTaker(__**medalID**__*(medal), __**userID**__*(user))
+