College Management System free essay sample

Computerized college management system is developed to facilitate the general administration system to manage the various information of student and employees involved in college. So, that college can access accurate information quickly and easily as and when required, thereby improving its operational efficiency and effectiveness. 1. 1Problem Statement In case of manual system they need a lot of time, manpower etc. Here almost all work is computerized. So the accuracy is maintained. College Management System mainly deals with Employee Profile, Payroll Management and Fee collection which can be managed by the Admin. 1. 2 Objectives †¢ Create employee details, achievements and workshop they have conducted †¢ Calculate the employee salary in payroll management †¢ Store the fee details of students and view CHAPTER 2 LITERATURE SURVEY 2. 1 Introduction Today in colleges student details are entered manually. The student details in separate records are tedious task. Referring to all these records and updating is needed. There is a chance for more manual errors. By developing the system we can attain the following facilities. ? Easy to handle and feasible. ? Cost reduction. ? Fast and convenient. 2. 2 Existing system In early days College management system used to manages all the details manually. Which is difficult in conventional management system which maintains the records manually, which slows the operation of storing, retrieving of records from the files, also led to drawbacks like data redundancy and inconsistency. Limitation In early days College management system used to manages all the details manually. 2. 3 Proposed system To overcome the drawbacks faced in conventional systems we are moving towards modern approach in which we automate these processes, for efficient management of organization. By building customized application software, computerized maintenance of these details by the use of this application will provide ease-of-use, efficient store/access to data and prevents data redundancy. In our application we have computerized all the manual system. In this application admin will enter the details of employee and also enter the salary details. Admin enter the details student fee details. CHAPTER 3 REQUIREMENTS SPECIFICATION AND ANALYSIS 3. 1 Software Requirement Specification Introduction A Software Requirements Specification (SRS) is a complete description of the behavior of the system that is to be developed. Use Case technique can be used in order to find functional requirements of the software product. Functional requirements are statements of services the system should provide, how the system should react to particular inputs and how the system should behave in particular situations. The functional requirements also explicitly state what the system should not do. SRS also includes Non-functional (or supplementary) requirements. Non-functional requirements are constraints on the services or functions offered by the system. As system grew more complex, it becomes evident that the goal of the entire system cannot be easily comprehended. Hence the need for the requirement phase arose. ROLE PURPOSE of SRS This SRS describes the software functional non functional requirements. This document is intended to use by the members of the project team that will implement and verify the correct functioning of the system. Unless otherwise noted, all requirements specified here are high priorities and committed. A complete understanding of software requirements is essential to the success of a software development effort. No matter how well designed or well coded. A poorly analyzed and specified program will disappoint the client. Software Requirements Specification (SRS) specifies the general factors like the external interfaces, evolution or growth path of the system, functional requirements, user characteristics and the assumptions, dependencies and risks associated with the system. 3. Requirement Specification 1. Functional Requirements ? Admin will create all employee details with their photos ? List all the details of employee ? Store and Display the workshops conducted by the employee ? Calculate the employee salary and display ? Store and display the fee details of students 3. 2. 2 Non-Functional Requirements †¢ Availability System must be available for the working hours. †¢ Price C ost is less. †¢ Usability – It should be friendly to use and access different pages. User interface should be good. †¢ Scalability- It should support at least 5000 users. Performance- It should be tested and maintained properly. †¢ Reliability- Software reliability brings up the concept of modularity. A package with a high degree of modularity has the capacity to operate in many machine configurations and perhaps across manufacture product lines. 3. 3 Hardware and Software Requirements Software Requirements †¢ Front End: ASP †¢ IDE:Visual studio 2005 †¢ Language:C# †¢ Back End: MS Access †¢ Operating System: Windows XP Hardware Requirements †¢ PROCESSOR : Pentium – IV †¢ RAM : 512MB †¢ HDD:20GB CHAPTER 4 SYSTEM DESIGN AND ANALYSIS 4. 1 System design Design is an important step in the development of large scale system. Design provides us with a blue print to develop a system. Once the software requirements have been analyzed and specified the software design can be expressed using notations such as DFDs, UML notations to describe the proposed solution to the problem . These Notations allows us to understand complex system clearly and serves as blue print for the proposed system. The design activities are of main importance because this activity ultimately affecting the sources of the software implementation and its ease of maintenance are made . hese deceptions have the bearing upon reliability and maintainability of the system. Proper design is the only way to accurately translate the customer’s requirements into finished software or a system. Software design generally involve two steps 1. Preliminary Design 2. Detail Design The preliminary design is used to translate the problem specifications into a graphical system rep resentation. The Detailed design is concerned with breaking the whole solution into number of modules. This process of division of system into many sub modules reduces the complexity of problem solving. . 2 Modules and Description College Management System mainly deals with Employee Profile, Payroll Management and Fee collection which can be managed by the Admin. 4. 2. 1 Modules: 1. Employee Profile 2. Payroll Management 3. Fee collection 2. Description: 1. Employee Profile Admin will enter the details of employee profile. Employee Profile contains the all details of employee with their profile photo, it is also contains the achievements of employee and workshops they have conducted. Admin also search the details of employee. 2. Payroll Management Payroll Management calculates employee salary. 3. Fee collection Fee collection tracks all the fee details of a student from the day one to the end of his course. 4. 3 Usecase Modeling Use Case Diagrams represents the functionality of the system from a user’s point view. They define the boundaries of the system. [pic] Fig 4. 3. 1 4. 4 Sequence Diagram The sequence diagram represents the system’s behavior in terms of interactions among a set of objects. They are used to identify the objectives in the application and implementation domain. Fig 4. 4. 1 [pic] 4. 5 Activity Diagram Activity diagram is another important diagram in UML to describe dynamic aspects of the system. It is basically a flow chart to represent the flow form one activity to another activity. The activity can be described as an operation of the system. So the control flow is drawn from one operation to another. This flow can be sequential, branched or concurrent. Activity diagrams deals with all type of flow control by using different elements like fork, join etc. Purpose: The basic purposes of activity diagrams are similar to other four diagrams. It captures the dynamic behavior of the system. Other four diagrams are used to show the message flow from one object to another but activity diagram is used to show message flow from one activity to another. Activity is a particular operation of the system. Activity diagrams are not only used for visualizing dynamic nature of a system but they are also used to construct the executable system by using forward and reverse engineering techniques. The only missing thing in activity diagram is the message part. It does not show any message flow from one activity to another. Activity diagram is some time considered as the flow chart. Although the diagrams looks like a flow chart but it is not. It shows different flow like parallel, branched, concurrent and single. †¢ Draw the activity flow of a system. †¢ Describe the sequence from one activity to another. †¢ Describe the parallel, branched and concurrent flow of the system. [pic] Fig 4. 5. 1 4. 6 Data flow diagram Designing with the Data Flow Diagrams involves creating a model of the system. The entities and attributes are a model, of the states of the system. Processes model the rules of a System. The stimuli and response are modeled by Data Flows. All of these models are combined into one graphic model called a Data Flow Diagram. DFD’s have a notation for each of the components of the system. They also have a notation for representing different levels in a hierarchy of detailed used to describe the system. This notation makes it possible to represent an overall view of a large complex system and a detailed view of a part of a system using the same notation. Parts of the system can be isolated into independent sub-system. [pic] Fig 4. 6. 1 CHAPTER 5 IMPLEMENTATION 5. 1 Software tools used 5. 1. 1 ASP What is ASP? ASP stands for Active Server Pages. Microsoft introduced Active Server Pages inDecember 1996, beginning with Version 3. 0. Microsoft officially defines ASP as:â€Å"Active Server Pages is an open, compile-free application environment in which you can combine HTML, scripts, and reusable ActiveX server components to create dynamic and powerful Web-based business solutions. Active Server pages enables server side scripting for IIS with native support for both VBScript and Jscript. † In other words, ASP is a Microsoft technology that enables you to create dynamic web sites with the help of server side script, such as VBScript and Jscript. ASP technology is supported on all Microsoft Web servers that are freely available. What is an ASP file? An ASP file is quite like an HTML file. It contains text, HTML tags and scripts, which are executed on the server. The two widely used scripting languages for an ASP page are VBScript and JScript. VBScript is pretty much like Visual Basic, whereas Jscript is the Microsoft’s version of JavaScript. However, VBScript is the default scripting language for ASP (3). Besides these two scripting languages, you can use other scripting language with ASP as long as you have an ActiveX scripting engine for the language installed, such as PerlScript. The difference between an HTML file and an ASP file is that an ASP file has the â€Å". asp† extension. Furthermore, script delimiters for HTML tags and ASP code are also different. A script delimiter is a character that marks the starting and ending of a unit. HTML tags begins with lesser than () brackets, whereas ASP script typically starts with . In between the delimiters are the server-side scripts. ASP includes five build-in objects:  · Request – to get information from the user that is passed along with an HTTP request  · Response – to output data to the requesting client Server – to control the Internet Information Server  · Session – to store variables associated with a given user session  · Application – to store information that remain active for the lifetime of an application, such as a page counter. What are its advantages? 1. Dynamic web page – Since ASP supports scripting languages, which run on the web server, yo ur web page can be dynamically created. For example, you can create your web page so as to greeting each user when they log into your page differently. 2. Browser independent – ASP is browser independent because all the scripting code runs on the server. The browser only gets the results from the server in a standard HTML page. 3. Database Access – One of the greatest assets of ASP is database connectivity. ASP enables you to easily build rich database functionality into your web site, such as form processing. 4. Building-in objects – The five built-in objects that come with ASP facilitate Web application development. For example, you can use Request object to retrieve browser request information. 5. Free availability – Yes, it’s free. You can download web server (IIS or PWS) for free from Microsoft’s web site. You don’t even have to have any special tool to write an ASP file. In other words, you can simply use any text editor, like NotePad. 5. 1. 2 C# Language C# programs run on the . NET Framework, an integral component of Windows that includes a virtual execution system called the common language runtime (CLR) and a unified set of class libraries. The CLR is Microsofts commercial implementation of the common language infrastructure (CLI), an international standard that is the basis for creating execution and development environments in which languages and libraries work together seamlessly. Source code written in C# is compiled into an intermediate language (IL) that conforms to the CLI specification. The IL code, along with resources such as bitmaps and strings, is stored on disk in an executable file called an assembly, typically with an extension of . exe or . dll. An assembly contains a manifest that provides information on the assemblys types, version, culture, and security requirements. When the C# program is executed, the assembly is loaded into the CLR, which might take various actions based on the information in the manifest. Then, if the security requirements are met, the CLR performs just in time (JIT) compilation to convert the IL code into native machine instructions. The CLR also provides other services related to automatic garbage collection, exception handling, and resource management. Code that is executed by the CLR is sometimes referred to as managed code, in contrast to unmanaged code which is compiled into native machine language that targets a specific system. The following diagram illustrates the compile-time and run time relationships of C# source code files, the base class libraries, assemblies, and the CLR. pic] Language interoperability is a key feature of the . NET Framework. Because the IL code produced by the C# compiler conforms to the Common Type Specification (CTS), IL code generated from C# can interact with code that was generated from the . NET versions of Visual Basic, Visual C++, Visual J#, or any of more than 20 other CTS-compliant languages. A single assembly may contain mul tiple modules written in different . NET languages, and the types can reference each other just as if they were written in the same language. In addition to the run time services, the . NET Framework also includes an extensive library of over 4000 classes organized into namespaces that provide a wide variety of useful functionality for everything from file input and output to string manipulation to XML parsing, to Windows Forms controls. The typical C# application uses the . NET Framework class library extensively to handle common plumbing chores. 5. 1. 3 MS Access Microsoft Office Access, previously known as Microsoft Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. MS Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases. Software developers and data architects can use Microsoft Access to develop application software, and power users can use it to build software applications. Like other Office applications, Access is supported by Visual Basic for Applications, an object-oriented programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports expose their methods and properties in the VBA programming environment, and VBA code modules may declare and call Windows operating-system functions. USES: ? In addition to using its own database storage file, Microsoft Access may also be used as the front-end with other products as the back-end tables, such as Microsoft SQL Server ? Access tables support a variety of standard field types, indices, and referential integrity. Access also includes a query interface, forms to display and enter data, and reports for printing. The number of simultaneous users that can be supported depends on the amount of data, the tasks being performed, level of use, and application design. FEATURES ? Users can create tables, queries, forms and reports, and connect them together with macros. ? The original concept of Access was for end users to be able to access data from any source. ? Microsoft Access offers parameterized queries. These queries and Access tables can be referenced from other programs like VB6 and . NET through DAO or ADO. From Microsoft Access, VBA can reference parameterized stored procedures via ADO. . 1. 4 Microsoft Visual Studio IDE Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft. It is used to develop console and graphical user interface applications along with Windows Forms applications, web sites, web applications, and web services in both native code together with managed code for all platforms supported by Microsoft Windows, Windows Mobile, Windows CE, . NET Framework, . NET Compact Framework and Microsoft Silverlight. Visual Studio includes a code editor supporting IntelliSense as well as code refactoring. The integrated debugger works both as a source-level debugger and a machine-level debugger. Other built-in tools include a forms designer for building GUI applications, web designer, class designer, and database schema designer. It accepts plug-ins that enhance the functionality at almost every level—including adding support for source-control systems (like Subversion and Visual SourceSafe) and adding new toolsets like editors and visual designers for domain-specific languages or toolsets for other aspects of the software development lifecycle (like the Team Foundation Server client: Team Explorer). It provides a way to check the functionality of components, sub assemblies, assemblies and /or a finished product. It is a process of exercising software with the intent of ensuring that the software system needs its requirements and user expectations and doesn’t fall in an unacceptable manner. 6. 2 Functional Testing Functional tests provide systematic demonstrations that functions tested are available as specified by the business and technical requirements, system documentation, and user manuals. †¢ Functional testing is centered on the following items: †¢ Valid messages: Identified classes of valid messages must be accepted. Invalid messages: Identified classes of invalid messages must be rejected. †¢ Functions: Identified functions must be exercised. †¢ Output: Identified classes of application outputs must be exercised. †¢ Systems/Procedures: Interfacing systems or procedures must be invoked. 6. 3 Unit Testing In computer programming, unit testing is a method by which individual units of source code, sets of one or more computer program modules together with associated control data, usage procedures, and operating procedures, are tested to determine if they are fit for use. Intuitively, one can view a unit as the smallest testable part of an application. The goal of unit testing is to isolate each part of the program and show that the individual parts are correct. 6. 4 Integration Testing Software integration testing is the incremental integration testing of two or more integrated software components on a single platform to produce failures caused by interface defects. Integration testing (sometimes called Integration and Testing, abbreviated IT) is the phase in software testing in which individual software modules are combined and tested as a group. It occurs after unit testing and before validation testing. Integration testing takes as its input modules that have been unit tested, groups them in larger aggregates, applies tests defined in an integration test plan to those aggregates, and delivers as its output the integrated system ready for system testing. 6. 5 System Testing 6. 5. 1 Verification Verification is intended to check that a product, service, or system meets a set of initial design requirements, specifications, and regulations. In the development phase, verification procedures involve performing special tests to model or simulate a portion, or the entirety, of a product, service or system, then performing a review or analysis of the modeling results. In the post-development phase, verification procedures involve regularly repeating tests devised specifically to ensure that the product, service, or system continues to meet the initial design requirements, specifications, and regulations as time progresses. citation needed] It is a process that is used to evaluate whether a product, service, or system complies with regulations, specifications, or conditions imposed at the start of a development phase. Verification can be in development, scale-up, or production. This is often an internal process. 6. 5. 2 Validation Validation is intended to check that development and verification procedures for a product, service, or system (or portion thereof, or set thereof) result in a product, service, or system (or portio n thereof, or set thereof) that meets initial requirements, specifications, and regulations. For a new development flow or verification flow, validation procedures may involve modeling either flow and using simulations to predict faults or gaps that might lead to invalid or incomplete verification or development of a product, service, or system (or portion thereof, or set thereof). A set of validation requirements, specifications, and regulations may then be used as a basis for qualifying a development flow or verification flow for a product, service, or system (or portion thereof, or set thereof). Additional validation procedures also include those that are designed specifically to ensure that modifications made to an existing qualified development flow or verification flow will have the effect of producing a product, service, or system (or portion thereof, or set thereof) that meets the initial design requirements, specifications, and regulations; these validations help to keep the flow qualified. [citation needed] It is a process of establishing evidence that provides a high degree of assurance that a product, service, or system accomplishes its intended requirements. . 5. 3 White-Box Testing White-box testing (also known as clear box testing, glass box testing, transparent box testing, and structural testing) is a method of testing software that tests internal structures or workings of an application, as opposed to its functionality (i. e. black-box testing). In white-box testing an internal perspective of the system, as well as programming skills, are used to design test c ases. The tester chooses inputs to exercise paths through the code and determine the appropriate outputs. This is analogous to testing nodes in a circuit.