95c1af74-f7cf-4c85-a845-1a2c4bb92f4a (1)

lOMoARcPSD|27817414 Employee management system SRS Employee management system SRS computer application in pharmacy (Dr. A.P.J. Abdul Kalam Technical University) computer application in pharmacy (Dr. A.P.J. Abdul Kalam Technical University) Scan to open on Studocu Scan to open on Studocu Studocu is not sponsored or endorsed by any college or university Studocu is not sponsored or endorsed by any college or university Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 Sofuware Requirements Specifjcatjon Project : Employee Management System Submitued by Project Guide Students Neeraj Kumar jain Name : Paritosh Raj Roll N. : (1709341869) Name : Anand Prakash Roll N. : (17093418……..) Name : Ankit Karn Roll N. : (17093418……..) Instjtute of Technology and Science Mohan Nagar, Ghaziabad Date ……………………………………….. Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 Table of Contents 1. INTRODUCTION............................................................................ 4 1.1 Purpose …………………………………………………………………………………….…..4 1.2 Intended Audience and Reading Suggestjons……………………………......4 1.3 Project Scope………………………………………………………………………………….4 1.4 References……………………………………………………………………………… …….4 2. Overall Descriptjon………………………………………………………………………5 2.1 Product Perspectjve………………………………………………………………………….5 2.2 Product Features……………………………………………………..........................5. 2.2.1. Functjonal Requirements………………………………………………….7 2.2.2. Non Functjonal Requirements……………………………………………10 2.3. User Classes and Characteristjcs……………………………………………………..10 2.4 Operatjng Environment……………………………………………………………………10 Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 3. Tools & Technologies to be used: ……………………………………………….10 4. Hardware Interface: ………………………………………………………………….11 5. Design and Implementatjon Constraint……………...........................11 6. Architectural Design: ………………………………………………………………….11 6.1. Data Flow Diagram…………………………………………………….…………………….12 6.2. Use case Diagram……………………………………………………………………………..12 6.3. Sequence Diagram ………………………………..………………………………………...12 6.4 Class Diagram…………………………………………………………………………………..13 6.5 .Actjvity Diagram……………………………………………………………………………….13 7. Database Schema:……………………………………………...........................13 7.1. Data Dictjonary………………………………………………………………………………..13 7.2. ER Diagram ……………………………………………………………………..……………...14 8. System Testjng…………………………………………………………………………....18 Test Cases……………………………………………………………………………………..…18 9. Conclusion……………….…………………………………………………………… ….. 42 Project informatjon: 1. Name of project Employee Management System 2. Objectjve and vision Vision: 2.0 3. Users of the System Employee Management 4. Functjonal Requirement -The applicatjon should be easy to use 5. Non- Functjonal Requirement Defect testjng is testjng for situatjon Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 where the program does not meet its fjctjonal specifjcatjon. 6. User interface prioritjes First open “ Index.php” 7. Team Size Two student 8. Technologies to be use Javascript , PHP, HTML ,css 9. Tools to be Used Sublime text Editor, Star UMl 1. Introductjon- This document is a sofuware requirement specifjcatjon for the Employee Management System Project. Afuer giving informatjon about the defjnitjon of the project at the beginning part of the document, we will give complete descriptjon for overview and list the requirements which meet the needs of the company roughly. 1.1Purpose Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 This document aims to give a brief descriptjon about the Employee Management System Project. With the help of this document the needs of the company and the solutjon that will be provided to that needs will be clearly presented. In other words this document will provide a basis for validatjon and verifjcatjon. 1.3 Scope This document covers the whole defjnitjon of the Employee Management System (EMS) project. It basically includes the requirements for managing the personal data, controlling authentjcatjon and authorizatjon mechanism, and evaluatjng of employees’ performance. Afuer creatjng the new EMS we have to accomplish data migratjon from their existjng system to our new one. More specifjcally, our EMS (Employee Management System) controls and manages the personal database such that any user with difgerent role types as manager, admin, employee, and Employee Manage will be able to manipulate their personal data. In additjon to manipulatjng the personal data, our EMS will provide authentjcatjon and authorizatjon mechanism. Every user with any role type can be able to login to the system with his/her username and password. 1.4 References [1] IEEE Std 830-1998: IEEE Recommended Practjce for Sofuware Requirements Specifjcatjons [2] htup://www.webdunia.net/CaseStudy/internal_caseStudies/CaseStudyEMS2.pdf [3] htup://www.ibm.com/developerworks/ratjonal/library/769.html [4] htup://www.cs.iusb.edu/thesis/SLingareddy_thesis.pdf [5] htup://en.wikipedia.org/wiki/Eclipse_(sofuware) [6] htup://www.eclipse.org/org/ 2. Overall Descriptjon 2.1 Product Perspectjve Currently, Siemens has an ERMS already in use. However, with the HRMS we will provide them with additjonal capabilitjes and propertjes organized neatly. ERMS which is an online intranet System will be used by four types of employees’ of Siemens. These types who have difgerent roles can be stated as; admin, manager, HR, employee. Every user enters the main authentjcatjon page and afuer that, system will grant them authorizatjon. Afuer being authorized according to their permissions (role type) users will basically query and edit the database via ERMS. Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 2.2 Product Functjons ERMS implements some major functjons in order to accomplish required tasks. These functjons constjtute a basis for the whole system. These functjons can be stated as: 2.3 Authentjcatjon and Authorizatjon Login System Being connected to internet, users will be able to get into the system. In order to see the interface related to his/her role type, the users account should be authorized and also his/her user name and Recruitment Recruitment of a new person which means introducing a new user to the system can be accomplished in two steps. When it is needed to add a new user to the system, fjrstly, HR must create an employee account, by the way at this step HRMS automatjcally gives an id to that user. At the second step, admin creates a user related to that user id. Process Data manage the database according to the desired task. These management tasks constjtute the major feature of the ERMS. With the help of these functjons a user can update some basic personal data like contact informatjon, marital status etc. In additjon to update data, a user can also search the database in order to obtain the list of the users' which has the propertjes desired. Also a user may also see the specifjc informatjon about a user or all users which can be named as report. In other words searching is the operatjon with rows of the database while reportjng is operatjon with columns of the database. These functjons which can be examined in that process data major functjon are basically provides user to 2.4 Interface Requirements All the users will see the same page when they enter ERMS. This page asks the users a username and a password. Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 Afuer being authentjcated users will see the interface containing the informatjon of the fjrst tab of the user role types. This interface include difgerent tabs according to their role types determined by admin at the authentjcatjon phase. By the way, users may have more than one role. Then a user who has more than one role will be able to see all the tabs that are related to his/her role types. These tabs can be named as; Personal Data Tab, Employee List Tab, Add New Employee Tab, Add New User Tab, Manage Users Tab, Users List Tab and Arrange Roles Tab. User who have employee role have authorizatjon to see only Personal Data Tab, ER role gives right to see Employee List Tab and Add New Employee Tab. Manager role gives authorizatjon to see only Manager Tab. And Admin role gives user right to see User List Tab and Arrange Roles Tab. These authorizatjons are default ones but an admin can change these authorizatjons by Arrange Roles Tab. These tabs can be explained detailed as: 2.5 Functjonal Requirements In this sectjon, we will explain the major functjons of HRMS along with the data fmow. So the major functjonality of the project such as authentjcatjon mechanism, personal data processing, recruitment, report, and graphical user interface unit will explained step by step. 2.5.1. Functjonal requirement 1. Login User can login to the HRMS system with his/her username and password. Logout User can logout from the HRMS system. Login failure If the user does not exists in the database or the user did not get authorized by the HRMS admin yet. 3.2.1.2 Authorizatjon Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 User role check Afuer logging in, the user role will be checked from the database and the user interface will be created according to that role/roles. 2.5.2 Process Data Display User with defjned roles can display the content of the database. Being more specifjc, employee can only view his/her personal informatjon. Manager can see not only his/her personal informatjon but also employees’ informatjon who are working under his/her coverage. Admin and HR can display their personal informatjon and all employees’ informatjon. Edit A user with employee role can edit his/her specifjc personal informatjon. Manager can only edit employees’ personal informatjon that is under his/her coverage except user role type. HR can edit all employees’ informatjon except user role type. Admin can edit all informatjon related to all employees’ including their user role type. Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 Search User with manager role type can search the content of database for the employees who are under his/her coverage. HR and admin roles can search all the employees’ informatjon in the database. Search feature works on specifjc keywords showing employees’ characteristjcs, peculiaritjes, skills, features, and etc. For example, HR wants to fjnd employees who are well trained in “Java Programming Language”. He/she will write the specifjc keyword in the search bar and press the available search butuon. Afuerwards, he/she will fjnd a list of all the employees’ who know “Java Programming Language”. Report This feature is basically used to fjlter the contents of the search mechanism. For instance, as we mentjoned in the above search feature. The HR wants to get a report of some specifjc employees who know “java programming Language”. The list of employees obtained from the result of search feature he/she can get the specifjc report by selectjng the corresponding checkbox available for each employee. Or a manager role type can get a report of some or all employees’ who are working under his/her coverage by selectjng the checkbox. Except employee role type, all other role types such as admin, HR, and manager can use this feature. This feature can be used only by admin role type. Admin can update the role type of a specifjc user. For example, an employee got promotjon and his role type will be changed from employee role to manager role. Admin will be able to update this authentjcatjon mechanism. Update authentjcatjon 2.5.3 Recruitment Add a new employee HR role type is able to add a new employee to the database. The new employee will have all the required personal informatjon related to his/her. The new created employee will have an id. Add a new user Afuer being created a new employee by HR role, admin role is responsible for creatjng a new user by the specifjed id assigned in the “Add a new employee” feature. The unique id will be given by the system. Admin will assign a new role such as employee, manager, HR, and admin to the new created user. Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 EERMS ERMS 2.4 Non-functjonal Requirements 3.3.1 Performance requirements 3.3.1.1) The number of the online user of the ERMS can be estjmated as 50 at most. 3.3.1.2) There is no restrictjon on the number of the users to be added to the database. 3.Technologies to be used: Sofuware Requirements: - Operatjng System : Windows, Linux  Web-Technology: PHP  Front-End: HTML, CSS, JAVASCRIPT  Back-End: MySQL  Web Server: Apache SERVER.  PHP PHP, abbreviated to Hypertext Preprocessor is a server side web programming language that can be embedded into HTML. PHP is free sofuware i.e. it is open source code. It is used for creatjng dynamic web Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 pages that interact with the user and can include functjonalitjes such as gettjng user input, manipulatjon of the input and storage of this data in a suitable DBMS. PHP is also easy to integrate with web pages. [12] MySQL MySQL stands for My Structured Query Language. It is the world’s most popular open source relatjonal DBMS. MySQL is available for free under the GNU General Public License for open source benefjts/reasons related to development. Initjally MySQL was free and some versions of it are stjll free though if you desire to use MySQL for commercial purposes you will need to purchase a license. It is non-proprietary, easily extensible and platgorm independent. Its downside is that it lacks a graphical user interface; therefore you need to know how the database works to make the most effjcient use of it. [13] 4. Hardware Requirements : Pentjum- Intel Pentjum IV, 1GHZ or above  1GB Ram  512 KB Cache Memory  Hard disk 10 GB  Microsofu Compatjble 101 or more Key Board  5. Design and Implementatjon Constraints 1. 2. 3. The global schema, fragmentatjon schema, and allocatjon schema. SQL commands for above queries/applicatjons How the response for applicatjon 1 and 2 will be generated. Assuming these are global queries. Explain how various fragments will be combined to do so. Implement the database at least using a centralized database management system. 4. 6.Architectural Design 6.1. Data Flow Diagram A data-fmow diagram (DFD) is a way of representjng a fmow of a data of a process or a system (usually an informatjon system). The DFD also provides informatjon about the outputs and inputs of each entjty and the process itself. A data- fmow diagram has no control fmow, there are no decision rules and no loops. Specifjc operatjons based on the data can be represented by a fmowchart Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 data-fmow diagram (DFD) 6.2 Use case diagram A use case diagram is a dynamic or behavior diagram in UML. Use case diagrams model the functjonality of a system using actors and use cases. Use cases are a set of actjons, services, and functjons that the system needs to perform. In this context, a "system" is something being developed or operated, such as a web site. The "actors" are people or entjtjes operatjng under defjned roles within the system 6.3. Sequence Diagram Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 6.4. Class Diagram 7. Database Schema Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 4.1 Data Dictjonary Data Dictjonary consists of the following informatjon: 1. 2. 3. 4. 5. 6. Name of the tables in the database Constraints of a table i.e. keys, relatjonships, etc. Columns of the tables that related to each other Owner of the table Last accessed informatjon of the object Last updated informatjon of the object An example of Data Dictjonary can be personal details of a student: Example <Emp Personal Details> Eml_ID Emp_Name Emp_Address Emp_City The following is the data dictjonary for the above fjelds: Types of Data Dictjonary Here are the two types of data dictjonary: Actjve Data Dictjonary The DBMS sofuware manages the actjve data dictjonary automatjcally. The modifjcatjon is an automatjc task and most RDBMS has actjve data dictjonary. It is also known as integrated data dictjonary. Passive Data Dictjonary Managed by the users and is modifjed manually when the database structure change. Also known as non- integrated data dictjonary ER Diagram Admin Control Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 4.1.1.1 TBL_Employee Table Name: TBL_Employee Table Descriptjon: Data table for Employee consists of many fjelds which are responsible for storing the specifjc employee personal informatjon. Some important fjelds in the table can be said as employee id, name, surname, email, phone, date of birth, and many more which can be seen in the above database table. Fields in this table will be fjlled with the specifjc data of the Employee. At the tjme a new Employee is added to the HRMS system, these fjelds keeps the data manually provided by the HR. Afuer the fjrst creatjon of the Employee account, employee him/herself, manager, HR, and admin have authorizatjon to modify this informatjon. 4.1.1.2 TBL_APPL_User Name: TBL_APPL_User Descriptjon: The TBL_APPL_User table consists of basic informatjon about a user. The detailed informatjon about this table will be given in part (4.2), in Authorizatjon and Authentjcatjon module part. 4.1.1.3 TBL_Employee_Projects Name: TBL_Employee_Projects Descriptjoin: This table stores basic relatjon between projects and employees. it stores informatjon about projects that this specifjed employee takes part. In other words, it keeps specifjc employee id, projects id, name, start, fjnish, and completed dates, and notes. 4.1.1.4 TBL_Employee_Technical Skills Name: TBL_Employee_TechnicalSkills Descriptjon: This table stores informatjon about an employee technical skills. Informatjon such as employee Id, name, level, confjrmatjon, notes, and levelId will be kept. Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 4.1.1.5 TBL_Employee_Educatjoin Name: TBL_Employee_Educatjoin Descriptjon: This table keeps informatjon about an employee educatjon. Basically, informatjon such as employee id, department, degree, instjtutjon, thesis, notes, stjll studying, entrance date, graduatjon, and etc. 4.1.1.6 TBL_Employee_Languages Name: TBL_Employee_Languages Descriptjon: Employee languages table stores data fjelds such as employee id, languages, writuen and speaking level of the languages, natjve language, notes, and confjrmatjon. 4.1.1.7 TBL_Employee_Trainings Name: TBL_Employee_Trainings Descriptjon: This table gives informatjon about an employee trainings. It keeps employee id, training name, locatjon, duratjon, provider, confjrmatjon, star and end dates, and notes. 4.1.1.8 TBL_Employee_Certjfjcates Name: TBL_Employee_Certjfjcates Descriptjon: An employee may have certjfjcates throughout his/her educatjon tjmeline or he/she will get any other certjfjcates during his working duratjon in the company. Employee certjfjcate table stores data fjeld such as employee id, name of the certjfjcate, its provider, date, notes and confjrmatjon. 4.1.1.9 TBL_Employee_Emergency_Call Name: TBL Employee Emergency Call Descriptjon: This table will be used in case there is an urgent call to a specifjc employee. In order to rich the employee informatjon, we store employee id, name, surname, his/her relatjon to a person, and phone number. 4.1.1.10 TBL_Employee_Quit Name: TBL Employee Quit Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 Descriptjon: Table employee quit is used to back up the specifjc employee informatjon afuer he/she quits the job. The HRMS system will not delete the employees who quit the job. Instead, it stores their basic data and data fjelds that he/she was charged for. For instance, an employee during his work-life period might have been given items belongs to company such as PC, company id card, GSM card, credit card, phone, vehicles and etc. When he/she leaves the company, those data fjelds mentjoned above will be marked. Basic data fjelds are; employee id, start and end dates of the positjon, PC, phone, training-cancel, health insurance, and etc. 4.1.1.11 TBL_Employee_Atuachments Name: TBL_Employee_Atuachments Descriptjon: This table is used to keep data about employee atuachments. The informatjon that will be stored is employee id, fjle name, fjle id, URL, notes, content type, fjle size, fjle type, and id. 4.1.2 Relatjonships Relatjonships between tables are made through a unique fjeld which is employee id. Employee table creates the basic informatjon table about an employee such as his/her id, name, surname, email, and etc. This provided employee id is a primary key for the employee table, but it will be a foreign key for all other tables using the specifjc employee id. All table mentjoned above will manipulate employee personal data through that id. Therefore, employee id, the primary key, is like bridge between a unique employee and his/her relatjon to other data fjelds and tables. 4.2 Data Descriptjon of Authentjcatjon and Authorizatjon Module In this sectjon all authentjcatjon and authorizatjon module database tables will be described in details. We describe each table and its responsibility in the module. Each authentjcatjon and authorizatjon database tables keep many fjelds related to the specifjc data object. Relatjonship between each table will be explained as well. Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 9. System testjng Test cases: TEST TEST CASE EXPECTED RESULT TEST CASE ID SCENARIO PRE-CONDITION 1. Need a valid Gmail Account to do login TEST STEPS 1. Enter User Name 2. Enter Password 3. Click "Login" butuon TEST DATA <Valid User Name> <Valid Password> Enter valid User Name and valid Password Verify the login of Gmail TC_LOGIN_001 Successful login <?php Session start(); error_reportjng(0); include('includes/dbconnectjon.php'); if(isset($_POST['login'])) { $Email=$_POST['Email']; $Password=$_POST['Password']; Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 $query=mysqli_query($con,"select ID from employeedetail where EmpEmail='$Email' && EmpPassword='$Password' "); $ret=mysqli_fetch_array($query); if($ret>0){ $_SESSION['uid']=$ret['ID']; header('locatjon:welcome.php'); } else{ $msg="Invalid Details."; } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utg-8"> <meta htup-equiv="X-UA-Compatjble" content="IE=edge"> <meta name="viewport" content="Employee Record management System in php and mysql"> <meta name="descriptjon" content="Employee Record management System in php and mysql"> <meta name="author" content="Sarita Pandey"> <tjtle>ERMS Employee Login</tjtle>  <link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css"> <link href="htups://fonts.googleapis.com/css? family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet"> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414  <link href="css/sb-admin-2.min.css" rel="stylesheet"> </head> <body class="bg-gradient-primary"> <div class="container"> <h3 align="center" style="color: black; padding-top: 2%">Employee Record Managment System</h3>  <div class="row justjfy-content-center"> <div class="col-xl-10 col-lg-12 col-md-9"> <div class="card o-hidden border-0 shadow-lg my-5"> <div class="card-body p-0">  <div class="row"> <div class="col-lg-6 d-none d-lg-block bg-login-image"></div> <div class="col-lg-6"> <div class="p-5"> <div class="text-center"> <h1 class="h4 text-gray-900 mb-4">Welcome Back!</h1> </div> <p style="font-size:16px; color:red" align="center"> <?php if($msg){ echo $msg; } ?> </p> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 <form class="user" method="post" actjon=""> <div class="form-group"> <input type="email" class="form-control form-control-user" id="Email" name="Email" aria- describedby="emailHelp" placeholder="Enter Email Address..." required="true"> </div> <div class="form-group"> <input type="password" class="form-control form-control-user" id="Password" name="Password" placeholder="Password" required="true"> </div> <p> <input type="submit" class="btn btn-primary btn-user btn-block" name="login" value="login"></p> <hr> </form> <hr> <div class="text-center"> <a class="small" href="forgetpassword.php">Forgot Password?</a> </div> <div class="text-center"> <a class="small" href="registererms.php">Create an Account!</a> </div> </div> </div> </div> </div> </div> </div> </div> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 </div>  <script src="vendor/jquery/jquery.min.js"></script> <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>  <script src="vendor/jquery-easing/jquery.easing.min.js"></script>  <script src="js/sb-admin-2.min.js"></script> </body> </html> Home <?php session_start(); include('includes/dbconnectjon.php'); if(strlen($_SESSION['uid']==0)){ Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 header('locatjon:logout.php'); } else { ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utg-8"> <meta htup-equiv="X-UA-Compatjble" content="IE=edge"> <meta name="viewport" content="width=device-width, initjal-scale=1, shrink-to-fjt=no"> <meta name="descriptjon" content=""> <meta name="author" content=""> <tjtle>Welcome to ERMS</tjtle>  <link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css"> <link href="htups://fonts.googleapis.com/css? family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">  <link href="css/sb-admin-2.min.css" rel="stylesheet"> </head> <body id="page-top">  <div id="wrapper"> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414  <?php include_once('includes/sidebar.php');?>   <div id="content-wrapper" class="d-fmex fmex-column">  <div id="content">  <?php include_once('includes/header.php');?>   <div class="container-fmuid">  <div class="d-sm-fmex align-items-center justjfy-content-between mb-4"> <h1 class="h3 mb-0 text-gray-800">Employee Record Management System</h1> </div>  <div class="row"> <div class="col-xl-3 col-md-6 mb-4"></div>  <div class="col-xl-6 col-md-6 mb-4"> <div class="card border-lefu-primary shadow h-100 py-2"> <div class="card-body"> <div class="row no-gutuers align-items-center"> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 <div class="col mr-2"> <div class="text-xs font-weight-bold text-primary text-uppercase mb-1">Welcome Back to ERMS !</div> <?php $empid=$_SESSION['uid']; $ret=mysqli_query($con,"select EmpFname,EmpLname from employeedetail where ID='$empid'"); $row=mysqli_fetch_array($ret); $fname=$row['EmpFname']; $lname=$row['EmpLname']; ?> <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $fname." ".$lname; ?></div> </div> <div class="col-auto"> <i class="fas fa-user fa-2x text-gray-300"></i> </div> </div> </div> </div> </div> </div>  </div> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 </div> </div>  </div>   <?php include_once('includes/footer.php');?>  </div>  </div>   <a class="scroll-to-top rounded" href="#page-top"> <i class="fas fa-angle-up"></i> </a>  <script src="vendor/jquery/jquery.min.js"></script> <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>  <script src="vendor/jquery-easing/jquery.easing.min.js"></script> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414  <script src="js/sb-admin-2.min.js"></script>  <script src="vendor/chart.js/Chart.min.js"></script>  <script src="js/demo/chart-area-demo.js"></script> <script src="js/demo/chart-pie-demo.js"></script> </body> </html> </html> <?php } ?> EXPECTED RESULT A message "The email and password you entered don't match" is shown TEST CASE ID TEST SCENARIO TEST CASE PRE-CONDITION 1. Need a valid Gmail Account to do login TEST STEPS 1. Enter User Name 2. Enter Password 3. Click "Login" butuon TEST DATA <Valid User Name> <Invalid Password> Enter valid User Name and invalid Password Verify the login of Gmail TC_LOGIN_002 <!DOCTYPE html> <html lang="en"> <head> <meta charset="utg-8"> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 <meta htup-equiv="X-UA-Compatjble" content="IE=edge"> <meta name="viewport" content="Employee Record management System in php and mysql"> <meta name="descriptjon" content="Employee Record management System in php and mysql"> <meta name="author" content="Sarita Pandey"> <tjtle>ERMS Employee Login</tjtle>  <link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css"> <link href="htups://fonts.googleapis.com/css? family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">  <link href="css/sb-admin-2.min.css" rel="stylesheet"> </head> <body class="bg-gradient-primary"> <div class="container"> <h3 align="center" style="color: black; padding-top: 2%">Employee Record Management System</h3>  <div class="row justjfy-content-center"> <div class="col-xl-10 col-lg-12 col-md-9"> <div class="card o-hidden border-0 shadow-lg my-5"> <div class="card-body p-0">  <div class="row"> <div class="col-lg-6 d-none d-lg-block bg-login-image"></div> <div class="col-lg-6"> <div class="p-5"> <div class="text-center"> <h1 class="h4 text-gray-900 mb-4">Welcome Back!</h1> </div> <p style="font-size:16px; color:red" align="center"> </p> <form class="user" method="post" actjon=""> <div class="form-group"> <input type="email" class="form-control form-control-user" id="Email" name="Email" aria- describedby="emailHelp" placeholder="Enter Email Address..." required="true"> </div> <div class="form-group"> <input type="password" class="form-control form-control-user" id="Password" name="Password" placeholder="Password" required="true"> </div> <p> <input type="submit" class="btn btn-primary btn-user btn-block" name="login" value="login"></p> <hr> </form> <hr> <div class="text-center"> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 <a class="small" href="forgetpassword.php">Forgot Password?</a> </div> <div class="text-center"> <a class="small" href="registererms.php">Create an Account!</a> </div> </div> </div> </div> </div> </div> </div> </div> </div>  <script src="vendor/jquery/jquery.min.js"></script> <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>  <script src="vendor/jquery-easing/jquery.easing.min.js"></script>  <script src="js/sb-admin-2.min.js"></script> </body> </html> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 EXPECTED RESULT A message "The email and password you entered don't match" is shown TEST CASE ID TEST SCENARIO TEST CASE PRE-CONDITION 1. Need a valid Gmail Account to do login TEST STEPS 1. Enter User Name TEST DATA <Invalid User Name> <Valid Password> Enter invalid User Name and valid Password Verify the login of Gmail TC_LOGIN_003 2. Enter Password <!DOCTYPE html> <html lang="en"> <head> <meta charset="utg-8"> <meta htup-equiv="X-UA-Compatjble" content="IE=edge"> <meta name="viewport" content="Employee Record management System in php and mysql"> <meta name="descriptjon" content="Employee Record management System in php and mysql"> <meta name="author" content="Sarita Pandey"> <tjtle>ERMS Employee Login</tjtle>  <link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css"> <link href="htups://fonts.googleapis.com/css? family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">  <link href="css/sb-admin-2.min.css" rel="stylesheet"> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 </head> <body class="bg-gradient-primary"> <div class="container"> <h3 align="center" style="color: black; padding-top: 2%">Employee Record Managment System</h3>  <div class="row justjfy-content-center"> <div class="col-xl-10 col-lg-12 col-md-9"> <div class="card o-hidden border-0 shadow-lg my-5"> <div class="card-body p-0">  <div class="row"> <div class="col-lg-6 d-none d-lg-block bg-login-image"></div> <div class="col-lg-6"> <div class="p-5"> <div class="text-center"> <h1 class="h4 text-gray-900 mb-4">Welcome Back!</h1> </div> <p style="font-size:16px; color:red" align="center"> </p> <form class="user" method="post" actjon=""> <div class="form-group"> <input type="email" class="form-control form-control-user" id="Email" name="Email" aria- describedby="emailHelp" placeholder="Enter Email Address..." required="true"> </div> <div class="form-group"> <input type="password" class="form-control form-control-user" id="Password" name="Password" placeholder="Password" required="true"> </div> <p> <input type="submit" class="btn btn-primary btn-user btn-block" name="login" value="login"></p> <hr> </form> <hr> <div class="text-center"> <a class="small" href="forgetpassword.php">Forgot Password?</a> </div> <div class="text-center"> <a class="small" href="registererms.php">Create an Account!</a> </div> </div> </div> </div> </div> </div> </div> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 </div> </div>  <script src="vendor/jquery/jquery.min.js"></script> <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>  <script src="vendor/jquery-easing/jquery.easing.min.js"></script>  <script src="js/sb-admin-2.min.js"></script> </body> </html> TEST PRE- EXPECTED RESULT TEST CASE ID SCENARIO TEST CASE CONDITION 1. Need a valid Gmail Account to do login TEST STEPS 1. Enter User Name 2. Enter Password 3. Click "Login" butuon TEST DATA <Invalid User Name> <Invalid Password> A message "The email and password you entered don't match" is shown Enter invalid User Name and invalid Password Verify the login of Gmail TC_LOGIN_004 <!DOCTYPE html> <html lang="en"> <head> <meta charset="utg-8"> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 <meta htup-equiv="X-UA-Compatjble" content="IE=edge"> <meta name="viewport" content="Employee Record management System in php and mysql"> <meta name="descriptjon" content="Employee Record management System in php and mysql"> <meta name="author" content="Sarita Pandey"> <tjtle>ERMS Employee Login</tjtle>  <link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css"> <link href="htups://fonts.googleapis.com/css? family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">  <link href="css/sb-admin-2.min.css" rel="stylesheet"> </head> <body class="bg-gradient-primary"> <div class="container"> <h3 align="center" style="color: black; padding-top: 2%">Employee Record Managment System</h3>  <div class="row justjfy-content-center"> <div class="col-xl-10 col-lg-12 col-md-9"> <div class="card o-hidden border-0 shadow-lg my-5"> <div class="card-body p-0">  <div class="row"> <div class="col-lg-6 d-none d-lg-block bg-login-image"></div> <div class="col-lg-6"> <div class="p-5"> <div class="text-center"> <h1 class="h4 text-gray-900 mb-4">Welcome Back!</h1> </div> <p style="font-size:16px; color:red" align="center"> </p> <form class="user" method="post" actjon=""> <div class="form-group"> <input type="email" class="form-control form-control-user" id="Email" name="Email" aria- describedby="emailHelp" placeholder="Enter Email Address..." required="true"> </div> <div class="form-group"> <input type="password" class="form-control form-control-user" id="Password" name="Password" placeholder="Password" required="true"> </div> <p> <input type="submit" class="btn btn-primary btn-user btn-block" name="login" value="login"></p> <hr> </form> <hr> <div class="text-center"> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 <a class="small" href="forgetpassword.php">Forgot Password?</a> </div> <div class="text-center"> <a class="small" href="registererms.php">Create an Account!</a> </div> </div> </div> </div> </div> </div> </div> </div> </div>  <script src="vendor/jquery/jquery.min.js"></script> <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>  <script src="vendor/jquery-easing/jquery.easing.min.js"></script>  <script src="js/sb-admin-2.min.js"></script> </body> </html> Admin module Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 <?php session_start(); include('includes/dbconnectjon.php'); if(isset($_POST['login'])) { $uname=$_POST['username']; $Password=$_POST['Password']; $query=mysqli_query($con,"select ID from tbladmin where AdminuserName='$uname' && Password='$Password' "); $ret=mysqli_fetch_array($query); if($ret>0){ $_SESSION['aid']=$ret['ID']; header('locatjon:welcome.php'); } else{ echo "Invalid Details"; } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utg-8"> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 <meta htup-equiv="X-UA-Compatjble" content="IE=edge"> <meta name="viewport" content="Employee Record management System in php and mysql"> <meta name="descriptjon" content="Employee Record management System in php and mysql"> <meta name="author" content="Sarita Pandey"> <tjtle>ERMS Admin Login</tjtle>  <link href="../vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css"> <link href="htups://fonts.googleapis.com/css? family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">  <link href="../css/sb-admin-2.min.css" rel="stylesheet"> </head> <body class="bg-gradient-primary"> <div class="container"> <h3 align="center" style="color: black; padding-top: 2%">Employee Record Managment System</h3>  <div class="row justjfy-content-center"> <div class="col-xl-10 col-lg-12 col-md-9"> <div class="card o-hidden border-0 shadow-lg my-5"> <div class="card-body p-0">  <div class="row"> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 <div class="col-lg-6 d-none d-lg-block bg-login-image"></div> <div class="col-lg-6"> <div class="p-5"> <div class="text-center"> <h1 class="h4 text-gray-900 mb-4">Admin login!</h1> </div> <form class="user" method="post" actjon=""> <div class="form-group"> <input type="test" class="form-control form-control-user" id="username" name="username" aria- describedby="emailHelp" required="true" placeholder="Enter username ..."> </div> <div class="form-group"> <input type="password" class="form-control form-control-user" id="Password" name="Password" placeholder="Password" required="true"> </div> <p> <input type="submit" class="btn btn-primary btn-user btn-block" name="login" value="login"></p> <hr> </form> <hr> </div> </div> </div> </div> </div> </div> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 </div> </div>  <script src="../vendor/jquery/jquery.min.js"></script> <script src="../vendor/bootstrap/js/bootstrap.bundle.min.js"></script>  <script src="../vendor/jquery-easing/jquery.easing.min.js"></script>  <script src="../js/sb-admin-2.min.js"></script> </body> </html> Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

lOMoARcPSD|27817414 10 . CONCLUSION In this chapter, the results were discussed, problems faced and limitatjons were elaborated. Future recommendatjons for the extension and improvement of the system have also been discussed as well as well as an assessment of achieved functjonality. Downloaded by Prasansha Sharma (prasansha89.sharma@gmail.com)

95c1af74-f7cf-4c85-a845-1a2c4bb92f4a (1)