{"id":145,"date":"2014-01-21T07:28:50","date_gmt":"2014-01-21T07:28:50","guid":{"rendered":"http:\/\/projecthelpline.in\/myblog\/?p=145"},"modified":"2021-11-18T07:32:35","modified_gmt":"2021-11-18T07:32:35","slug":"mlis-project-synopsis-format","status":"publish","type":"post","link":"https:\/\/projecthelpline.in:\/myblog\/mlis-project-synopsis-format\/","title":{"rendered":"MLIS Project Synopsis Format"},"content":{"rendered":"<p>A<br \/>\nSynopsis<br \/>\nSubmitted in partial fulfillment of the requirements for<\/p>\n<p>1. INTRODUCTION AND OBJECTIVES<\/p>\n<p>LG Electronics, Inc.(LG) is a global leader and technology innovator in\u00a0 consumer electronics, home appliances and mobile communications,\u00a0 employing more than 82,000 people working in 114 operations\u00a0 including 82 subsidiaries around the world.<br \/>\nProviding the Best Service:<br \/>\nLG Customer Service Representatives are competent professionals with product knowledge expertise to assist customers with all technical support and service issues.\u00a0 LG Customer Service Representatives will take care to put the customer first by providing the utmost courtesy, empathy, and respect in all interactions with our customers.<br \/>\nLG Customer Service\u00a0Representatives respond with accurate information to provide fair solutions to all customer issues on the first interaction. It takes ownership, set accurate expectations, and follows through on all commitments so we never disappoint our Customers.<br \/>\nIndustry term referring a\u00a0contact centre, also known ascustomer interaction centre\u00a0is a\u00a0central point of any organization from which all customer contacts are managed. Through contact centres, valuable information about company are routed to appropriate people,\u00a0contacts to be tracked and data to be gathered.\u00a0It is generally a part of company\u2019s\u00a0customer relationship management (CRM).Today, customers contact companies by calling,\u00a0emailing, chatting online, visiting websites, faxing, and even instant messaging\u00a0and\u00a0to make an enquiry or request a Warranty repair: Type in your model name or number to find the contact number or policy for your product, you can submit a request for Service online.<\/p>\n<p><img decoding=\"async\" title=\"More...\" src=\"http:\/\/projecthelpline.in\/myblog\/wp-includes\/js\/tinymce\/plugins\/wordpress\/img\/trans.gif\" alt=\"\" \/><br \/>\nObjective:<br \/>\nThe L industry has skyrocketed to one of the most lucrative and important businesses in the world. Countries like India, Netherlands etc are the forerunners in the business. But leading countries like US and the UK are also fast catching up. With the rising competition, the\u00a0margin for error has become negligible. Each LG Customer care Service Center today employs\u00a0stringent quality measures\u00a0and constantly looks for improvement. In fact\u00a0LG Customer care Service\u00a0improvement services\u00a0are also extremely popular within the industry<\/p>\n<p>The objective of the Project is to\u00a0reduce the\u00a0man force\u00a0and\u00a0work load\u00a0and\u00a0making economical\u00a0and\u00a0real-time problem solving system\u00a0so that customer can\u00a0get response immediateand\u00a0queries can be managed quickly. Process dictates all the action that a company takes in order to\u00a0satisfy the customer,reduce costs\u00a0and gather market intelligence.<\/p>\n<p>Technology can help facilitate these processes through user driven systems development and maintenance. From the content perspective, the focus is on acquiring, engineering and maintaining knowledge and using the technology to distribute the information through various customer care media. The LG Customer Care computer system is not built to consider human circumstance but merely to process,\u00a0store and retrieve information.\u00a0The challenge is to\u00a0empower agents\u00a0by providing them not bycontact tracking systems\u00a0but with the sort of\u00a0information and authority\u00a0that will make every worthy\u00a0customer feel as though the company cares about him or her personally.<br \/>\nModules:<\/p>\n<p>Inbound cases\/tickets\u00a0 forms<br \/>\nResponse to the cases\/queries raised by the customer<br \/>\nChat\/Emails<br \/>\nCustomer Support<br \/>\nData entry of customers\u2019 electronic services Sign-up form<br \/>\nInbound tickets\/created by front end support staff<\/p>\n<p>Basic Information<br \/>\nCustomer Queries<br \/>\nLead Generation<br \/>\nDebit Cards<br \/>\nComplaints<br \/>\nTicket number generation<\/p>\n<p>Customer Support Emails<br \/>\nEmail address\u00a0\u00a0 support@navisite.com<br \/>\nReplies of emails after consulting the related specialty team<br \/>\nFollow-up calls\/emails wherever needed<br \/>\nDiverting cases to concern departments\/divisions<\/p>\n<p>3.\u00a0<span style=\"text-decoration: underline;\">ADVANTAGE<\/span><\/p>\n<p>This project is useful for the Manager who keeps track of all the customers in a particular Department. The following steps that give the detailed information of the need of proposed system are:<\/p>\n<p>Performance:\u00a0During past several decades, the records are supposed to be manually handled for all activities. The manual handling of the record is time consuming and highly prone to error. To improve the performance of the Institute, the computerized system is to be undertaken. The computerized project is fully computerized and user friendly even that any one (customer, helpdesk, agents, engineers) can use.<\/p>\n<p>Efficiency:\u00a0The basic need of this website is efficiency. The website should be efficient so that whenever a new user submits his\/her details the website is updated automatically. This record will be useful for other users instantly.<\/p>\n<p>Control:\u00a0The complete control of the project is under the hands of authorized person who has the password to access this project and illegal access is not supposed to deal with. All the control is under the administrator and the other members have the rights to just see the records not to change any transaction or entry.<\/p>\n<p>Security:\u00a0Security is the main criteria for the proposed system. Since illegal access may corrupt the database. So security has to be given in this project.<\/p>\n<p>4.\u00a0<span style=\"text-decoration: underline;\">PROJECT CATEGORY<\/span><br \/>\nThis Project is coupled with material on how to use the various tool, sub sets available in\u00a0ASP.NET AND SQL SERVER.<\/p>\n<p>The need of today\u2019s software development is competence in a GUI based front-end tool, which can connect to Relational Database engines. This gives the programmer the opportunity to develop client server based commercial applications.<\/p>\n<p>These applications give users the power and ease of a GUI with the multi user capabilities of Novell, UNIX or WinNT based RDBMS engines such as SQL SERVER.<\/p>\n<p>All the important coding techniques used by programmers, in OOPS based coding is brought out in full and in great detail.<br \/>\n<span style=\"text-decoration: underline;\"><br \/>\n<\/span>5.\u00a0<span style=\"text-decoration: underline;\">SYSTEM STUDY &amp; ANALYSIS<\/span><\/p>\n<p>PRINCIPLES OF SYSTEM ANALYSIS<\/p>\n<p>Understand the problem before you begin to create the analysis model.<\/p>\n<p>Develop prototypes that enable a user to understand how human machine interaction will occur.<\/p>\n<p>Record the origin of and the reason for every requirement.<\/p>\n<p>Use multiple views of requirements like building data, function and behavioral models.<\/p>\n<p>Work to eliminate ambiguity.<\/p>\n<p><span style=\"text-decoration: underline;\"><br \/>\n<\/span>ENTITY RELATIONSHIP DIAGRAM (ERD)<br \/>\nEntity \u2013 Relationship Diagram:\u00a0This depicts relationship between data objects. The attribute of each data objects noted in the entity- relationship diagram can be described using a data object description. Data flow diagram serves two purposes:<\/p>\n<p>To provide an indication of how data are transformed as they move through the system.<br \/>\nTo depict the functions that transformation the data flow.<\/p>\n<p>Data Objects:\u00a0A data object is a representation of almost any composite information that must be understood by the software. By composite information, we mean something that has a number of different properties or attributes. A data object encapsulates data only there is no reference within a data object to operations that act on the data.<\/p>\n<p>Attributes:\u00a0Attributes define the properties of a data object and take on one of three different characteristics. They can be used to:<br \/>\nName an instance of data object.<br \/>\nDescribe the instance.<br \/>\nMake reference to another instance in other table.<\/p>\n<p>Relationships:\u00a0Data objects are connected to one another in a variety of different ways. We can define a set of object relationship pairs that define the relevant relationships.<\/p>\n<p>q\u00a0<span style=\"text-decoration: underline;\">CARDINALITY AND MODALITY:<\/span><br \/>\nv\u00a0Cardinality:<br \/>\nThe data model must be capable of representing the number of occurrences of objects in a given relationship. The cardinality of an object relationship pair is<br \/>\n\u00a8\u00a0One-T0-One (1:1):\u00a0An occurrence of object \u2018A\u2019 can relate to one and only one occurrence of object \u2018B\u2019 and vice versa.<br \/>\n\u00a8\u00a0One-To-Many (1:N):\u00a0One occurrence of object \u2018A\u2019 can relate to one or may occurrences of object \u2018B\u2019 but an occurrence of object \u2018B\u2019 can relate to only one occurrence of object \u2018A\u2019.<br \/>\n\u00a8\u00a0Many-To-Many (M: N):\u00a0An occurrences of \u2018B\u2019 and an occurrence of \u2018B\u2019 can relate to one or many occurrence of \u2018A\u2019.<\/p>\n<p>v\u00a0Modality:<\/p>\n<p>The modality of a relationship is zero if there is no explicit need for the relationship to occur or the relationship is optional. The Modality is one if the occurrence of the relationship is mandatory.<\/p>\n<p>The object relationship pair can be represented graphically using the Entity Relationship Diagrams. A set of primary components are identified for the Entity Relationship Diagram,<\/p>\n<p>Attributes,<br \/>\nRelationships and<br \/>\nVarious Type Indicators.<br \/>\nThe primary purpose of the Entity Relationship Diagram is to represent data objects and their relationships.<\/p>\n<p>ER-DIAGRAM<\/p>\n<p><span style=\"text-decoration: underline;\">DATA MODELING<\/span><br \/>\nData modeling defines primary data objects, composition of each data object, and attributes of the object, relationships between each object and other objects and between objects and the processes.<br \/>\nList of Tables:<br \/>\nCustomer Care Registration- to store of the calla\\s attended by the customer care support team.<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"148\" valign=\"top\">Field Name<\/td>\n<td width=\"147\" valign=\"top\">Type<\/td>\n<td width=\"136\" valign=\"top\">Constraints<\/td>\n<td width=\"160\" valign=\"top\">Description<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Notification_no<\/td>\n<td width=\"147\" valign=\"top\">Int<\/td>\n<td width=\"136\" valign=\"top\">Primary Key<\/td>\n<td width=\"160\" valign=\"top\">Customer care registration<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Cust_no<\/td>\n<td width=\"147\" valign=\"top\">Int<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Customer Id<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Name<\/td>\n<td width=\"147\" valign=\"top\">Char (30)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Status<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Date_reg<\/td>\n<td width=\"147\" valign=\"top\">Date<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Date of reg<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Date_close<\/td>\n<td width=\"147\" valign=\"top\">Date<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Closing date<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Zone<\/td>\n<td width=\"147\" valign=\"top\">Char (30)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Zone<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Product<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Product<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Call_type<\/td>\n<td width=\"147\" valign=\"top\">Char (30)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Call type<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Taker<\/td>\n<td width=\"147\" valign=\"top\">Char (30)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Phone no<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Service_request<\/td>\n<td width=\"147\" valign=\"top\">Char (30)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Type of request<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Priority<\/td>\n<td width=\"147\" valign=\"top\">Char \u201c(30)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Priority of complaint<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Remark<\/td>\n<td width=\"147\" valign=\"top\">Char (30)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Remark<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Sign_by<\/td>\n<td width=\"147\" valign=\"top\">Char (30)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Signed by<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Attend_by<\/td>\n<td width=\"147\" valign=\"top\">Char (30)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Call attended by<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Email<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Email_id<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Ticket_no<\/td>\n<td width=\"147\" valign=\"top\">Number(5)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Trouble Ticket no<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Customers: To store details of the customers<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"149\" valign=\"top\">Field Name<\/td>\n<td width=\"147\" valign=\"top\">Type<\/td>\n<td width=\"136\" valign=\"top\">Constraints<\/td>\n<td width=\"161\" valign=\"top\">Description<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Cust_no<\/td>\n<td width=\"147\" valign=\"top\">Char (30)<\/td>\n<td width=\"136\" valign=\"top\">Primary Key<\/td>\n<td width=\"161\" valign=\"top\">Customer_no<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Title<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Title<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Lastname<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Last name<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">First name<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">First name<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">House no<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">House no<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Add1<\/td>\n<td width=\"147\" valign=\"top\">Char (30)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Address 1<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Add2<\/td>\n<td width=\"147\" valign=\"top\">Char (30)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Address 2<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Locality<\/td>\n<td width=\"147\" valign=\"top\">Char (30)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Area<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Land Mark<\/td>\n<td width=\"147\" valign=\"top\">Char (30)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Landmark<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">City<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">City<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Pincode<\/td>\n<td width=\"147\" valign=\"top\">Number(10)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Pin code<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Phone<\/td>\n<td width=\"147\" valign=\"top\">Number(10)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Contact no<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Add proof<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Address proof<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Appliance<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Appliance<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Cust_type<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Customer type<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Date_of_purchase<\/td>\n<td width=\"147\" valign=\"top\">Date<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Date of purchase<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Department: To strore details of the department<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"147\" valign=\"top\">Field Name<\/td>\n<td width=\"146\" valign=\"top\">Type<\/td>\n<td width=\"135\" valign=\"top\">Constraints<\/td>\n<td width=\"159\" valign=\"top\">Description<\/td>\n<\/tr>\n<tr>\n<td width=\"147\" valign=\"top\">Dept_no<\/td>\n<td width=\"146\" valign=\"top\">Char (30)<\/td>\n<td width=\"135\" valign=\"top\">Primary Key<\/td>\n<td width=\"159\" valign=\"top\">Department no<\/td>\n<\/tr>\n<tr>\n<td width=\"147\" valign=\"top\">Dept_ name<\/td>\n<td width=\"146\" valign=\"top\">Char (50)<\/td>\n<td width=\"135\" valign=\"top\">Not Null<\/td>\n<td width=\"159\" valign=\"top\">Department Name<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Employee:\u00a0To store details of the employee working in the LG Customer Care Service center.<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"149\" valign=\"top\">Field Name<\/td>\n<td width=\"147\" valign=\"top\">Type<\/td>\n<td width=\"136\" valign=\"top\">Constraints<\/td>\n<td width=\"161\" valign=\"top\">Description<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Emp_no<\/td>\n<td width=\"147\" valign=\"top\">Char (30)<\/td>\n<td width=\"136\" valign=\"top\">Primary Key<\/td>\n<td width=\"161\" valign=\"top\">Employee no<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Firat name<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">First Name<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Last Name<\/td>\n<td width=\"147\" valign=\"top\">Char (30)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Last Name<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Add1<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Address1<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Add2<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Address2<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">City<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">City<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Pin code<\/td>\n<td width=\"147\" valign=\"top\">Number(10)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Pin code<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Phone<\/td>\n<td width=\"147\" valign=\"top\">Number(10)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Contact no<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Department<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Department<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Designation<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Designation<\/td>\n<\/tr>\n<tr>\n<td width=\"149\" valign=\"top\">Salary<\/td>\n<td width=\"147\" valign=\"top\">Number (5)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">salary<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>User details:\u00a0To store details of the users<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"150\" valign=\"top\">Field Name<\/td>\n<td width=\"148\" valign=\"top\">Type<\/td>\n<td width=\"137\" valign=\"top\">Constraints<\/td>\n<td width=\"161\" valign=\"top\">Description<\/td>\n<\/tr>\n<tr>\n<td width=\"150\" valign=\"top\">Username<\/td>\n<td width=\"148\" valign=\"top\">Char(30)<\/td>\n<td width=\"137\" valign=\"top\">Not null<\/td>\n<td width=\"161\" valign=\"top\">Username<\/td>\n<\/tr>\n<tr>\n<td width=\"150\" valign=\"top\">Password<\/td>\n<td width=\"148\" valign=\"top\">Char(30)<\/td>\n<td width=\"137\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Password<\/td>\n<\/tr>\n<tr>\n<td width=\"150\" valign=\"top\">Email<\/td>\n<td width=\"148\" valign=\"top\">Char (30)<\/td>\n<td width=\"137\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Email<\/td>\n<\/tr>\n<tr>\n<td width=\"150\" valign=\"top\">Security question<\/td>\n<td width=\"148\" valign=\"top\">Char (50)<\/td>\n<td width=\"137\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Security question used in forget password form<\/td>\n<\/tr>\n<tr>\n<td width=\"150\" valign=\"top\">Answer<\/td>\n<td width=\"148\" valign=\"top\">Char (50)<\/td>\n<td width=\"137\" valign=\"top\">Not Null<\/td>\n<td width=\"161\" valign=\"top\">Answer<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Email:\u00a0To store details of the email send to the customers, to reply customers after consulting the related specialty team.<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" width=\"592\">\n<tbody>\n<tr>\n<td width=\"148\" valign=\"top\">Field Name<\/td>\n<td width=\"147\" valign=\"top\">Type<\/td>\n<td width=\"136\" valign=\"top\">Constraints<\/td>\n<td width=\"160\" valign=\"top\">Description<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Email_id<\/td>\n<td width=\"147\" valign=\"top\">Char(30)<\/td>\n<td width=\"136\" valign=\"top\">Not null<\/td>\n<td width=\"160\" valign=\"top\">Email id<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Cust_no<\/td>\n<td width=\"147\" valign=\"top\">Char (50)<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Customer no<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Adte<\/td>\n<td width=\"147\" valign=\"top\">Date<\/td>\n<td width=\"136\" valign=\"top\">Not Null<\/td>\n<td width=\"160\" valign=\"top\">Date<\/td>\n<\/tr>\n<tr>\n<td width=\"148\" valign=\"top\">Comment<\/td>\n<td width=\"147\" valign=\"top\">Char (250)<\/td>\n<td width=\"136\" valign=\"top\">Not null<\/td>\n<td width=\"160\" valign=\"top\">Comment\u00a0 or reply<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Ticket Table:\u00a0To store details of the trouble tickets submitted by the customers.<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"151\" valign=\"top\">Field Name<\/td>\n<td width=\"150\" valign=\"top\">Type<\/td>\n<td width=\"139\" valign=\"top\">Constraints<\/td>\n<td width=\"163\" valign=\"top\">Description<\/td>\n<\/tr>\n<tr>\n<td width=\"151\" valign=\"top\">Ticket _no<\/td>\n<td width=\"150\" valign=\"top\">Char(30)<\/td>\n<td width=\"139\" valign=\"top\">Primary Key<\/td>\n<td width=\"163\" valign=\"top\">Trouble ticket no<\/td>\n<\/tr>\n<tr>\n<td width=\"151\" valign=\"top\">Date<\/td>\n<td width=\"150\" valign=\"top\">Date<\/td>\n<td width=\"139\" valign=\"top\">Not Null<\/td>\n<td width=\"163\" valign=\"top\">Date of generating<\/td>\n<\/tr>\n<tr>\n<td width=\"151\" valign=\"top\">Priority<\/td>\n<td width=\"150\" valign=\"top\">Char (30)<\/td>\n<td width=\"139\" valign=\"top\">Not Null<\/td>\n<td width=\"163\" valign=\"top\">Priority<\/td>\n<\/tr>\n<tr>\n<td width=\"151\" valign=\"top\">Subject<\/td>\n<td width=\"150\" valign=\"top\">Char (50)<\/td>\n<td width=\"139\" valign=\"top\">Not Null<\/td>\n<td width=\"163\" valign=\"top\">Subject<\/td>\n<\/tr>\n<tr>\n<td width=\"151\" valign=\"top\">Description<\/td>\n<td width=\"150\" valign=\"top\">Char (250)<\/td>\n<td width=\"139\" valign=\"top\">Not Null<\/td>\n<td width=\"163\" valign=\"top\">Description<\/td>\n<\/tr>\n<tr>\n<td width=\"151\" valign=\"top\">Type<\/td>\n<td width=\"150\" valign=\"top\">Char (50)<\/td>\n<td width=\"139\" valign=\"top\">Not Null<\/td>\n<td width=\"163\" valign=\"top\">Type<\/td>\n<\/tr>\n<tr>\n<td width=\"151\" valign=\"top\">Email<\/td>\n<td width=\"150\" valign=\"top\">Char (50)<\/td>\n<td width=\"139\" valign=\"top\">Not Null<\/td>\n<td width=\"163\" valign=\"top\">Email id<\/td>\n<\/tr>\n<tr>\n<td width=\"151\" valign=\"top\">Cust_id<\/td>\n<td width=\"150\" valign=\"top\">Char (50)<\/td>\n<td width=\"139\" valign=\"top\">Not Null<\/td>\n<td width=\"163\" valign=\"top\">Customer id<\/td>\n<\/tr>\n<tr>\n<td width=\"151\" valign=\"top\">Cust_name<\/td>\n<td width=\"150\" valign=\"top\">Char (50)<\/td>\n<td width=\"139\" valign=\"top\">Not Null<\/td>\n<td width=\"163\" valign=\"top\">Customer Name<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Accounts Table:\u00a0To store details of the Transactions.<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"153\" valign=\"top\">Field Name<\/td>\n<td width=\"151\" valign=\"top\">Type<\/td>\n<td width=\"140\" valign=\"top\">Constraints<\/td>\n<td width=\"165\" valign=\"top\">Description<\/td>\n<\/tr>\n<tr>\n<td width=\"153\" valign=\"top\">Account_no<\/td>\n<td width=\"151\" valign=\"top\">Number(10)<\/td>\n<td width=\"140\" valign=\"top\">Primary Key<\/td>\n<td width=\"165\" valign=\"top\">Details of accounts No.<\/td>\n<\/tr>\n<tr>\n<td width=\"153\" valign=\"top\">Bank_name<\/td>\n<td width=\"151\" valign=\"top\">Char (30)<\/td>\n<td width=\"140\" valign=\"top\">Not Null<\/td>\n<td width=\"165\" valign=\"top\">Name of the bank<\/td>\n<\/tr>\n<tr>\n<td width=\"153\" valign=\"top\">Credit_card_type<\/td>\n<td width=\"151\" valign=\"top\">Char (30)<\/td>\n<td width=\"140\" valign=\"top\">Not Null<\/td>\n<td width=\"165\" valign=\"top\">Visa\/ Master card<\/td>\n<\/tr>\n<tr>\n<td width=\"153\" valign=\"top\">Amount_mode<\/td>\n<td width=\"151\" valign=\"top\">Char (30)<\/td>\n<td width=\"140\" valign=\"top\">Not Null<\/td>\n<td width=\"165\" valign=\"top\">Online\/ western union\/<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ol>\n<li><span style=\"text-decoration: underline;\"><br \/>\n<\/span><\/li>\n<\/ol>\n<p><span style=\"text-decoration: underline;\">Context Level DFD for LG Customer Care Service Management System <\/span><\/p>\n<p><span style=\"text-decoration: underline;\">DFD FOR CUSTOMER COMPLAINT<\/span><\/p>\n<p>Customer<\/p>\n<p><span style=\"text-decoration: underline;\">DFD FOR LG CUSTOMER CARE CENTER EXECUTIVE (EMPLOYEE)<\/span><\/p>\n<p><span style=\"text-decoration: underline;\">DFD FOR MONITORING<\/span><\/p>\n<p><span style=\"text-decoration: underline;\">DFD FOR COMPLAINT TICKET<\/span><\/p>\n<p>6.\u00a0<span style=\"text-decoration: underline;\">A COMPLETE STRUCTURE<\/span><\/p>\n<p>Project Plan, Design &amp; Approach<br \/>\nThe proposed project will have its main page and will be mainly divided into partially dependent and partially independent modules as:<br \/>\nLOGIN MODULE<br \/>\nCUSTOMER MASTER<br \/>\nEMPLOYEE MASTER<br \/>\nUPDATE DETAILS MODULE<br \/>\nSEARCH MASTER<br \/>\nREPORT GENERATION MODULE<br \/>\nVALIDATION HANDLER<br \/>\nCOMPLAINT DETAILS<br \/>\nTROUBLE TICKETS MASTER<br \/>\nMANAGING\u00a0INBOUND TICKETS\/CREATED BY FRONT END SUPPORT STAFF<br \/>\n<span style=\"text-decoration: underline;\">**These modules are described below**<\/span><br \/>\n<span style=\"text-decoration: underline;\">1. LOGIN MODULE<\/span><br \/>\nLogin master is the module which checks for a valid candidate when the user enters his user id, password, and link to the correct page or denies and link to the registration page. It is divided in to following functions.<\/p>\n<p>A.\u00a0USERID CHECKER<br \/>\nAs user id rules the system so a person is known by his uniqueness of his user id. As it is to provide the viable customer system .so the user id is being validated with password in different cases to validate the genuineness of the candidate.<\/p>\n<p>B.\u00a0\u00a0\u00a0 \u00a0THE LOGIN STATUS MANAGER.<br \/>\nThis module keeps the status of the user when logged in and for which purpose and for how much time. As it is an integral part for a paid site to track the user login status if user not logon for certain period of time then their account will be in suspended mode or expires.<br \/>\n<span style=\"text-decoration: underline;\">2. CUSTOMER MASTER<\/span><br \/>\nThis module deals with the different state of registration as:<br \/>\na).\u00a0Customer building form will be displayed in this module.<br \/>\nb).\u00a0Clint side validations being handled by validation master<br \/>\nc).\u00a0Unique customer id checker (checks that the user id being entered by the candidate is unique or not.<br \/>\nd).\u00a0Auto user id generator generates auto user id in user id field by taking the email id of the user if it is unique or suggest by combining it with some number.<br \/>\ne).\u00a0All data about any new customers of LG Customer care will be stored in\u00a0database.<br \/>\n<span style=\"text-decoration: underline;\">3. DETAILS UPDATE MODULE<\/span><br \/>\nDetails update module is to deal with updating of profile; with the help of this module one can change\/update either her\/his own profile or partner\u2019s profile.<br \/>\n<span style=\"text-decoration: underline;\">4. <\/span><span style=\"text-decoration: underline;\">INBOUND TICKETS\/CREATED BY FRONT END SUPPORT STAFF<\/span><\/p>\n<p>Basic Information<br \/>\nCustomer Queries<br \/>\nLead Generation<br \/>\nDebit Cards<br \/>\nComplaints<br \/>\nTicket number generation<\/p>\n<p><span style=\"text-decoration: underline;\">5. SEARCH MODULE<\/span><br \/>\nThe main objective of this module is to search the specific details in the project for the customers and administrator the company can send him\/her information, through mail on their e-mail address from the database. The project sends the information to their users according to their requirements.<br \/>\nThen it becomes so easy to the administrator to contact the person through this Project.<br \/>\n<span style=\"text-decoration: underline;\"><br \/>\n<\/span><span style=\"text-decoration: underline;\">7.<\/span><span style=\"text-decoration: underline;\"> Report Generation Module<\/span><\/p>\n<p>This module specially used by the project master or administrator of Project. The main objective of this module is to give the interface to the administrator of Project, so they can manage whole Project. They can view different types of reports like customers details, trouble ticket details, how many tickets generated through Project, what their status etc. In other word we can say that this module is the main module of the site and with the help of this module administrator is able to manage whole Project.<br \/>\n<span style=\"text-decoration: underline;\">8: SEARCH MASTER<\/span><br \/>\nSearch module is an important module in any web site. With the help of this module visitor can search their requirements. An enhanced search tool is made to search data according to different criteria.<br \/>\n<span style=\"text-decoration: underline;\">9: VALIDATION HANDLER<\/span><br \/>\nValidation handler module works with the validations given within the complete running program. This module basically deals with the validation of different entries done during resume building process. This module deals with the discrepancies such as incorrect e-mail, date of birth, address, phone number, amount mode, Cheque number, bank name, credit card number etc in the profile making process and payment process. This module specially integrated with the different pages and forms checks all the given description given in the form by the user to make the system robust, reliable and error free. To finally deal with the any wrong entries being done by the user it validates as well as suggests for correct input.<\/p>\n<p><span style=\"text-decoration: underline;\">10: RESPONSE MASTER<\/span><br \/>\nCustomer Support Emails<\/p>\n<p>Email address\u00a0\u00a0 support@navisite.com<br \/>\nReplies of emails after consulting the related specialty team<br \/>\nFollow-up calls\/emails wherever needed<br \/>\nDiverting cases to concern departments\/divisions<br \/>\nThe administrators use the response master specially. Basically the use of this module is to help the administrator to response any customer according to his trouble ticket. If the administrator find any suitable solution, they can response to any customer and also can contact those person through this response master.<br \/>\n<span style=\"text-decoration: underline;\">11. TROUBLE TICKETS<\/span><br \/>\nThis module is specially meant for customers to get help from the customer care. Trouble ticket forms are filled by the customers; they get notification no. or trouble ticket no. Now when the customer contact or call in the call centre they are asked for their trouble ticket no..As the customer give his tt.no., He get the response or get the duration under which\u00a0 he will get the response.<br \/>\n<span style=\"text-decoration: underline;\"><br \/>\n<\/span><span style=\"text-decoration: underline;\">12. MANAGING <\/span><span style=\"text-decoration: underline;\">INBOUND TICKETS\/CREATED BY FRONT END SUPPORT STAFF<\/span><\/p>\n<p>Basic Information<br \/>\nCustomer Queries<br \/>\nLead Generation<br \/>\nDebit Cards<br \/>\nComplaints<br \/>\nTicket number generation<br \/>\nProcess Logic for Each Module:<\/p>\n<p><span style=\"text-decoration: underline;\">In the\u00a0first\u00a0module<\/span>, validity of password is checked against a particular user.<\/p>\n<p><span style=\"text-decoration: underline;\">In the\u00a0second\u00a0module<\/span>, whenever a new entity is entered it should be checked for the duplicate data.<\/p>\n<p><span style=\"text-decoration: underline;\">In the\u00a0third\u00a0and\u00a0fourth\u00a0module<\/span>, just like the first module it should have the proper checks for every entity being modified or updated.<\/p>\n<p><span style=\"text-decoration: underline;\">In the\u00a0fifth\u00a0and\u00a0sixth\u00a0module<\/span>, again the validation checks are made and the different reports are generated to ease the business processes and decision making.<\/p>\n<p>Report Generation<br \/>\n&#8216;Crystal Reports&#8217;\u00a0is a popular third party package that is included with ASP.NET, which allows you to create reports for your application. The package consists of a designer &#8211; where you can design and test the reports, Crystal Reports API calls and Crystal Report Viewer control. The reports generated by the administrator are<\/p>\n<p>v\u00a0 Users Details<br \/>\nv\u00a0 Calls Details<br \/>\nv\u00a0 Details of the Trouble Tickets Generated by the customers.<br \/>\nv\u00a0 Details of the\u00a0 Tickets Solved<br \/>\nv\u00a0 Feedback Reports<br \/>\nv\u00a0 Customer Details.<\/p>\n<p>7<span style=\"text-decoration: underline;\">. TOOLS \/ PLATFORM, HARDWARE AND SOFTWARE REQUIREMENT SPECIFICATION<\/span><br \/>\n<span style=\"text-decoration: underline;\">HARDWARE:<\/span><\/p>\n<p>Processor\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Pentium 2.4 GHz or above<br \/>\nMemory\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 256 MB RAM or above<br \/>\nCache Memory\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 128 KB or above<br \/>\nPrinter\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Laser Printer<br \/>\nPen Drive\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 GB<\/p>\n<p><span style=\"text-decoration: underline;\">SOFTWARE:<\/span><\/p>\n<p>Operating System\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Windows XP (Professional).<br \/>\nFont-End Tool\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ASP.NET<br \/>\nBack-End \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQL Server 2000<br \/>\n<span style=\"text-decoration: underline;\">.NET FRAMEWORK<\/span><\/p>\n<p>Advantages of the .NET Framework<\/p>\n<p>Some advantages of the .NET Framework are:Consistent programming model<br \/>\nMulti-platform applications<br \/>\nMulti-language integration<br \/>\nAutomatic resource management<br \/>\nEase of deployment<br \/>\nSecurity<br \/>\nEvidence-based security (authentication)<br \/>\nBased on user identity and code identity<br \/>\nConfigurable policies<br \/>\nImperative and declarative interfaces<\/p>\n<p><span style=\"text-decoration: underline;\"><br \/>\n<\/span><span style=\"text-decoration: underline;\">SQL SERVER<\/span><br \/>\nMicrosoft SQL Server is an application used to create computer databases for the Microsoft Windows family of server operating systems. It provides an environment used to generate databases that can be accessed from workstations, the web, or other media such as a personal digital assistant (PDA). Microsoft SQL Server is probably the most accessible and the most documented enterprise database environment right now. This also means that you can learn it a little quicker than most other database environments on the market.<\/p>\n<p>v\u00a0 The project is based on multi-tier architecture where the application is divided into three logical constituents-<\/p>\n<p>User Services \u2013 Provide services such as user interface.\u00a0(Asp.Net, C#\u00a0application in this case).<br \/>\nCustomer Business services \u2013 Implement business rules as per the requirement of the customer query<br \/>\nData Services \u2013 Provide handling and validation of data. (SQL-SERVER\u00a0in this case). Example case number, customer organization number, core team specialty code, engineer code and alias etc.<\/p>\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"23\" height=\"15\"><\/td>\n<td width=\"1\"><\/td>\n<td width=\"113\"><\/td>\n<td width=\"90\"><\/td>\n<td width=\"162\"><\/td>\n<td width=\"78\"><\/td>\n<td width=\"126\"><\/td>\n<td width=\"11\"><\/td>\n<\/tr>\n<tr>\n<td height=\"77\"><\/td>\n<td><\/td>\n<td colspan=\"6\" align=\"left\" valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td height=\"20\"><\/td>\n<\/tr>\n<tr>\n<td height=\"42\"><\/td>\n<td colspan=\"2\" rowspan=\"2\" width=\"114\" height=\"55\" bgcolor=\"#DDDDDD\">\n<table cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">\n<tbody>\n<tr>\n<td>Client end<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<td><\/td>\n<td width=\"162\" height=\"42\" bgcolor=\"#DDDDDD\">\n<table cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">\n<tbody>\n<tr>\n<td>Business Logic<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<td><\/td>\n<td rowspan=\"3\" width=\"126\" height=\"67\" bgcolor=\"#DDDDDD\">\n<table cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">\n<tbody>\n<tr>\n<td>Data Repository<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<tr>\n<td height=\"13\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Software requirements:-\u00a0.Net is used for front end application (ASP.NET, C#, AJAX, JAVA-SCRIPT, J-QUERY and CSS.)<br \/>\n8.\u00a0<span style=\"text-decoration: underline;\">SECURITY AND VALIDATION CHECKS<\/span><br \/>\nSoftware\u2019s Vulnerability to Attack<\/p>\n<p>Software development is not yet a science or a rigorous discipline, and the development process by and large is not controlled to minimize the vulnerabilities that attackers exploit.<br \/>\nThe security of software is threatened at various points throughout its life cycle, both by inadvertent and intentional choices and actions taken by \u201cinsiders\u201d\u2014individuals closely affiliated with the organization that is producing, deploying, operating, or maintaining the software, and thus trusted by that organization\u2014and by \u201coutsiders\u201d who have no affiliation with the organization. The software\u2019s security can be threatened<\/p>\n<p>During its development:\u00a0A developer may corrupt the software\u2014intentionally or unintentionally\u2014in ways that will compromise the software\u2019s dependability and trustworthiness when it is operational.<br \/>\nDuring its deployment (distribution and installation):\u00a0If those responsible for distributing the software fail to tamperproof the software before shipping or uploading, or transmit it over easily intercepted communications channels, they leave the software vulnerable to intentional or unintentional corruption. Similarly, if the software\u2019s installer fails to \u201clock down\u201d the host platform, or configures the software insecurely, the software is left vulnerable to access by attackers.<br \/>\nDuring its operation:\u00a0Once COTS and open source software has gone operational, vulnerabilities may be discovered and publicized; unless security patches and updates are applied and newer supported versions (from which the root causes of vulnerabilities have been eliminated) are adopted, such software will become increasingly vulnerable. Non-commercial software and open source software (OSS) may also be vulnerable, especially as it may manifest untrustworthy behaviors over time due to changes in its environment that stress the software in ways that were not anticipated and simulated during its testing.<br \/>\nDuring its sustainment:\u00a0If those responsible for addressing discovered vulnerabilities in released software fail to issue patches or updates in a timely manner, or fail to seek out and eliminate the root causes of the vulnerabilities to prevent their perpetuation in future releases of the software, the software will become increasingly vulnerable to threats over time. Also, the software\u2019s maintainer may prove to be a malicious insider, and may embed malicious code, exploitable flaws, etc., in updated versions of the code.<br \/>\nThe Challenge of Building Secure Software:-<\/p>\n<p>Dependability:\u00a0Dependable software executes predictably and operates correctly under all conditions, including hostile conditions, including when the software comes under attack or runs on a malicious host.<br \/>\nTrustworthiness:\u00a0Trustworthy software contains few if any vulnerabilities or weaknesses that can be intentionally exploited to subvert or sabotage the software\u2019s dependability. In addition, to be considered trustworthy, the software must contain no malicious logic that causes it to behave in a malicious manner.<br \/>\nSurvivability (also referred to as \u201cResilience\u201d):\u00a0Survivable\u2014or resilient\u2014software is software that is resilient enough to (1) either resist (i.e., protect itself against) or tolerate (i.e., continue operating dependably in spite of) most known attacks plus as many novel attacks as possible, and (2) recover as quickly as possible, and with as little damage as possible, from those attacks that it can neither resist nor tolerate<\/p>\n<p>9.\u00a0<span style=\"text-decoration: underline;\">FUTURE SCOPE OF THE PROJECT<\/span><br \/>\nLike all other systems this system will remain feasible in the long run only if it provides the solutions to the\u00a0current and future needs\u00a0of the LG Customer Care centers and must be up to date as per the requirement of the Customer Care, it\u00a0should evolvecontinually\u00a0so as to incorporate the necessary changes.<\/p>\n<ol>\n<li>Currently it is intended to be running on ASP.Net; I am updating it so that it can have\u00a0more subjects\u00a0so that everybody having different knowledge can test his\/her capabilities.<\/li>\n<\/ol>\n<p>CCMS\u00a0on Mobile phone is one of the upcoming ideas to upgrade this software. C# is compatible with WML used in mobile programming using XML and ASP.<br \/>\nThe project can also be upgraded to run on networking protocols.<br \/>\nCompatible with\u00a0.Net plate-form\u00a0to easily handle with other\u00a0MS Programming Language.<\/p>\n<p>.NET APPLICATION<\/p>\n<table cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"34\" height=\"4\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>ASP\/XML<\/p>\n<p>WML<\/p>\n<p>(Database Management System)<\/p>\n<p>10.\u00a0<span style=\"text-decoration: underline;\">Conclusion<\/span><br \/>\nThis project is designed to meet the requirements of\u00a0LG Customer Care Service Management System. It will be developed in ASP.Net, keeping in mind the specifications of the system.<\/p>\n<p>For designing the system we have used simple data flow diagrams.<\/p>\n<p>Overall the project teaches us the essential skills like:<\/p>\n<p>q\u00a0 Using system analysis and design techniques like data flow diagram in designing the system.<br \/>\nq\u00a0 Understanding the database handling and query processing<\/p>\n<p>11.\u00a0<span style=\"text-decoration: underline;\">Bibliography<\/span><\/p>\n<p>Complete References in C#, BPB publications<br \/>\nUsing SQL-SERVER 2000, Microsoft publication<br \/>\nSQL-SERVER 2000 BPB publication<br \/>\n4.\u00a0\u00a0 C# and ASP.NET Projects book,<a href=\"http:\/\/www.alibaba.com\/company\/101269058.html\" target=\"_blank\">BPB Publications<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A Synopsis Submitted in partial fulfillment of the requirements for 1. INTRODUCTION AND OBJECTIVES LG Electronics, Inc.(LG) is a global leader and technology innovator.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[48,53,52],"tags":[61,59,62,1157,1156,64],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.13 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MLIS Project Synopsis Format - projecthelpline.in<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MLIS Project Synopsis Format - projecthelpline.in\" \/>\n<meta property=\"og:description\" content=\"A Synopsis Submitted in partial fulfillment of the requirements for 1. INTRODUCTION AND OBJECTIVES LG Electronics, Inc.(LG) is a global leader and technology innovator.\" \/>\n<meta property=\"og:url\" content=\"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/\" \/>\n<meta property=\"og:site_name\" content=\"projecthelpline.in\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/projecthelpline.in\/\" \/>\n<meta property=\"article:published_time\" content=\"2014-01-21T07:28:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-18T07:32:35+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/projecthelpline.in\/myblog\/wp-includes\/js\/tinymce\/plugins\/wordpress\/img\/trans.gif\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"20 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#\/schema\/person\/0604c6074dabbd2694ca80fe7c97b535\"},\"headline\":\"MLIS Project Synopsis Format\",\"datePublished\":\"2014-01-21T07:28:50+00:00\",\"dateModified\":\"2021-11-18T07:32:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/\"},\"wordCount\":3988,\"publisher\":{\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#organization\"},\"keywords\":[\"BLIS\",\"ignou\",\"MLIB\",\"MLIS\",\"PGDLAN\",\"Uncategorized and tagged BLIB\"],\"articleSection\":[\"IGNOU\",\"MLIS\",\"PGDLAN\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/\",\"url\":\"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/\",\"name\":\"MLIS Project Synopsis Format - projecthelpline.in\",\"isPartOf\":{\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#website\"},\"datePublished\":\"2014-01-21T07:28:50+00:00\",\"dateModified\":\"2021-11-18T07:32:35+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/projecthelpline.in\/myblog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MLIS Project Synopsis Format\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#website\",\"url\":\"https:\/\/projecthelpline.in\/myblog\/\",\"name\":\"projecthelpline.in\",\"description\":\"For Project &amp; Synopsis Contact us At :  9015596280, 9313565406, 9212129290\",\"publisher\":{\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/projecthelpline.in\/myblog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#organization\",\"name\":\"projecthelpline.in\",\"url\":\"https:\/\/projecthelpline.in\/myblog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/projecthelpline.in\/myblog\/wp-content\/uploads\/2014\/12\/shortcut-e1668252618758.png\",\"contentUrl\":\"https:\/\/projecthelpline.in\/myblog\/wp-content\/uploads\/2014\/12\/shortcut-e1668252618758.png\",\"width\":50,\"height\":59,\"caption\":\" projecthelpline.in\"},\"image\":{\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/projecthelpline.in\/\",\"https:\/\/twitter.com\/Projecthelplin2\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#\/schema\/person\/0604c6074dabbd2694ca80fe7c97b535\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/projecthelpline.in\/myblog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5aa4fa5458dff6e2873dc279949566e3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5aa4fa5458dff6e2873dc279949566e3?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/projecthelpline.in:\/myblog\/author\/proadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MLIS Project Synopsis Format - projecthelpline.in","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/","og_locale":"en_US","og_type":"article","og_title":"MLIS Project Synopsis Format - projecthelpline.in","og_description":"A Synopsis Submitted in partial fulfillment of the requirements for 1. INTRODUCTION AND OBJECTIVES LG Electronics, Inc.(LG) is a global leader and technology innovator.","og_url":"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/","og_site_name":"projecthelpline.in","article_publisher":"https:\/\/www.facebook.com\/projecthelpline.in\/","article_published_time":"2014-01-21T07:28:50+00:00","article_modified_time":"2021-11-18T07:32:35+00:00","og_image":[{"url":"http:\/\/projecthelpline.in\/myblog\/wp-includes\/js\/tinymce\/plugins\/wordpress\/img\/trans.gif"}],"author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"20 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/#article","isPartOf":{"@id":"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/"},"author":{"name":"admin","@id":"https:\/\/projecthelpline.in\/myblog\/#\/schema\/person\/0604c6074dabbd2694ca80fe7c97b535"},"headline":"MLIS Project Synopsis Format","datePublished":"2014-01-21T07:28:50+00:00","dateModified":"2021-11-18T07:32:35+00:00","mainEntityOfPage":{"@id":"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/"},"wordCount":3988,"publisher":{"@id":"https:\/\/projecthelpline.in\/myblog\/#organization"},"keywords":["BLIS","ignou","MLIB","MLIS","PGDLAN","Uncategorized and tagged BLIB"],"articleSection":["IGNOU","MLIS","PGDLAN"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/","url":"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/","name":"MLIS Project Synopsis Format - projecthelpline.in","isPartOf":{"@id":"https:\/\/projecthelpline.in\/myblog\/#website"},"datePublished":"2014-01-21T07:28:50+00:00","dateModified":"2021-11-18T07:32:35+00:00","breadcrumb":{"@id":"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/projecthelpline.in\/myblog\/mlis-project-synopsis-format\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/projecthelpline.in\/myblog\/"},{"@type":"ListItem","position":2,"name":"MLIS Project Synopsis Format"}]},{"@type":"WebSite","@id":"https:\/\/projecthelpline.in\/myblog\/#website","url":"https:\/\/projecthelpline.in\/myblog\/","name":"projecthelpline.in","description":"For Project &amp; Synopsis Contact us At :  9015596280, 9313565406, 9212129290","publisher":{"@id":"https:\/\/projecthelpline.in\/myblog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/projecthelpline.in\/myblog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/projecthelpline.in\/myblog\/#organization","name":"projecthelpline.in","url":"https:\/\/projecthelpline.in\/myblog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/projecthelpline.in\/myblog\/#\/schema\/logo\/image\/","url":"https:\/\/projecthelpline.in\/myblog\/wp-content\/uploads\/2014\/12\/shortcut-e1668252618758.png","contentUrl":"https:\/\/projecthelpline.in\/myblog\/wp-content\/uploads\/2014\/12\/shortcut-e1668252618758.png","width":50,"height":59,"caption":" projecthelpline.in"},"image":{"@id":"https:\/\/projecthelpline.in\/myblog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/projecthelpline.in\/","https:\/\/twitter.com\/Projecthelplin2"]},{"@type":"Person","@id":"https:\/\/projecthelpline.in\/myblog\/#\/schema\/person\/0604c6074dabbd2694ca80fe7c97b535","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/projecthelpline.in\/myblog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5aa4fa5458dff6e2873dc279949566e3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5aa4fa5458dff6e2873dc279949566e3?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/projecthelpline.in:\/myblog\/author\/proadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/posts\/145"}],"collection":[{"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/comments?post=145"}],"version-history":[{"count":2,"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/posts\/145\/revisions"}],"predecessor-version":[{"id":2073,"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/posts\/145\/revisions\/2073"}],"wp:attachment":[{"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/media?parent=145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/categories?post=145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/projecthelpline.in:\/myblog\/wp-json\/wp\/v2\/tags?post=145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}