Proposed Solution

Proposed Solution

1. Data Filter

   • Data Managed
     • Peak Direction - Direction, (Int, NOT NULL)
     • Hs - Significant wave height, (Int, NOT NULL)
     • Hmax - The maximum wave height (Int, NOT NULL)
     • SST - Approximation of sea surface temperature (Int, NOT NULL)
     • Date of recorded wave (Date, NOT NULL)
     • Time of Recorded Wave,(Int, NOT NULL)
   • Useability Principle
     • Safety
     • Accessibility
     • Effectiveness
     • Utility
   • Purpose
     • The data filter will allow users greater utility of the proposed solution since it allows them to filter out where and when to surf base on their preference of wave conditions along with geographical location and time avaliablity
   • Requirements
     • Prompts an error message if the user inputs invalid data
     • Gives user a message if there are no locations that match or meet the requirements put in
     • Allow users to filter through different types of data (refer to data managed) and give them a location and that best matches their criteria
     • Allow users to bookmark and send (email) locations and times they have found/filtered through

2. Data

   • Types
     • INT
       • A medium integer. Signed range is from -2147483648 to 2147483647. Unsigned range is from 0 to 4294967295. The size parameter specifies the maximum display width (which is 255)
       • 1008200601
     • VARCHAR
       • A VARIABLE length string (can contain letters, numbers, and special characters). The size parameter specifies the maximum column length in characters - can be from 0 to 65535
       • "Andy is OwO"
     • DATE
       • A date. Format: YYYY-MM-DD. The supported range is from '1000-01-01' to '9999-12-31'
       • YYYY-MM-DD.
   • Constraints
     • UNIQUE
       • The UNIQUE constraint ensures that all values in a column are different.
     • PRIMARY KEY
       • The PRIMARY KEY constraint uniquely identifies each record in a table. Primary keys must contain UNIQUE values, and cannot contain NULL values.
     • SECONDARY KEY
       • The FOREIGN KEY constraint is used to prevent actions that would destroy links between tables. A FOREIGN KEY is a field (or collection of fields) in one table, that refers to the PRIMARY KEY in another table.
     • NOT NULL
       • This enforces a field to always contain a value, which means that you cannot insert a new record, or update a record without adding a value to this field.

3. Other Utilities

   • Login Page
     • Useability Principle
       • Utility
       • Accessibility
       • Safety
       • Effectiveness
     • Requirements
       • Allows user to remember their login details, after a successful login
       • Prompts an error message if the user inputs invalid or overlapping data
       • Redirects the user to Homepage, after successful sign up
     • Purpose
       • The login page enables a user to gain access to an application by entering their username and password or authenticating through the application login.
     • Data Managed
       • Password (Varchar, NOT NULL)
       • Email (varchar, NOT NULL, UNIQUE)
       • Username (varchar, NOT NULL, UNIQUE)
       • Phone number (Int, NOT NULL, UNIQUE)
   • Sign Up Page
     • Requirements
       • Redirects the user to Homepage, after successful sign up
       • Prompts an error message if the user inputs invalid or overlapping data
       • Allows user to remember their login details, after a successful sign up
       • Alerts user about successful sign up with email or phone number
     • Useability Principle
       • Effectiveness
       • Safety
       • Utility
       • Accessibility
       • Learnability
     • Data Managed
       • Phone number (Int, NOT NULL, UNIQUE)
       • Email (varchar, NOT NULL, UNIQUE)
       • Password (Varchar, NOT NULL)
       • First Name (varchar, NOT NULL)
       • Last Name (varchar, NOT NULL)
       • Date of Birth (Date, NOT NULL)
       • Username (varchar, NOT NULL, UNIQUE)
     • Purpose
       • A signup page (also known as a registration page) allows users and organisations to register and gain access to the application on their own.
   • Setting Page
     • Data Managed
       • Password (Varchar, NOT NULL)
       • Phone number (Int, NOT NULL, UNIQUE)
       • Email (varchar, NOT NULL, UNIQUE)
       • Username (varchar, NOT NULL, UNIQUE)
       • First Name (varchar, NOT NULL)
       • Last Name (varchar, NOT NULL)
       • Date of Birth (Date, NOT NULL)
     • Purpose
       • Allowing users to modify their data ensures that if they change certain data points, the system will recall current data rather than invalid and outdated data.
     • Useability Principle
       • Learnability
       • Accessibility
       • Effectiveness
       • Safety
       • Utility
     • Requirements
       • Prompts an error message if the user inputs invalid or overlapping data
       • Alerts user about successful modifications with email or phone number
       • Redirects the user to Homepage, after successful sign up
       • Logs and updates data when the user modifies data
   • Content Page
     • Useability Principle
       • Utility
       • Accessibility
       • Effectiveness
       • Safety
     • Data Managed
       • Bookmarked Locations (along with the time, if it was marked) (varchar, NOT NULL)
       • Content, URLS and video files (varchar, NOT NULL)
       • Bookmarked Articles and Videos (varchar, NOT NULL)
       • Friend List (varchar, NOT NULL)
     • Purpose
       • Allows new and upcoming surfers to learn more about surfing and surfing related content through online articles and videos made by others surfers or surf companies/magazines
     • Requirements
       • Allow users to bookmark and send (email) articles, videos or other contents they have found
       • Allow users to search for specific surfing content (specific videos or articles)
       • Allow users to view surfing related content directly from the proposed solution
       • Gives user a message if there are no articles that meet with what the user typed in