= Логички и физички дизајн

=== Релациска шема (со мапирачка трансформација)

•	''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))