Idea Transcript
A Project Report On Computer Center Management System SUBMITTED BY Chetana Patel [E.NO-59] T.Y. B.C.A Sonal Brahmbhatt [E.NO-06] T.Y. B.C.A GUIDED BY Mrs.Jigna Prajapati AMPICS LIBRARY
2012
SUBMITTED TO ACHARYA MOTIBHAI PATEL INSTITUTE OF COMPUTER STUDIES GANPAT UNIVERSITY , KHERVA-382711 Page 1 of 62
AMPICS LIBRARY
2012
No Title
Pg.no
1
Project Profile
6
2
About The Organization
7
3
Teachers Detail
9
4
Subject Detail
10
5
Existing System
11
6
Need For New System
12
7
H/W & S/W Requirement
13
8
System Flow Chart
14
9
Data Flow Diagram
17
10
E-R Diagram
24
11
Data Dictionary
26
12
Process Algorithm
34
Page 2 of 62
AMPICS LIBRARY
2012
13
Description Of DFD
35
14
Input Design
37
15
Output Design
45
16
Testing
60
17
Future Enhancement
62
18
Bibliography
63
Page 3 of 62
AMPICS LIBRARY
2012
Project Title :- Computer Center Management System
Project objective :- To manage information like student information , course information , staff information , student fees , student result etc. Developed for :- SHYAMAL COMPUTERS, MEHSANA. Developed At :- AMPICS, GANPAT University, Kherava Developed By :- Patel Chetna B. Brahmbhatt Sonal S. Project Guide :- Mrs. Jigna Prajapati.
Frontend Tools :- Visual Basic .NET 2005 Page 4 of 62
Backend Tools :- Microsoft SQL Server 2005
AMPICS LIBRARY
2012
This company started his work in march ,1994 . It is now teaching computer programs to student in mehsana .
About The Owner MR SUKETUBHAI PATEL is the owner of the center. He is completed B.SC . He is also completed international diploma in computer application .
Page 5 of 62
AMPICS LIBRARY
2012
About The Teaching Center have good teacher for all course .
They teach student on projector . In center give some special time to practice on computer what they learn . Also they got some project work , some programming , home works . Also student get book which are related with their course .
About The Courses Center teaches several types of the course . Such as , C , C++ , JAVA , NETWORKING etc. Page 6 of 62
It is also contact spoken English class.
AMPICS LIBRARY
2012
Faculty Names
Subject Name
Total Salary
Pratik Gupta
C , C++ , VB , ORACLE , JAVA , DTP , etc.
3000
Akashi Bhavshar
BASIC , TALLY 9.0 , CCC , etc.
3000
Rupa Maniyar
COUNCILER
4000
Page 7 of 62
AMPICS LIBRARY
Subject Name
2012
Subject detail
C++
Beginning with C++ , Function in C++ , Classes & objects , Constructor , destructor , Operator , Pointers , etc.
JAVA
Fundamentals of OOPS , Overview of java , Constants , Variables and data types , Operators , Classes , Objects Arrays.
VB
.NET Framework Architecture , Class Library , variables , Controls ,Class , ADO. Net Architecture , Data Set , Advance controls , Crystal Report , etc .
DTP
PageMaker , Flash , Photoshop , etc .
COMPUTER BASIC
Basic Knowledge of OS , Notepad , WordPad, MS Office , etc. Page 8 of 62
AMPICS LIBRARY
2012
At present all the information maintained in the current system is manually
The registrations of students are done by filling the form so the institute t Keep all the form to keep the records of student . If the institute has to search information of particular student he has to check all the form .
That will take lost of extra time and it will put burden on the person managing all this.
It is not secure . Page 9 of 62
Need For New system AMPICS LIBRARY
2012
They Can Enter Student Registration Easily . Record are Easy To Maintain Using Computerized System . The Paper Work Is reducing . The Report Are Easily Generated . Student & Course Information Is Easily Update . It Is Secure . Save Time & Money .
Page 10 of 62
AMPICS LIBRARY
2012
HARDWARE SOFTWARE PROCESSER :- P IV OR ABOVE RAM
OPERATING SYSTEM :Windows xp
:- 512 MB
HARD DISK :- 10 GB OR HIGHER
FRONT END :- Microsoft visual studio 2005 BACK END :- Microsoft SQL server 2005
Page 11 of 62
AMPICS LIBRARY
2012
Page 12 of 62
AMPICS LIBRARY START
2012
ENTER LOGIN DATA
IS AUTHENTICL E
NO
YES MANAGE COURSE
MANAGE STAFF
A Page 13 of 62
AMPICS LIBRARY
A
2012
MANAGE STUDENT
MANAGE STUDENT FEES DISPLAY STUDENT RESULT
REPORT GENRATE
STOP
Page 14 of 62
AMPICS LIBRARY
2012
Page 15 of 62
AMPICS LIBRARY
Course Info
ADMIN
Fee Info Student Info
Computer Center Management System
2012
Course Info
Student Student info
Page 16 of 62
AMPICS LIBRARY
ADMIN
Enter Login Info Response
1.0 Login
2012
Verify Login Info Response
User Master
Valid User Manage Course Info
Retrieve Course info
2.0 Course Mgt
New Course Info
Course Master
Update Course Info
Course Info
Manage Faculty Info Retrieve Faculty Info
3.0 Faculty Mgt
New Faculty Info
Faculty Master
Update Faculty Info
Faculty Info Page 17 of 62
AMPICS LIBRARY
Manage Student Info Retrieve Student Info
4.0 Student Mgt
2012
New Student Info Student Info
Student Master
Student Info
Reports Detail
5.0 Report Generate
Reports
Page 18 of 62
AMPICS LIBRARY
Manage Faculty Info ADMIN Retrieve Faculty Info
3.1 Add New Faculty
2012
New Faculty Info
Faculty Master
Faculty Info
Faculty Info
Enter Salary Info Retrieve Salary Info
3.2 Salary Mgt
New Faculty Salary Info
Faculty Salary Info
Faculty Salary Master
Faculty Salary Info
Reports Detail
3.3 Report Generate
Report Page 19 of 62
AMPICS LIBRARY
Manage Student Info ADMIN Retrieve Student Info Student Id
4.1 Student Registrati on
2012
New Student Info Student Info
Student Master
Student Registration Info
Pay Fee Student Get Receipt
4.2 Student Fee
New Student Fee Info
Student Fee Info
Fee Detail
Page 20 of 62
AMPICS LIBRARY
2012
Student Fee Info
Exam Detail Info
Result Info Result Info
4.3 Result
Result Detail
Student Result Info
Student Exam Info
4.4 Report Generate
Report
Page 21 of 62
AMPICS LIBRARY
2012
Page 22 of 62
User Name
Faculty Name
AMPICS LIBRARY
M
1
ADMIN
Manage
Manage
HAS Student ID
Course ID
M M
Student M
M Pay
Course
Course Name
Duration
Fee
Address
Course ID
HAS
M
Total
Result Student ID
M M
1
Course ID
Faculty 1
Name
2012
Course ID Course ID
Sub Name Course ID
Page 23 of 62
AMPICS LIBRARY
2012
Page 24 of 62
Table Name :User Master AMPICS LIBRARY
2012
Description : This table contains information of the user . Field Name
Data Type
Size
Constrain
User ID
Numeric
4,0
Primary Key
User Name
Varchar
20
Not Null
Password
Varchar
20
Not null
Page 25 of 62
Table NameAMPICS : Faculty Master LIBRARY Description : This table contains information of the faculty . Field Name
Data Type
Size
Constraint
Faculty ID
Numeric
5,0
Primary key
Faculty Name
Varchar
50
Not null
Address
Varchar
40
Not null
Mobile
Numeric
10,0
Not null
Email
Varchar
50
Not null
Qualification
Varchar
50
Not null
Sub Specialization Varchar
50
Not null
Course ID
18,0
Foreign key
Numeric
2012
Page 26 of 62
AMPICS LIBRARY
2012
Table Name : Course Master Description : This table contains information of the course .
Field Name
Data Type
Size
Constraint
Course ID
Numeric
4,0
Primary Key
Course Name
Varchar
50
Not Null
Duration
Varchar
25
Not Null
Entry Level
Varchar
30
Allow Null
Fees
Numeric
5,0
Not Null
Course Type
Varchar
50
Not Null Page 27 of 62
Table Name : Student Master AMPICS LIBRARY Description : This table contains information of the student .
2012
Field Name
Data Type
Size
Constraint
Student ID
Numeric
3,0
Primary Key
Surname
Varchar
50
Not Null
Name
Varchar
25
Not Null
Middle Name
Varchar
50
Not Null
Address
Varchar
50
Not Null
Mobile
Numeric
12,0
Not Null
Date Of Birth
Date time
Occupation
Varchar
Admission Date
Data Time
Course ID
Numeric
Not Null 50
Not Null
Not Null 18,0
Foreign Key Page 28 of 62
AMPICS LIBRARY
2012
Table Name : Student Fees Detail Description : This table contains information of the student fees .
Field Name
Data Type
Size
Constraint
Receipt ID
Numeric
3,0
Primary Key
Student ID
Numeric
3,0
Foreign Key
Fees Date
Date Time
Amount
Numeric
5,0
Not Null
Course ID
Varchar
50
Foreign Key
Not Null
Page 29 of 62
AMPICS LIBRARY
2012
Table Name : Faculty Salary Detail Description: This table contains information of the faculty salary .
Field Name
Data Type
Size
Constraint
Salary ID
Numeric
4,0
Primary Key
Faculty ID
Numeric
4,0
Foreign Key
Month
Varchar
50
Not Null
Year
Numeric
10,0
Not Null
Amount
Numeric
8,0
Not Null
Page 30 of 62
Table Name : Student Result AMPICS Detail LIBRARY Description : This table contains information of the student result . Field Name
Data Type
Size
Constraint
Result ID
Numeric
3,0
Foreign Key
Student ID
Varchar
50
Foreign Key
Course ID
Numeric
4,0
Not Null
Total
Numeric
5,0
Not Null
Out of Total
Numeric
4,0
Not Null
Grade
Varchar
3
Not Null
Percentage
Float
Scholarship
Numeric
5,0
Not Null
Date
Date time
50
Not Null
2012
Not Null
Page 31 of 62
AMPICS LIBRARY
2012
Step 1 : Start . Step 2 : Enter user name & password . Step 3 : If valid user than go to step 4 . Else Go to step 2 . Step 4 : Manage course information . Step 5 : Manage faculty information . Step 6 : Manage student information . Step 7 : Manage student fee information . Step 8 : Manage student result detail . Step 9 : Manage various type of report . Step 10 : Stop .
Page 32 of 62
AMPICS LIBRARY
2012
Login : In this process admin enter user & password .
Course Mgt : In this process admin enter information about courses conducted in the center . Faculty Mgt : In this process admin enter information about faculty conducted in the center . Salary Mgt : In this process admin manages salary of the faculty after the completion of month . …….Continue
Page 33 of 62
AMPICS LIBRARY
2012
Report Generation : In this process admin can generate various report . Student Registration : When ever new student request for the registration admin give admission to the student & enter information of that student . Student fee : In this process student pay fee for the courses and admin manages fee received from student & give receipt to the student . Report generation : In this process admin can generate various report .
Page 34 of 62
AMPICS LIBRARY
2012
Page 35 of 62
AMPICS LIBRARY
2012
Page 36 of 62
AMPICS LIBRARY
2012
Page 37 of 62
AMPICS LIBRARY
2012
Page 38 of 62
AMPICS LIBRARY
2012
Page 39 of 62
AMPICS LIBRARY
2012
Page 40 of 62
AMPICS LIBRARY
2012
Page 41 of 62
AMPICS LIBRARY
2012
Page 42 of 62
AMPICS LIBRARY
2012
Page 43 of 62
AMPICS LIBRARY
2012
Page 44 of 62
AMPICS LIBRARY
2012
Page 45 of 62
AMPICS LIBRARY
2012
Page 46 of 62
AMPICS LIBRARY
2012
Page 47 of 62
AMPICS LIBRARY
2012
Page 48 of 62
AMPICS LIBRARY
2012
Page 49 of 62
AMPICS LIBRARY
2012
Page 50 of 62
AMPICS LIBRARY
2012
Page 51 of 62
AMPICS LIBRARY
2012
Page 52 of 62
AMPICS LIBRARY
2012
Page 53 of 62
AMPICS LIBRARY
2012
Page 54 of 62
AMPICS LIBRARY
2012
Page 55 of 62
AMPICS LIBRARY
2012
Page 56 of 62
AMPICS LIBRARY
2012
Page 57 of 62
AMPICS LIBRARY
2012
The task of system testing is done with many different strategists .This system is tested by following steps .
The unit test focuses of the internal processing logic and data structure with In the boundaries of a component . In this testing each and every program is tested individually . Using record that program produced satisfactory outputs and validation also .
Validation testing provides final assurance that s/w meets all function behavioral And performance requirements .
Validation testing is indicates validation in system . Page 58 of 62
AMPICS LIBRARY
2012
System testing verifies that all elements mash properly and that over all system Function performance is achieved .
System testing indicates the fetch of errors in the software developed .
To test computer software .
It is actually series different test whose purpose is to full exercise the computer The computer base system .
Page 59 of 62
AMPICS LIBRARY
2012
We think that not a single project is ever considered as complete forever because our mind is always thinking something new and our necessities also are growing day by day.
We Improve Color in our Software Pages .
We want add printing Facility in our Software . We want to create new table for all New Year . We want to delete particular student all date in database .
Page 60 of 62
AMPICS LIBRARY
2012
Bibliography :
• During the development of project I have used the following books . Books :
• Beginning VB.Net :- By :- Roger S. Pressmen • Beginning Visual Studio 2005
• Prospectus of Company – Apollo Construction & Equipments PVT . LTD. Internet sites . Following are the websites referred: www.VB.net www.google.com
Page 61 of 62
AMPICS LIBRARY
2012
Page 62 of 62