CRUD Application

CRUD Application

1. Task Requirements

   • Existing Solutions
     • EXEMPLAR CRUD
       • Has a working login
       • Has a working sign-up
   • Prescribed Criteria
     • Requires a successful login before retrieving and displaying the users personal account information
     • Ensure data entered by the user is validated before it is added to the database
     • Meet all Data Requirements
     • Meet all User Interface Requirements
   • Self Determined Criteria
     • Show achievements made on games
     • Show hours played on a game

2. Impacts

   • Social
     • People who need a place to store game data will be happy
   • Economic
     • Could add competition to the gaming industry
   • Personal
     • Cheryl gets what she wants
     • Geoff gets what he wants

3. Developer Problem

   • User interface
     • Features
       • Login
       • Signup
       • Display games
         • Delete games
         • Update games
   • Data
     • User database
       • First name
         • Varchar
           • 255
       • Last name
         • Varchar
           • 255
       • email
       • Date of birth
         • Integer
           • 100
       • User ID
         • Integer
           • 100
       • Password
         • Varchar
           • 255
     • Games database
       • Game name
         • Varchar
           • 255
       • Time played
         • Integer
           • 100
       • Achievements
         • varchar
           • 255
       • Game ID
         • Integer
           • 100
       • Last played
         • Integer
           • 100
   • Usability principles
     • Safety
     • Accessibility
     • Utility
     • Effectiveness
     • Learnability

4. User Problem

   • User persona
     • Cheryl
       • Wants
         • To keep her cognitive skills sharp
       • Needs
         • Store gaming data, as she keeps forgetting
         • Simple application
     • Geoff
       • Wants
         • To store achievements and how close he is to completing the game
       • Needs
         • Easy to use interface for easy recording of data