Input, Processes and OutPut
In this section I will be looking at the outputs required from the system and then establishing the required input and the processing that needs to take place in order to achieve those outputs. The table below shows how this will work.
Inputs Processes Output
Login Page – Login Function
Username entered in textbox
Password Entered in textbox
Go button click
Login Function
Data posted to server
Server connects to MySQL Database
Username and password is match to corresponding row
If math found, check if user is activated[1]
If activated user is authenticated[2] else authentication fails[3]
[1]message is displayed saying user is not activated
[2]if authenticated, user is redirected to main planning page
[3]If authentication fails, exception is thrown stating
“username or password is not valid”
Registration page – Register Function
Username entered in textbox
Password entered in textbox
Email address entered in textbox
First name entered in textbox
Last name entered in textbox
Type of school entered in textbox
Register Function
Data is posted to the server
Email is check if it is a dubaibritishschool.ae email. [1]
Email is check in the database to see if it has been registered or not [2]
User is registered by entering their details in the database using SQL including their GUID
[1]Exception is thrown stating user is not eligible to register using the current email
[2]Exception is thrown stating user is already registered
[3]Email is sent with activation link with users guid in the query string and message is displayed stating user is now registered
Registration page – activation function
The registration page is visited with the GUID(Globally unique identifier) in the URL
activation function
GUID is extracted form URL and compared with row matching the GUID.
If match found, user is then activated
activation function
user is sent a message stating he/she is now activated
user is the redirect
28
Shresth Bhatnagar Contact US – Send message function Anonymous enters their first name and last name, email and massage
They hit the submit button
Send message function
Server checks if any fields are blank[1]
Server stores message in database using SQL
Server generate email message
Send message function
[1]error is displayed telling the users to fill In the missing fields
I and My client; Mr.Wood are emailed the message
Frequently asked questions page
Users visits page
Frequently asked questions page
Databases is queried using SQL for all the FAQ inserted
Frequently asked questions page Question list is displayed
Main Planner page
User requests the webpage from the server by visiting it
User then selects the subject and year grade
Main Planner page
Checks if user is authenticated [1]
Queries database for planned lesson written by the user for the selected year grade and
subject
Server list planned lessons, and lessons out come if any and post them back to the client.
Main Planner page Lesson planned displayed
Main Planner page – add lesson Function
User type lesson info; title, plan, date, time, additional notes
User then hits submit button to post information
add lesson Function
Server does Validation and verification to check
If data was inserted
If Time entered was in the future
Server grabs data and processes it to store it database.
add lesson Function
page is refreshed to display the newly added planned information
29
Shresth Bhatnagar Main Planner page – delete lesson Function User selects lesson plan from list of lesson plans
User clicks on delete button
delete lesson Function
Server gets lesson plan id from a hidden field
Server uses that ID by inserting it into a SQL delete statement
Server execute the delete statement
delete lesson Function
Lesson plan is deleted in the list
Confirmation message is displayed that the lesson is deleted
Main Planner page – edit lesson Function
User selects lesson plan from list of lesson plans
User clicks on edit button
edit lesson Function
Server gets lesson plan id from a hidden field
Server uses that ID and changes by inserting it into a SQL update statement
Server execute the update statement
edit lesson Function
Lesson plan is updated in the list
Confirmation message is displayed that the lesson is updated
Main Planner page – add lesson outcome Function
User type lesson info; title, plan, date, time, additional notes
User then hits submit button to post information
add lesson outcome Function
Server does Validation and verification to check
If data was inserted
If Time entered was in the future
Server grabs data and processes it to store it database.
add lesson outcome Function The lesson outcome is displayed
30
Shresth Bhatnagar Main Planner page – delete lesson outcomeFunction
User selects lesson outcome plan from list of lesson outcomes
User clicks on delete button
delete lesson outcome Function
Server gets lesson plan id from a hidden field
Server uses that ID by inserting it into a SQL delete statement
Server execute the
delete lesson outcome Function Lesson outcome is deleted in the list
Confirmation message is displayed that the lesson outcome is deleted
Main Planner page – edit lesson outcome Function
User selects lesson outcome from list of lesson plans
User clicks on edit button
edit lesson outcome Function
Server gets lesson plan id from a hidden field
Server uses that ID and changes by inserting it into a SQL update statement
Server execute the update statement
edit lesson outcome Function Lesson outcome is updated in the list
Confirmation message is displayed that the lesson is updated
31
Process Flow Diagram
This diagram illustrates the process that is involved when a signs in and access a restricted resource
32
Entity Relational Diagram
This Diagrams illustrates relations between the entities in the database for the Digital Planner
33
Signoff Sheet
I have showed this inputs and outputs to Mr Wood to check if he is satisfied with it. I have written a signoff sheet for him to sign if he is happy with it