TESTING AND IMPLEMENTATION

Test Cases of Library Automation System:

Main Form :

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of Administrator Button	The fields for the Administrator Login is Displayed in the Another Login Form	Successful
2	On the Click of Student Button	The fields for the Student Login is Displayed in the Another Login Form	Successful
4	On the Click of Staff Button	The fields for the Staff Login is Displayed in the Another Login Form	Successful
5	On the Click of Exit Button	Exit	Successful

Administrator Login :

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of OK Button	The Administrator Password is Correct then main menu is displayed  else Login form exits	Successful
2	On the click of Switch to user Button	This shows a main Login form	Successful
3	On the Click of turnoff Button	This will exit the project	Successful

Student Login :

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of OK Button	The Student Username and Password is Correct then SEARCH form is displayed  else Login form exits	Successful
2	On the click of Switch to user Button	This shows a main Login form	Successful
3	On the Click of turnoff Button	This will exit the project	Successful

Staff Login :

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of OK Button	The Staff Username and Password is Correct then SEARCH form is displayed  else Login form exits	Successful
2	On the click of Switch to user Button	This shows a main Login form	Successful
3	On the Click of turnoff Button	This will exit the project	Successful

Main Menu – College – Enter Details Of College Configuration  Form :

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of UPDATE Button	When the form loads the data entered at previous time will be displayed and user can change the data.	Successful
2	On the Click of EDIT Button	User can change or modify the data and then he can update.	Successful
3	On the Click of CLOSE	This shows a message box to confirm the user action and if it is ‘yes’ then exits	Successful
4	On the Click of View Detail Tab Button	This Shows already Added Records or the Records which is in Database .	Successful

Main Menu – College – Administrator Settings Form:

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of Change Admin password Button	User has to enter Old password and User Name at first then User have to enter new password. If Old User Name and Password are valid then only new password accepted, otherwise it gives an Error message.	Successful
2	On the Click of Change Student password Button	User have to enter Old password and User Name at first then User have to enter new password. If Old User Name and Password are valid then only new  password accepted, otherwise it gives an Error message.	Successful
3	On the Click of Change Staff password Button	User has to enter Old password and User Name at first then User have to enter new password. If Old User Name and Password are valid then only new password accepted, otherwise it gives an Error message.	Successful
4	On the click of Reset Button	Clears all fields	Successful

Main Menu – Member Entry – Student Member Entry Form:

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of ADD Button	At first user have to fill all fields with proper data , if any Error like entering text data instead of number or entering number instead of text..is found then it gives proper message otherwise Adds Record To the Database	Successful
2	On the Click of DELETE Button	Which deletes the details of student	Successful
3	On the Click of CLEAR Button	Clears all fields	Successful
4	On the Click of View Detail Tab Button	This Shows already Added Records or the Records which is in Database .	Successful
4	On the Click of Exit  Button	This shows a message box to confirm the user action and if it is ‘yes’ then exits	Successful

Main Menu – Member Entry – Staff Member Entry Form:

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of ADD Button	At first user have to fill all fields with proper data , if any Error like entering text data instead of number or entering number instead of text. is found then it gives proper message otherwise Adds Record To the Database	Successful
2	On the Click of DELETE Button	Which deletes the details of staff	Successful
3	On the Click of CLEAR Button	Clears all fields	Successful
4	On the Click of View Detail Tab Button	This Shows already Added Records or the Records which is in Database.	Successful
5	On the Click of Exit  Button	This shows a message box to confirm the user action and if it is ‘yes’ then exits	Successful

Main Menu – Member Entry – Change Details-Student Member Form:-

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of SEARCH Button	Displays the Details of  Student for entered Student ID. Otherwise gives proper Error message.	Successful
2	On the Click of EDIT Button	By clicking EDIT button user can change\modify the record.	Successful
3	On the Click of UPDATE  Button	Modified records are  Updated in database by clicking UPDATE  button.	Successful
4	On the Click of EXIT Button	This shows a message box to confirm the user action and if it is ‘yes’ then exits	Successful

Main Menu – Member Entry – Change Details-Staff Member Form:-

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of SEARCH Button	Displays the Details of  Staff  for entered Staff ID. Otherwise gives proper Error message.	Successful
2	On the Click of EDIT Button	By clicking EDIT button user can change\modify the record.	Successful
3	On the Click of UPDATE  Button	Modified records are  Updated in database by clicking UPDATE  button.	Successful
4	On the Click of EXIT Button	This shows a message box to confirm the user action and if it is ‘yes’ then exits	Successful

