CSC/ECE 517 Fall 2017/E17AA Nomination for Badges: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 24: Line 24:
*Tables to be Modified
*Tables to be Modified
:· We’ll be creating a table named “badges”, with the following attributes:  
:· We’ll be creating a table named “badges”, with the following attributes:  
id: primary key
  id: primary key
name: varchar
  name: varchar
description: varchar
  description: varchar


:· We’ll be creating a table named “assignment_questionnaires_badges”, with the following attributes:  
:· We’ll be creating a table named “assignment_questionnaires_badges”, with the following attributes:  
Id: Primary key
  Id: Primary key
assignment_id: foreign key
  assignment_id: foreign key
questionnaire_id: foreign key
  questionnaire_id: foreign key
badge_id: foreign key
  badge_id: foreign key

Revision as of 04:09, 14 November 2017

Problem Statement

The purpose of the project is to implement a way to allow students to nominate badges to other students while reviewing their work. The professor should also be able to see the nominations to each student in a single page.

Pre-Conditions

These are the pre-conditions that needs to hold true for each functionality to work

· The maximum number of students that can be assigned to the project cannot be more then 1.
· For students to nominate badges, the professor must have provided a list of pre-decided badges possible for that project.
· For students to be able to nominate badged without justification only if the project does not have a mandatory justification requirement.

Implementation Steps

· Provide professors an option to add all possible badges to a project.
· Allow students to nominate badges while peer reviewing.
· Show a summary of all nominated badges to professor in a single page.

Modifications To Be Done

  • Files to be Modified
· Provide professors an option to add all possible badges to a project.
  • Tables to be Modified
· We’ll be creating a table named “badges”, with the following attributes:
  id: primary key
  name: varchar
  description: varchar
· We’ll be creating a table named “assignment_questionnaires_badges”, with the following attributes:
  Id: Primary key
  assignment_id: foreign key
  questionnaire_id: foreign key
  badge_id: foreign key