Changes between Version 2 and Version 3 of RelationalDesign
- Timestamp:
- 12/07/22 15:21:10 (2 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v2 v3 12 12 • User(__**userID**__, fullName, **username**, **password**) 13 13 14 • Administrator(__**userID__* (user)**)14 • Administrator(__**userID__***(user)) 15 15 16 • Moderator(__**userID__* (user)**)16 • Moderator(__**userID__***(user)) 17 17 18 • Quiz Taker(__**userID__*(user)**, tournamentID*(tournament), tournamentPhaseID*(tournament Phase))18 • Quiz Taker(__**userID__***(user), tournamentID*(tournament), tournamentPhaseID*(tournament Phase)) 19 19 20 • Tournament Organizer(__**userID__* (user)**, **tournamentID***(tournament))20 • Tournament Organizer(__**userID__***(user), **tournamentID***(tournament)) 21 21 22 22 • Tournament(__**tournamentID**__, **tournamentName**) … … 26 26 • Subject(__**subjectID**__, **name**) 27 27 28 • Category(__**categoryID**__, name, **subjectID***(subject))28 • Category(__**categoryID**__, **name**, **subjectID***(subject)) 29 29 30 30 • Quiz(__**quizID**__, **categoryID***(category), **quizName**, tournamentPhaseID*(tournament Phase))