new synopsis bca project

7/28/2019 New Synopsis BCA project

1/14

A Report Submitted AsProposal Of The Project

B.C.A 6 th Semester

Submitted by Prince Arora

Under Supervision of Mr.Prabhjeet Singh[M.C.A.]

INDIRA GANDHI NATIONAL OPEN UNIVERSITYNEW DELHI-110068


2/14

INTRODUCTION/OBJECTIVE Project will be created for the Study

Centers/Colleges/Universities etc to maintain the records of the

students with various information to help the administration of the

college to track the student, colleges always face challenges to

manually keep the track of the students and the training information.

With this project it will be easy to maintain the student information

with marks, training information, company information and various

projects they created during the period of training.

The following main options will be available in the project Input Student Data Input Company Data Search Data Project Information

Training Information Result Crystal Reports To Print Information

o To Print Student Data

o To Print Training Information

o To Display Data Of Individual Student

o And Many Other Reports According The Requirement

Of The Administrative Department Of the College.


3/14

Project CategoryThis is The Project That Come Under Database Category

[RDBMS]. This Project Will Be Created in VB.NET and SQL Server.

VB.Net Will Be Used As Front End And SQL Server As Back End.

HARDWARE / SOFTWARE REQUIREMENTS

HARDWARE Microprocessor Pentium 4 or more 1GB RAM 40GB Hard Disk Keyboard, Mouse

Display Card

Color Monitor CD ROM to install Software.

SOFTWARE

Visual Studio 2008 SQL Server MS Office

Device Drivers.PLATEFORM

Windows [Project Will Be Developed On Windows XP]


4/14

Why I Will Use VB.NET And SQL Server

Microsoft SQL Server that are tightly integrated with Microsoft

technologies to help us in:

1. Reduce costs and increase storage efficiency

2. Automate time-consuming data management processes,

including backup and recovery

3. Reduce the amount of time and storage needed to create

SQL Server database clones required for application

development and testing

4. Protect your SQL Server data with frequent and space-

efficient backups that do not impact system performance

5. Maintain availability of your SQL Server databases during

planned or unplanned downtime

6. Restore a failed database of any size to full production in

minutes

7. Quickly reestablish full system availability in the event of a

disaster

VB.NET

1 supports Threading

2 powerful Exception handling mechanism

3 having support for the console based applications

4 More than one version of dll is supported


5/14

Tables Used In The Project

Company Table[cmp_tbl]

Field Name DataType

Discription PrimaryKey/

Foreign Key

Cmp_Name Text Store Compay Name Primary Key

Deals_In Text Store Information Regarding

the work of the company

Mang_Name Text Store manger name

Address Text Store address of the

company

Contact_No1 Text Store contact no

Contact_No2 Text Store second contact no

Email_Id Text Store email id of the

company

Total_Emp int Store total no of employes of the company


6/14

Result table [rslt_tbl]Field Name Data

Type

Discription Primary

Key/

Foreign Key

Roll_no Text Store roll no of the student Foreign Key

Trng_time Text Store Timing Of The traing

Marks Text Store marks in persentage

Grade Text Store grade

Remarks Text Store marks

Cmp_name Text Store company name


7/14

Result table [rslt_tbl]Field Name Data

Type

Discription Primary

Key/

Foreign Key

Roll_no Text Store roll no of the student Primary Key

Stu_name Text Store name of the student

Class Text Store class

Batch Text Store batch

Semester int Store semester

Session Text Store sessionDOB Text Store DOB

Father_name Text Store father name

Mother_Name Text Store mother name

Address Text Store address

Contact_No Text Store contact no

Email Text Store email id


8/14


9/14

DATA FLOW DIAGRAM

The data flow diagram is used to represent a system or

software at any level of abstraction. DFDs may be portioned into levels

that represent increasing information flow and functional detail. Thus,

the DFD offers a mechanism for functional modeling as well as

information flow modeling. And, it satisfies the second operational

analysis principle.

DFD Level 0

1.0

ManagementSystems

User Database

Data Request

Data Response

Data Response

Data Request

1.0

ManagementSystems

User Database

Data Request

Data Response

Data Response

Data Request

1.0

Training

Systems

User Database

Data Request

Data Response

Data Response

Data Request


10/14

1.1

LoginSystem

User Password

L o g i n D

a t a R e q

u e s t

V e r i f i e d R e s p o

n s e

L o g i n R e s p o n s e

L o g i n R e q u e s t

1.1

LoginSystem

User Password

L o g i n D

a t a R e q

u e s t

V e r i f i e d R e s p o

n s e

L o g i n R e s p o n s e

L o g i n R e q u e s t

DFD Level 1

DFD Level 2

2.1

Records

2.2Training Records

2.3

Records

User Logon

Database Data Request

Data Request

Data Request

Data Request

Data Request

Data Request

2.1

Records

2.2

Records

2.3

Records

User Logon


Data Request

Data Request

Data Request

Data Request

Data Request

2.1StudentRecords

2.2

Records

2.3Company

Records

User Logon


Data Request

Data Request

Data Request

Data Request

Data Request

2.1

Records

2.2

Records

2.3

Records

User Logon


Data Request

Data Request

Data Request

Data Request

Data Request


11/14

ER-DIAGRAM

Database will be consisting of number of tables. First of all an

ER-diagram showing the entity and their relationships is created. Thenentity sets and relations are converted into tables as per requirement.

Careful study of the input-output requirements reveals the attributes

of the tables. Finally the table structures are refined applying

normalization. Here, normalization up to 3NF has been adopted..

rollno

name

a e

rolln

Project etc

Tra r

Traing process

Company datacompanyname

Have

Student data

Trainingrollno

Location

class

branch

Res_p

result

resul

session


12/14

Basic Structure Of Software

Modules/forms will be created in the project

Search by

name

Search by

company

name

Search by

name

Search by name view all company

Search by

roll no

Update Search by roll

no

Update view all training

Update data delete Update Delete View all result

Delete data Delete View stu one by one

view company one byone

View training one by

one

View result one by one

First Form

Login Form

MDI form

student trainingcompany result reports


13/14


14/14

3. System Testing: - The entire system is tested the goal is to see if

the software meets its requirements.

4. Acceptance Testing: - Acceptance Testing is performed in front the

client that software is working satisfactory.

Limitation Of The Project

This project is not an online system. So, it is not possible to

maintain the database from a remote Computer. As this system has

been developed in GUI environment so, it is expensive to use because

GUI tools are required to use the software.

Future Scope Of The Project

I will Continuously Work For The Improvement Of the Project. I am

Also Planning To Convert This Desktop Application Into The Web

Application, So That Data Can Be View and entered from Anywhere.

In the Web based project the blogging system can be included so that

users can give and take advice from each other regarding training and

study.

new synopsis bca project

Documents