CRUD

CRUD

1. Scope of the Problem

   • Problem
     • Students struggle to balance school with their personal lives, failing to track their upcoming assignments, assessments, and deadlines throughout the school year. Hence, student are often overwhelmed and fail to hand in their best completed work
   • Stakeholders
     • Organisations
       • School
     • Users
       • Teachers
       • Students
   • Objective
     • Create an application that allows students to create, read, update and delete entries about upcoming events on their schedule

2. Constraints and Limitations

   • Technical Constraints
     • Hardware and Software Compatibility: Cross-platform access across different devices
     • Data Processing: Handle hundreds of users using the application without crashing
     • Bandwidth: Work on both highand low-speed internet
   • Budget Constraints
     • Development: Limited to open-source tools and frameworks
   • Time Constraints
     • Timeline: Complete the assignment within four weeks
   • Legal Constraints
     • Security: Protecting private information from unauthorised access
     • Data Protection: Adhered to the Australian Privacy Law
   • Ethical Constraints
     • Accessibility: Offering options for individuals with impairments to customise their choices
     • Consent: Obtaining permission before storing or sharing information
     • Data Privacy: Protecting personal information from unauthorised access

3. Programming Requirements

   • Languages
     • Python
     • HTML
     • CSS
   • Framework
     • Flask
   • Security
     • Secure system for logins and sign-ups

4. System Requirements

   • Operating Systems
     • Windows
     • macOS
     • Linux

5. Data Requirements

   • User ID
     • Integer
     • Primary Key
   • Last Name
     • Varchar
     • Not Null
   • First Name
     • Varchar
     • Not Null
   • Email
     • Varchar
     • Not Null
   • Password
     • Varchar
     • Not Null
   • Entry ID
     • Integer
     • Primary Key

6. Impact of Storage Data

   • Personal Impact
     • Data Privacy
       • Students’ personal information, assignment details, and uploaded resources must be stored securely to protect against unauthorised access.
     • Organisation
       • Secure and structured storage allows students to keep everything in one place, supporting better time management and less anxiety about losing important files.
   • Social Impact
     • Ethical Consideration
       • Data must be used only for its stated purpose
     • Surveillance
       • Ensure there is no unnecessary tracking of students' behaviour or personal life beyond what is needed for the application’s functionality.
     • Data Ownership
       • State that the information belongs to the student and no other parties unless given consetn
   • Economic
     • Storage
       • Minimise hosting costs by using efficient database solutions

7. Criteria

   • Self-Determined Criteria
     • Provide a platform for students to order and organise their task
       • The application must allow users to organise and order their tasks to help them balance their academic and personal life.
       • The application must allow users to view, create, delete, or edit entries, with the ability to attach files.
       • The application must be simple and intuitive.
   • Success Criteria
     • SC1: Meet all Coded Components & Data Requirements
       • Incorporate a login and signup feature that allows multiple users
       • User can enter details that are relevant into a HTML form
       • Store and display HTML form data in an external database
       • Store and display images
       • Edit and Delete records
       • Programmed components must differ from exemplar
     • - SC2: Meet all User Interface Requirements

8. User Interface

   • Layout
     • Navigation Bar
     • Minimal and Modern Design
     • Clean Colour Scheme
     • Simple shapes
   • Colours and Fonts
     • Roboto
     • Red and White
     • High-Contrast
   • Interactive Elements
     • Butoons
       • Add
       • Delete
       • Edit
       • View
       • Sign Up
       • Log Ins
     • Form
       • Sign Up
       • Login
       • Add
       • Edit
     • Feedback
       • Confirmation Message