bca projects in java
BACK END - SQL SEVER 2007
MCA FINAL YEAR PROJECT Project SYNOPSIS OF ONLINE EXAMINATION SYSTEM
Final Report Of Online Examination System with full Documentation
SYNOPSIS of Project Sanatorium (Hospital Information System)
Click here to download Final report of project Hospital Information System
BCA Project 3# ONLINE AUCTION SYSTEM
FRONTEND
- C # AND .NET FRAMEWORK
BACKEND
- SQL
SERVER 2008
SYNOPSIS OF PROJECT ONLINE
AUCTION SYSTEM
FINAL REPORT WITH FULL DOCUMENTATION and SOURCE CODE OF
PROJECT ONLINE AUCTION SYSTEM
Computer Science Department
Portal
v Existing System: There
is no such system available for department. The students cannot communicate
with teachers properly. There is a great problem in keeping record of daily
attendance, performance of each student, profile of each person associated with
the department, and there was a lot of difficulties for the student regarding
interaction with the faculties and viewing the current updates.
v Proposed System:
The proposed system is to make an online web portal for Computer Science
Department, so that everyone can get information about department, students can
easily communicate with teachers from anywhere. Teachers can easily communicate
with the parents, and can keep records of every student easily and efficiently.
The proposed system could be accessed from any corner of the world on net.
v Modules: The
various modules use in the Computer Science Department Web Portal is explained
below.
·
Academics:
academics module provides information about the
·
Study
material: This module gives the facility to read and
download the study material available on the website. The module could be
edited only by the administrator of the web portal. Any student can download
the material available at any time.
·
About
Us: The About Us module gives the information
about
·
Quiz:
Various quizzes could be played by the students on available subjects. Quizzes
are designed by the teachers. They can add questions to the particular subject
quiz. Students can only answer the questions available in quiz. A quiz could be
taken any number of times by a student and the results are displayed at the
same time.
·
Faculties:
This module gives profile information of various faculties associated to the
department. It gives profile information of all the faculties. Anyone can
contact to these faculties through available email addresses.
·
Students:
This is a separate webpage for students. They can view, edit, and update their
profile from anywhere. Student can download documents as well.
·
Syllabus:
The syllabus of various branches associated with Computer Science Department is
available here. Syllabus can be viewed and downloaded by students.
·
Technology:
This displays the information about various technologies to be used in present
scenario. Various links are available for detailed information upon different
technologies.
v System Requirements:
|
Operating System |
Windows 98, Windows XP, Windows Vista. |
|
Software |
Adobe Dreamweaver 8.0. XAMPP Server. |
|
Hardware |
PC with minimum 20 GB Hard Disk, minimum 512
MB Ram According to Operating System Used. |
Actual
Documentation
Software Requirement
Specification
1.)
Introduction:
Purpose:
-
Computer Science Department portal is an online web portal for the students and
faculties. It is an interactive service for students and information seekers of
Gyan Vihar Computer Science Department. It is easy to access and use for
communication between faculties and students. It can also be used for keeping
track of information and documents of students and faculties as well.
1.1)
Goals and Objective:
·
It is easy for new users to register and create
new account.
·
It maintains a central base of information.
·
It delivers all the information about student
profile as well as students attendance to be accessible by faculties.
·
It displays syllabus of various batches of CS
Department.
·
Faculties can view the profile of any of the
student.
·
Students can view their previous results, can
read books, and can communicate with teachers through provided email addresses.
1.2) System
statement of scope:
Major
inputs include all the particulars like student name, batch, student’s
attendance and various studies material etc. for all the students in the
department. Inputs include details of students and faculties. Outputs include
information about department, students result, students and faculties profile
and study material available for student, syllabus of various batches.
1.3)
System Context:
Creating
webpage for Computer science Department and implementing it on internet is
really a great idea both for the information seekers as well as for students
and faculties of department. It greatly helps the department and other users as
information about department and students is available at any time on web. It
increases the ease both for students and faculties.
1.4)
Technologies used:
·
Adobe Dreamweaver for PHP
·
MySQL-2005: Database.
1.5)
Overview:
Overall
Description will
describe major modules of the webpage and functionality of various major
modules used in the webpage.
2) Overall Description:
2.1) Communication Interface:
·
Client on Internet will be using HTTP/HTTPS
protocol.
·
IIS connect to mail server with SMTP
protocols.
2.2) Software Interface:
·
Client on Internet: Web Browser, Operating System (any)
·
Web Server: Operating System (any)
·
Data Base Server: SQL, Operating System (any)
·
Development End: Adobe Dreamweaver.
2.3) Hardware Interface:
Client Side
Hardware requirements
|
S.
No. |
Description |
Alternative
(If available) |
|
1 |
PC
with 20 GB hard-disk and minimum 512 MB RAM with Internet facility. |
Not-Applicable |
Software Requirements
|
S.
No. |
Description |
Alternative
(If available) |
|
1 |
Internet
Explorer |
Mozilla
Firefox / Google Chrome / Apple Safari |
Server side
Hardware requirements
|
S.
No. |
Description |
Alternative
(If available) |
|
1 |
PC
with 160 GB hard-disk and 2 GB RAM with Internet facility. |
Not-Applicable |
Software Requirements
|
S.
No. |
Description |
Alternative
(If available) |
|
1 |
Window
XP with MS-Office |
Not-Applicable |
|
2 |
MS-SQL
Server |
MS-Access |
2.4) Constraints:
Ø GUI is
only in English.
Ø Login
and password is used for identification of User.
2.5) Use case Survey:
2.5.1)
Administrator: Administrator is the central user of the
webpage. He is the only person who can add, delete and update the whole
database present on the webpage as well as in backend database. He can control
various operations to be used by students and faculties. All the moves could be
viewed by administrator at any instance. A dual password security is provided
to the administrator for the prevention of hacking.
2.5.2)
Other User: Other user include users other then administrator
can be faculties, students or any other person. The faculties can view profile
of any student and faculty of the department. They can also feed attendance,
study material references and comments for various students.
2.6) Assumption and Dependencies:-
Ø
User now the English and have good knowledge
of surfing.
Ø
Only registered users can login to its
account.
Ø Roles and tasks of each method are predefined.
3) Specific
requirement:
Use case report:-
3.1) Administrator:
·
Administrator can update the study material
available for the students; can update information about the department.
·
He can also update the quiz information (a
facility available for all the users of the webpage).
·
He can edit or delete the accounts of students
and faculties and other users.
·
Administrator can update any information about
department available on the website.
·
Administrator can update current and previous
news about department.
3.2) Module Functioning:
Student:
· A student
can view his academic performance.
· He can view
his attendance and marks in various subjects.
· He can give
various quizzes according to subjects.
· He can also download
or read the study material available for the students.
· He can also
view the limited profile of the faculties and students of the department.
· Total number
of students could also be viewed on this module.
Faculty:
·
Faculty can view profile of any student of the
department.
·
A faculty can view profile of other faculties
of the department.
·
Faculty can update academic information about
student like attendance, marks etc.
·
Faculty can view marks scored by various
students in quiz.
Academics:
·
Academics module consists of academics of the
branches associated with the Computer science Department.
·
Present available academics are for B.Tech,
M.tech and M.Tech dual courses.
Study Material:
·
This module consists the basic study material
available for the students.
·
It also consists various links of other WebPages
providing study material.
·
The material could be downloaded by the student
any time.
·
This module can be updated only by the
administrator.
About Us:
·
About Us module describes
about the department.
·
It gives basic information
related to the college and department.
Quiz:
·
The quiz module gives the
facility to students to take quiz base on their general knowledge about
subject.
·
Student can choose any of the
given subjects.
·
Various links are also
available for taking other quizzes through other websites.
Technology:
·
This module consists the
information about the present latest technologies in the market.
·
It gives an overview to the
student about present scenario.
Syllabus:
·
Syllabus module consists
syllabus of various batches according to their curriculum.
·
This module can only be edited
by administrator.
·
Syllabus of Rajasthan
Technical University and Gyan Vihar University are available on this module.
S.no
1
2
3
|
Field Name
Loginid
Password
accnumber
|
DataType
Varchar(30)
Varchar(30)
Varchar(30)
|
Constraints
N/A
N/A
N/A
|
S.no
1
2
3
|
Field Name
uid
uname
password
|
DataType
Int(11)
Varchar(30)
Varchar(30)
|
Constraints
Autoincreament
N/A
N/A
|
S.no
1
2
3
4
5
|
Field Name
balid
amount
prestime
transcid
accnumber
|
DataType
Int(11)
Int(11)
timestamp
varchar(30)
varchar(30)
|
Constraints
Autoincreament N/A
N/A
N/A
N/A
|
S.no
1
2
3
|
Field Name
reqid
cheque_number
accnumber
|
DataType
Int(11)
int(11)
Varchar(30)
|
Constraints
Autoincreament N/A
N/A
|
S.no
1
2
3
4
5
6
7
8
9
|
Field Name
firstname
lastname
address
phonenumber
emailid
loginid
password
accnumber
cid
|
DataType
Varchar(30)
Varchar(30)
Varchar(30)
Varchar(30)
Varchar(30)
Varchar(30)
Varchar(30)
Varchar(30)
Int(11)
|
Constraints
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
Autoincreament
|
S.no
1
2
3
4
5
|
Field Name
depid
amount
dptime
transcid
accnumber
|
DataType
int(11)
Varchar(30)
Timestamp
Varchar(30)
Varchar(30)
|
Constraints
Autoincreament N/A
N/A
N/A
N/A
|
S.no
1
2
3
4
|
Field Name
transferid
accto
accfrom
amount
|
DataType
int(11)
Varchar(30)
Varchar(30)
Varchar(30)
|
Constraints
N/A
N/A
N/A
N/A
|
S.no
1
2
3
4
5
|
Field Name
transcid
transcname
transctime
accnumber
amount
|
DataType
int(11)
Varchar(30)
Varchar(30)
Int(11)
Int(11)
|
Constraints
Autoincreament N/A
N/A
N/A
N/A
|
S.no
1
2
3
4
5
6
7
8
|
Field Name
wid
amount
mode
w_d_time
chequeno
accnumber
shopname
transcid
|
DataType
int(11)
Varchar(30)
Varchar(30)
Timestamp
Varchar(30)
Varchar(30)
Varchar(30)
Varchar(30)
|
Constraints
Autoincreament N/A
N/A
N/A
N/A
N/A
N/A
N/A
|
§ Controlling the amount of input
§ Avoid unauthorized access to The Bca projects in java banking transactions
§ Eliminating extra steps
§ Keeping the process simple
§ At this stage the input forms and screens are designed.
No comments:
Post a Comment