The following tests were carried out and their actual outcome recorded:
Test no. | Form/Page | Purpose | Test Data | Expected Outcome | Type | Actual Outcome |
---|---|---|---|---|---|---|
1 | Login | Check that a connection to the database can be established | Database address: “csnea.database.windows.net”,Database password: “]JKfpLZSp=8Qd*NM” | Connection to database is established | Normal | Connection to DB is established |
2 | Login | Check that the appropriate error message is displayed if the connection to the database cannot be established | Database address: “randomdb.com”, Database password: “123” | Connection to database cannot be established | Erroneous | Message Box: “Could not establish connection to the database” |
3 | Login | Check that a valid username and password combination is accepted when signing in | Username: “admin”, password: “admin123” | User logs in – administrator form is displayed | Normal | Admin. form is displayed |
4 | Login | Check that an invalid username and password combination is rejected when signing in | Username: “admin”, password: “test” | User does not log in | Erroneous | Message Box: “Login Failed” |
5 | Login | Checking that if the correct user credentials do not match to an administrator or secretary account, access to the Administrator Form is denied | Username: “teacher4”, password: “mathisfun” - access rights: ‘t’ | User does not log in (notified of access denied) | Erroneous | Message Box: “Teachers do not have access to the desktop application” |
6 | Login | Checking that the combination of correct credentials, along with the user type administrator or secretary hides the Log In form and displays the Administrator form | Username: “angeladem”, password: “test2” - access rights: ‘s’ | User is logged in | Normal | Admin. form is displayed |
7 | Administrator-attendances | Checking that an appropriate Absent Student list is generated and displayed without choosing a group | User clicks on the “Display Absent Students” button & Date: Monday, April 12 2021 | List of Students is generated | Normal | Students absent on the day selected are fetched |
8 | Administrator-attendances | Checking that an appropriate Absent Student list is generated and displayed given a selected group | User clicks on the “Display Absent Students” button & Group: “E2” & Date: Monday, April 12 2021 | List of Students is generated | Normal | Students absent on the day selected and from the group selected are fetched |
9 | Administrator-attendances | Checking that a .csv file is generated successfully at the selected file path | User clicks on the “Generate Flat File” button & Date: Monday, April 12 2021 & Target destination: Desktop | .csv file generated named “absences-on-2021-04-12” | Normal | .csv file generated named “absences-on-2021-04-12” |
10 | Administrator-students | Checking that a group selected results in the right list of students presented | User clicks on the “Display All from Group” button & Group: “E2” | List of Students is generated | Normal | List of Students who belong in the “E2” group is generated |
11 | Administrator-students | Checking that an error message is displayed when no group is selected to show its member students | User clicks on the “Display All from Group” button & Group: “” | Error message is displayed | Erroneous | Message Box: “You have not selected a group from the list” |
12 | Administrator-students | Check that an error message is displayed when no student is selected to be removed | User clicks on the “Remove Student” button | Error message is displayed | Erroneous | Message Box: “You have not selected a student from the list” |
13 | Administrator-students | Check that an incorrectly structured .csv file has been selected | User clicks on the “Upload All Students” button, .csv file is selected | Students are not uploaded to the database | Erroneous | Message Box: “You have not selected an appropriate file” |
14 | Administrator-calendar | Check that a semester’s initial date is not later than the final date selected by the user | Semester ID: 5, Start Date: Wednesday, September 1 2021, End Date: Tuesday, August 31 2021 | Semester and dates not added to the database | Erroneous | Semester and dates not added to the database |
15 | Administrator-calendar | Check that all dates are added to the database in the “Semesters” and “Dates” tables | Semester ID: 5, Start Date: Wednesday, September 1 2021, End Date: Tuesday, December 21 2021 | Semester and dates in the range provided are added to the database | Normal | Semester and dates in the range provided are added to the database |
16 | Administrator-calendar | Check that an error message is displayed when no semester is selected to be removed | User clicks on “Remove Semester and Associated Dates” button | Error message is displayed, dates not deleted | Erroneous | Message Box: “You have not selected a semester from the list” |
17 | Administrator-groups | Check for appropriate error message when no group name was used to add a new group | Group ID: “” | Error message is displayed, group not added | Erroneous | Message Box: “You have not entered a valid group name” |
18 | Administrator-groups | Check that a group is added when an appropriate name has been entered | Group ID: “St2” | Group is added to the database | Normal | Group is added to the database |
19 | Administrator-groups | Check that an error message is displayed when no group is selected to be removed | User clicks on the “Delete Group and All Member Students” button | Group and students are not deleted | Erroneous | Group and students are not deleted |
20 | Administrator-groups | Check that a single group and all its member students are deleted successfully | User clicks on the “Delete Group and All Member Students” button group “A1” selected | Group and students are deleted from the database | Normal | Group and students are deleted from the database |
21 | Administrator-users | Check that two correctly structured .csv files have been selected | User clicks on the “Upload Schedule” button after selecting a user, 2 .csv files are selected in sequence | Selected user’s schedule is uploaded as “teachings” | Normal | Selected user’s schedule is uploaded as “teachings” |
22 | Administrator-users | Check that a single user has been selected when uploading their schedule | User clicks on the “Upload Schedule” button | Permission to choose a .csv file is denied | Erroneous | Message Box: “You have not selected an appropriate file” |
23 | Administrator-users | Check that a single user has been selected when changing their password | User clicks on the “Change Password” button | User not allowed to enter a new password | Erroneous | Message Box: “You have not selected a user from the list” |
24 | Administrator-users | Check that an empty password was not provided when changing password for a user | Initial password = “”, Repeated password = “” | New password is not sent to the database | Erroneous | Message Box: “The new password cannot be empty” |
25 | Administrator-users | Inserting the same password twice changes the current password of the user to the new one | Initial password = “newpass”, Repeated password = “newpass” | New password is sent to the database | Normal | New password is sent to the database |
26 | Administrator-users | Inserting different passwords when changing the selected user’s password results in an error message | Initial password = “newpass”, Repeated password = “newpass1” | New password is not sent to the database | Erroneous | Message Box: “The passwords do not match” |
27 | Administrator-users | Check that a single user has been selected when deleting them from the database | The user clicks on the “Delete User” button | No user is deleted from the database | Normal | Message Box: “You have not selected a user from the list” |
28 | Administrator-users | Selecting “Yes” in the popup window deletes the selected user from the database | The user clicks on the “Delete User” button - User selected: “teacher4” | Selected user and associated info is removed from the database | Normal | Selected user and associated info is removed from the database |
29 | Administrator-users | Selecting “No” in the popup window does not delete the user from the database | The user clicks on the “Delete User” button - User selected: “stylianospha” | No user is deleted from the database | Normal | No user is deleted from the database |
30 | Administrator-lessons | Check that a single lesson has been selected when removing it from the database | The user clicks on the “Delete Lesson” button | No lesson is deleted from the database | Erroneous | No lesson is deleted from the lessons table in the database |
31 | Administrator-lessons | Check that a numeric ID results to creating a new lesson in the database | Lesson ID: 12, Lesson Name: “testSubject” | The new lesson is inserted into the database | Normal | The new lesson is inserted into the database |
32 | Administrator-lessons | Check that a lesson is not created when a non-numeric lesson ID is provided | Lesson ID: “new”, Lesson Name: “testSubject” | No new lesson is inserted into the database | Erroneous | Message Box: “The lesson ID must be an integer” |
33 | Administrator | Check that a non-empty post text has been provided | Post text: “” | The post is not sent to the database | Erroneous | Message Box: “The post will not be uploaded” |
34 | Mobile – Main | Check that the current password and new passwords result in the password being changed | Logged in user: georgiagre, current password - “test”, new password - “testnew”, repeat password - “testnew” | The user’s password is changed | Normal | The user’s password is changed |
35 | Mobile – Main | Check that the feed posts are fetched on launch | Logged in user: georgiagre | The posts are fetched | Normal | The posts are fetched |