Submission of Proposal for the Project Title
Student Information System
Third Year Bachelor of Computer Application
Academic Year 2012-13 Submitted by: L .Nagal .Nagalakshm akshmi PRN No: 4410600130
Under the Guidance of: S. J. Vishwakarma.
Submitted to: Tilak Maharashtra Vidyapeeth, Pune. (UGC & DEC Approved) BELAPUR CAMPUS.
Submission ission Date Date:___ :_ ____ ____ ____ ____ ____ ____ __ Student Student Signat Signatur ure e: Name:-L.Nagalakshmi Name:-L.Nagalakshmi
Sign _________________
INDEX Sr. No.
Title
Page No.
1. 2. 3. 4. 5. 6. 7. 8. 9. 10.
Introduction
Chapter 1
Introduction
INTRODUCTION
This software will function as a tool for SIMPLE STUDENT INFORMATION SYSTEM. Student Information System is one of the project which can be used in any school, colleges or educational institute for keeping their th eir documentation work. Student Information System is associated with all aspects of Institute Administration. It is much customized and user friendly software for institutes and is very cheap. The software is capable of managing Enquiry Details, Student Details, Project Report and Payment Details etc. In this software, user can maintain the track for daily student record transaction. The OBJECTIVE is to prepare Software or Application, which could maintain data and provide a good interface for retrieving student related detail just in few seconds, with 100% accuracy. Software is completely computerized, computerized, so it is not time consuming process, no paper work is required and can be implement further. This application should also facilitate the addition of new student details, deletion of ex-students and modification of existing student records. To search for every student ID for particular student, the entire information gets displayed.
Chapter 2 COMPANY PROFILE
I am creating this software as for our student information system
Chapter 3 Objectives
OBJECTIVES OF THE SOFTWARE
Objectives of the Student Information System are as follows:
Automate Registration and Admission
Keeps record safely for infinitely long period
Manage own security
Manage Student Information efficiently
Analyze the performance performance of the class as a whole through Student Grading Software
Display tabulated result sheets as well as student information
Generate fee receipts
Record Student Billing and Payments made
Fee summaries of various types can be queried
Communicate Communicate with Students or Parents easily
Distinguished Feature: o
Economically Cheaper
o
Can be used as offline as well as online
o
Integrate with website
o
Easy migration to software from existing thing.
This project makes sincere effort to provide all the above mentioned feature to meet requirement of INSTITUTE. The project category is vb.net with RDBMS (Access) and Management information system.
Chapter 4 Scope Of The Project
SCOPE OF THE PROJECT
The first software project management activity is the determination of software scope. Scope is defined by answering the following:
INFORMATION OBJECTIVES The main information that needed in developing AFM module is the amount to be charged from each person or company and to determine the quantity and amount per object.
FUNCTION PERFORMANCE In this project (Student Information System), the Visual Studio 2008 (VB.Net) is used as front end and Microsoft Access is used as back end. The details of all the clients would be written in Microsoft Access. But whenever the project is run in VB, data entered in MS Access appears in VB due to connectivity, which has been implemented between VB and Access. Software scope must be ambiguous and understandable at both the management and technical level.
Chapter 5 Problem Of Statement
RECOGNITION OF THE PROBLEM These are the problems that take place in the present system-
Data Redundancy
Data Inconsistency
Data Isolation
Security Problem
DATA REDUNDANCY Data redundancy occurs in the database systems which have a field that is repeated in two or more tables. For instance, in case when customer data is duplicated and attached with each product bought then redundancy of data is known as source of inconsistency, since customer might appear with different values for given attribute. Data redundancy leads to data anomalies and corruption & generally should be avoided by design. Database normalization prevents redundancy and makes the best possible usage of storage. Proper use of foreign keys can minimize data redundancy and chance of destructive anomalies. However, sometimes concerns of efficiency and convenience can result redundant data design despite the risk of corrupting the data.
DATA INCOSISTENCY Data inconsistency exists when different and conflicting versions of the same data appear in different places. Data inconsistency creates unreliable information, because it will be difficult to determine which versions of information is correct. (It’s difficult t o make correct – correct – and and timely - decisions if those decisions are based on conflicting information.) Data inconsistency is likely occur when there is data redundancy. r edundancy. Data redundancy occurs when the data data file / database file contains redundant redundant – unnecessarily – unnecessarily duplicated – duplicated – data. data. That’s why one major goal of good database design is to eliminate data redundancy.
DATA ISOLATION Because data are scattered in various files and files may be in different formats, writing new application program to retreat the appropriate data is difficult.
SECURITY PROBLEMS Not every user of the application program should be able to access the data. Only administrator should be able to grant or revoke the operations on application i.e., add, update or delete data.
TOOLS & TECHNOLOGY
Front End Tool :VB.NET
Back End Tool :MS ACCESS
1. PROJECT DESCRIPTION
Preliminary Preliminary Design:
D-F-Diagram A data-flow data-flow diagram (DFD) is a graphical representation of the “flow” of data through an information system. DFDs can also be used for the visualization of data processing (structured design). On a DFD, data items flow from an external data source or an internal data store to an internal data store or an external data sink, via an internal process. A DFD provides no information about the timing or ordering of processes, or about whether processes will operate in sequence or in parallel. It is therefore quite different from a flowchart, which shows the flow of control through an algorithm, allowing a reader to determine what operations will be performed, performed, in what order, and under what circumstances, but not what kinds of data will be input to and output from the system, nor where the data will come from and go to, nor where the data will be stored(all of which are shown on a DFD).
A DFD is made by using the following Symbols.
External Entity
Data Flow
Data Store
Process
Data flow other diagram
7. SOFTWARE REQUIREMENTS
Microsoft Windows XP Service Pack 2
Microsoft Visual Studio 2008
Microsoft Office Access 2007
8. HARDWARE RECOMMENDATION
Intel Celeron 900,CPU 2.20 Ghz
1.96 GB RAM
160 GB HDD
Super VGA (800 X 600)
Writable CD ROM For Backup
9. TENTATIVE SCHEDULE
1st Week :- Problem Identification
2nd Week :- Problem Analysis
3rd Week :- System Designing
4th & 5th Week :- Software Coding
6th Week :- Software Packaging & Testing
10.REFERENCES
Books o
MSDN Library
o
Visual Studio 2008
o
Microsoft Access 2007-Pasewark and Robin M.Romer
o
Database System Concepts-Henry F. Korth
o
System Design
Web Sites o
http://msdn.microsoft.com
o
www.youtube.com
o
www.codeproject.com
o
answers.yahoo.com
11. PROJECT DETAILS
PROJECT DETAILS
The
first step is to maintain student form.
Registration
of students who are interested in
joining particular course course
Record
To
should be maintained properly
calculate and check amount of fees paid by the
students
To
provide students with study materials
Monthly
reports should be update
Keeping
tracks of Internal Marks and Student
Performance Certificate
session
to be provided at the end of every
12. VB.NET (FRONT END)
VISUAL STUDIO 2008 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 Form applications, applications, websites, websites, web applications, and and web services in both native native code together with managed code for all platforms supported by Microsoft Windows, Windows Mobile, Windows CE, .NET Framework, .NET Compact Framework and Microsoft Silver l ight.
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. designer. It accepts plug-ins that enhance the functionality at almost every levelincluding 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).
Visual Studio supports different programming languages by means of language services, which allow the code editor and debugger to support (to varying degrees) nearly any programming language, provided a language-specific language-specific service exists. Built-in languages include C/C++ (via Visual C++), VB.NET (via Visual Basic.NET), C# (via Visual C#), and F# (as of Visual Studio 2008). Support for other languages such as M, Python and Ruby among others is available via language services installed separately. It also supports XML/XSLT, HTML/XHTML, JavaScript and CSS. Individual languagespecific versions of Visual Studio also exist which provide more limited language services to the user: Microsoft Visual Basic, Visual J#, Visual C# and Visual C++.
Microsoft provides “Express” “Express” editions of its Visual Studio Studio 2010 components Visual Basic, Visual C#, Visual C++ and Visual Web Developer at no cost. Visual Studio 2010, 2008 and 2005 Professionals Editions, along with language-specific versions (Visual Basic, C++, C#, J#) of Visual Studio Express 2010 are availa ble for free to students as downloads via Microsoft’s Dream Spark program.
13. DATA TYPE SUMMARY
DATA TYPE SUMMARY Visual Basic recognize following six types of variables as Numeric, String, Boolean, Date, Object, Variant.
NUMERIC Like other Programming Language Visual Basic provide Numeric Variables. They are: Integers, Single, double, Byte, Long, Currency.
BOOLEAN Boolean Data Type stores True / False values. Boolean variables are used in testing conditions.
DATE Date and Time Tim e variables are stored internally in a special format, but you don’t need to know the exact format. Date variables are declared by following statements.
OBJECT An object variable is used to refer any object in the application they are declared by the object data type and after that they are set to any of the object in the applications with set command.
VARIANT Special Types of Variables declare without any data type treated as variant they capable of containing any type of value. If one can skip data type in variable declaration statement then variable will be treated as variant.
14. Microsoft Access Database
MICROSOFT OFFICE 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 software-development tools. It is a member member of the t he Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. On May 12 2010, the t he current version of Microsoft Access 2010 was released by Microsoft in Office 2010; Microsoft Office Access 2007 was the prior version. MS Access stores in data in its own format based on the t he Access Jet Database Engine. Engine. It can also import or link directly di rectly to data sorted in other applications and databases. Software developers and data architects can use Microsoft Access Access to develop application software, and “power users” can use it to build software applications. Like other Office applications, Access Access is supported by Visual Basic for Applications, an object-oriented programming language that can refer a variety of objects including DAO (Data Access Objects), Active X Data Objects, and many other Active X 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 operating-system functions.
15. DATA INPUT AND OUTPUT METHOD
DATA INPUT AND OUTPUT METHOD INPUT METHOD The data entering process is online as the data is entered at the t ime of transaction. Any change in either of the forms is directly updated in the database. The computer prompts the data entry operator (here the Bank Staff) with menu, commands, commands, and forms which is displayed on the VDU. As the project is run the login form is displayed. When the correct password is entered, the menu form gets loaded and according to the task that as to be performed, performed, different templates templates related to to the student enquiry, enquiry, follow up diary, diary, admission, collection collection report, attendance sheet, project report etc. can be opened. All the form layouts can be seen in the following pages.
OUTPUT METHOD The student Information System related transaction transaction can be directly printed from the database or can be viewed on the screen.
16. DATABASE DESIGN
DATABASE DESIGN The general theme behind a database is to handle information as an integrated whole. A database is a collection of interrelated data stored with minimum redundancy to serve many users quickly and effectively. After designing input and output, the analyst must Concentrate on database design or how data should be organized around user requirements. The general objective is to make information access, easy, quick, inexpensive, and flexible for other users. During database design the following objectives are concerned o o o o o o o
Controlled Redundancy Redundancy Data Independence Accurate and Integrating Recovery from Failure More Information at low Cost Privacy and Security Ease of learning and use
17. TABLE DESIGN
Login Table Sr No.
Field Name
Data Type
1
User ID
Number
2
Username
Text
3
Password
Text
Sr No.
Field Name
Data Type
1
Form No
Number
2
Date_ A
Date/Time
3
Suffix
Text
4
First Name
Text
5
Middle Name
Text
6
Last Name
Text
7
Total Sales
Number
8
Service Tax
Number
9
Actual Sales
Number
10
Cheque No
Number
11
Cheque Date
Date/Time
12
Bank Name
Text
13
Installment
Number
14
Fees_ Admission
Number
15
Total
Number
Admission Official
Admission Table
Sr No.
Field Name
Data Type
1
Form No
Number
2
Date of Application
Date/Time
3
Center
Text
4
Code No
Number
5
Suffix
Text
6
First Name
Text
7
Middle Name
Text
8
Last Name
Text
9
Phone R
Number
10
Phone O
Number
11
Phone M
Number
12
Address
Text
13
State
Text
14
City
Text
15
Pin code
Number
16
Birth date
Date/Time
17
Email Id
Text
18
Placement Req
Text
19
Course Title
Text
20
Batch Time
Date/Time
21
Start Date
Date/Time
22
Total Fees
Number
23
No. of Emi
Number
24
Emi date
Date/Time
Student Enquiry Table Sr No.
Field Name
Data Type
1
Form No
Number
2
Membership No
Number
3
Enquiry Date
Date/Time
4
Suffix
Text
5
First Name
Text
6
Middle Name
Text
7
Last Name
Text
8
Gender
Text
9
Phone R
Number
10
Phone M
Number
11
Birth Date
Date/Time
12
Address
Text
13
State
Text
14
City
Text
15
Pin code
Number
16
Email ID
Text
17
Interests
Text
18
Events
Text
19
Friend1
Text
20
Phone1
Number
21
Friend2
Text
22
Phone2
Number
Course: Sr No
Field Name
Data Type
1
Form No
Number
2
Course Id
Number
3
Course Name
Text
4
Fees
Number
5
Duration
Text
Sr No.
Field Name
Data Type
1
Form No
Number
2
Month
Text
3
Batch Time
Date/Time
4
Course
Text
5
Suffix
Text
6
First Name
Text
7
Middle Name
Text
8
Last Name
Text
9
Project Submitted
Text Text
10
No. of Projects
Number
11
Description
Text
Project Report
Fees Payment Sr No.
Field Name
Data Type
1
Form No
Number
2
Fees Date
Date/Time
3
Code No
Number
4
Suffix
Text
5
First Name
Text
6
Middle Name
Text
7
Last Name
Text
8
Course ID
Number
9
Course Name
Text
10
Month
Text
11
Paid Fee
Number
12
Amount
Number
13
Total Fees
Number
14
Cheque No
Number
15
Cheque Date
Date/Time
16
Bank Name
Text
18. Program Screen Shots
Login Form:
When the Student Information System.exe is double clicked this form appears. This form is used by the Administrators. Only if Password is correct the Main Menu form appears. Else this following message box appears“The Username or Password is incorrect!!!”
Main Form
When the password is checked with the one in the database and found to match this form appears. This is main form from where the user has to choose his option from the following
File
Student Details
Course Details
Fees Details
Project Report
Custom Search
Student Enquiry Form:
This form appears when the user click on the Student Details -> Student Enquiry Form option in the menu This form takes in the details from the Students which is filled by the User assigned (Administrator’s (Administrator’s Staff).
Admission Form:
This form appears appears when the user click on the Student Student Details ->Admission ->Admission Form option in the menu
The Admission Form is given to the students to fill it with their personal details, academic details, address, phone number, email ID, desired course the student wants to opt for and placement placement as well if the student desires so.
Admission (Official) Form:
This form appears when the user click on the Student Details ->Admission (Official) Form option in the menu
The Official Admission Form is filled by the user of Admission Department. Where they receive payments given given by students through through cheque or cash. cash. Courses Form:
This form appears when the user click on the Course Details option in the menu
This form needs to be filled with Course ID, Course Name, Fees and Duration. New Course can also be added, if they they want to opt for. Fees Details:
This form appears when the user clicks on t he Fees Details option in the menu. It is used for keeping a track of the student fees transaction whenever they pay their amount, it is automatically updated in their system with date, course ID, course name, month, cheque no., cheque
name and cheque issued by the bank. It also helps us to know what amount is still unpaid from the total amount of fees. Project Report
This form appears when the user clicks on the Project Report option in the menu. This form is mainly maintained to keep a updating of student’s performance in whatever projects they work.
Custom Search
This form appears when the user clicks on the Custom Search option in the menu. The purpose of the form is intend to generate a clear view of records and provides advanced search facilities with various search options. The user has to just type in the required field and press the search button to obtain the desired tables t ables and fields in the data grid view.
Change Password Form:
This form appears when the user clicks on File-> Change Password option in the menu. By this form the user has the power to change the password for security and the change is reflected in Database.
19. Testing Strategy
Testing Strategy Testing Strategy integrates software test design methods into a well planned series of steps that results in the successful successful construction of software.
UNIT TESTING Unit testing is concerned with knowledge about testing a program it, to determine that it is free of data, logic or standard errors. At this level white box is testing are used. This unit includes knowledge of dynamic analysis. In this unit testing i ndividual components or models are tested. It relatively focuses in the small segments segments of the code and the aims to exercise a high percentage of internal paths. INTEGRATION TESTING Integration testing is concern with knowledge about validating that software component, which have been unit is tested separately, interact correctly correctly when they are put together to perform higher higher order function. In In this application bottom up integration testing is done. FUNCTIONAL TESTING Functional tests are programs or script configured to test that application met external requirements and achieve goals, such as performance, also known as black box testing because source source code is not needed. needed. ACCEPTANCE TESTING This is the final stage in the testing process before the system is accepted for operational use. The system is tested with data supplied by the system procurer rather than simulated test data. Acceptance Acceptance testing may reveal errors and omission in the system requirement definition because the real data exercises exercises the system system in different different ways from the test data. Acceptance Acceptance testing may also reveal the requirement problems where the system’s facilities do not really meet the user’s needs or the system performance is acceptable. PERFORMANCE TESTING Performance Performance testing for the application is performed performed for finding the actual run-time performance. performance. Time taken taken for search search and locate the required data is tested. The data conversion conversion accuracy and speed for the converter tool is also tested. Connectivity and data transfer performance performance for live update update facility of the application application is tested by using test data sets provided by the system testing specialists specialists of the company. company. VALIDATION TESTING Validation is the process of validating the software according according to the t he user requirement. Successful Successful validation should establish confidence that at the application is fits for purpose. The validation is done in all modules and is to ensure that proper results are only obtained. Few validations done are as follows,
Recovery testing: It was checked whether the software can be able to recover from faults and resume processing within the predefined time.
Security testing: Security testing attempt to verify that production mechanism mechanism built into a system will in fact product it from improper improper penetration. penetration.
20. System Implementation Implementation
System Implementation Implementation is the stage in the project where the theoretical design is turned into a working system. The implementation phase constructs, installs and operates the new System. This form appears when the user click on the Custom Search option in the menu: End User Training: The successful successful implementation of the new system will purely upon the involvement of the officers working in that department. The officers will be imparted the necessary training on the new technology. End User Education: The education of the end user start after the implementation and testing is over. When the system is found to be more difficult to understand and complex, more effort is put to educate the end used to make them aware of the system, giving them lectures about the new system and providing them necessary documents documents and materials about how the system can do this. Training Of Application Software: After providing the necessary basic training on the computer awareness, the users will have to be trained upon the new system such as the screen flows and screen design type of help on the screen, type of errors while entering the data, the corresponding validation check at each entry and the way to correct the data entered. It should then cover information needed by the specific user or group to use the system. Post Implementation Review: The department is planning a method to know the states of the post implementation process. For that regular meeting will be arranged by the concerned concerned officers about the implementation problem and success.
21. Future Scope Of The Project
FUTURE SCOPE OF THE PROJECT Student Information System Software Solution is very customized and user-friendly software for Institutes and it’s a freeware. This Software is capable of managing Enquiry details, Student Details, Payment Details etc. It also provides very helpful report for managing the institutes in easy and accurate way. It will help us to store information regarding Account Payment Favour, Advertisement Information , Area Information, Batch Information, Course Information, Counselor Information, Enquiry Information, Generate Statement and BR NO., Student Material Issue, Student Information, Timing Slot.
It will also help for Daily entries such as:Student Information: To maintain the records of students’ students’ general information. Course Wise Payment: Allow the user to enter the payment received from students by the respective course codes and under individual course heads.
Payment Information: To enter all the payment received from various sources and credit them under various heads. Project Report: Is a form to enter the performance score that have been secured by the students in their various project completion so that they can be referred to whenever required.
Student Detail Report: Will provide information on all spheres related to the student, be it batches, certificate, certificate, installments, discounts, scholarships, break, material and book issue.
CONCLUSION The “Student Information Information System” Software is an application that permits you to compare, compare, manipulate, and student data in meaningful manner, generating a clear view of records and provides advanced advanced search search facilities with with various search search options. After completing the project project I am sure that the problems in the existing system system have been overcome. The “Student Information System” process made computerized to reduce human efforts and to increase the efficiency. efficiency. The main focus of this project is to lessen human efforts. The maintenance of the records is made efficient, as all the records are stored in the ACCESS database, through which data can be retrieved easily. If the numbers of records are very large then user has to just type in the search string and user gets the result immediately. The editing is also simpler. The user has to just type in the required field and press the update button to update the desired field.
Thus, the project is user friendly approach.