Main Menu – Book – Book Detail Entry Form:

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of ADD Button	At first user have to fill all fields with proper data , if any Error like entering text data instead of number or entering number instead of text. is found then it gives proper message otherwise Adds Record To the Database	Successful
2	On the Click of CLEAR Button	Clears all fields	Successful
3	On the Click of View Detail Tab Button	This Shows already Added Records or the Records which is in Database.	Successful
4	On the Click of Exit Button	This shows a message box to confirm the user action and if it is ‘yes’ then exits	Successful

Main Menu – Book – Magazine Detail Entry Form:

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of ADD Button	At first user have to fill all fields with proper data , if any Error like entering text data instead of number or entering number instead of text. is found then it gives proper message otherwise Adds Record To the Database	Successful
2	On the Click of CLEAR Button	Clears all fields	Successful
3	On the Click of View Detail Tab Button	This Shows already Added Records or the Records which is in Database.	Successful
4	On the Click of EXIT  Button	This shows a message box to confirm the user action and if it is ‘yes’ then exits	Successful

Main Menu – Book –Change Detail-Change Book Detail Form:

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of OK Button	Displays the Details of  Book for entered Accession number. Otherwise gives proper Error message.	Successful
2	On the Click of EDIT Button	By clicking EDIT button user can change\modify the record.	Successful
3	On the Click of UPDATE  Button	Modified records are  Updated in database by clicking UPDATE  button.	Successful
4	On the Click of EXIT Button	This shows a message box to confirm the user action and if it is ‘yes’ then exits	Successful

Main Menu – Book –Change Detail-Change Magazine  Detail Form:

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of OK Button	Displays the Details of  Book for entered Accession number. Otherwise gives proper Error message.	Successful
2	On the Click of EDIT  Button	By clicking EDIT button user can change\modify the record.	Successful
3	On the Click of UPDATE  Button	Modified records are  Updated in database by clicking UPDATE  button.	Successful
4	On the Click of EXIT  Button	This shows a message box to confirm the user action and if it is ‘yes’ then exits	Successful

Main Menu – Book –Remove -Remove Book   Form:

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of SEARCH Button	Displays the Details of  Book for entered Criteria. Otherwise gives proper Error message.	Successful
2	On the Click of DELETE Button	Which deletes the details of book	Successful
3	On the Click of EXIT  Button	This shows a message box to confirm the user action and if it is ‘yes’ then exits	Successful

Main Menu – Book- Remove-Remove Magazine Form:

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of SEARCH Button	Displays the Details of  Magazine for entered Criteria. Otherwise gives proper Error message.	Successful
2	On the Click of DELETE Button	Which deletes the details of Magazine	Successful
3	On the Click of EXIT Button	This shows a message box to confirm the user action and if it is ‘yes’ then exits	Successful

Main Menu – Book Transaction–Issuing Books:

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of SEARCH Button	Displays the Details of  Book for entered Criteria. Otherwise gives proper Error message.	Successful
2	On the Click of OK Button	Displays the Details of  Book and Library Members for entered Criteria. Otherwise gives proper Error message.	Successful
3	On the Click of ISSUE BOOK Button	This is used to issue book for library members. This Stores the information about student members and book detail in issued books table of library database.	Successful
4	On the Click of EXIT Button	This shows a message box to confirm the user action and if it is ‘yes’ then exits	Successful

Main Menu – Book Transaction–Returning Books:

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of OK Button	Displays the Details of Books and Library Members for entered Criteria. Otherwise gives proper Error message.	Successful
2	On the Click of COLLECT FINE Button	On the click of this button it shows another form which automatically fills all the details about fine collection.	Successful
3	On the Click of ACCEPT BOOK Button	On the click of this button , it deletes the records of book collected members and details of book from issued book table of library database	Successful
4	On the Click of EXIT Button	This shows a message box to confirm the user action and if it is ‘yes’ then exits	Successful

Main Menu – OPAC–Search:

Sl .No	Test Condition	Expected Result	Test Result
1	On the Click of SEARCH Button	Displays the Details of Books or Magazines for entered Criteria. Otherwise gives proper Error message.	Successful
2	On the Click of SHOW FULL COLLECTION Button	Displays the Details All Books or Magazines. Otherwise gives proper Error message.	Successful
3	On the Click of Clear \ Cancel Button	This shows a message box to confirm the user action and if it is ‘yes’ then exits	Successful