System development project document

Develop By Smit Patel
Index
1. Introduction 5
2. Company Profile 7
3. Existing System 9
4. Proposed System 12
4.1 Development tools and Technology used 14
4.2 System Features
4.2.1 Data Flow Diagram. 18
4.2.2 First Level Diagram 19
4.2.3 Second Level Diagram 20
4.2.4 Entity Relationship Diagram 21
JGCCA System Development Project (2009-2010)
16
1

Develop By Smit Patel
5. Data Dictionary 23
6. Forms Layout 34
7. Reports Layout 80
8. Bibliography 87
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
JGCCA System Development Project (2009-2010)
16
2

Develop By Smit Patel
Introduction
About Project
This is Studio Management System which provides this type of facilities:
Some of System Capabilities
·Administrator can view customer details.
·Administrator can generate reports.
·Administrator can manage employee & their salaries.
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
JGCCA System Development Project (2009-2010)
16
3

Develop By Smit Patel
Company Profile
"Eternal Software Solutions" is a professional web design and development
company based in Ahmedabad India. The firm is headed by a group of young IT
professionals. Our strength is in providing best solutions to our clients with a clear and
transparent business process. "Eternal Software Solutions" provides a competitive edge
through cost and quality advantage, use of the state-of-art skills and high reliability thus
increases ability to save time on projects. The aim of the firm is to create a mark in the
IT industry.

We provide professional web solutions, including Web Design, Web Application,
Software Development, and Graphic Design, Multimedia Presentation, 2d and 3d
Animation, flash website design, search engine optimization, Corporate Identity,
Multimedia Solutions and Internet Marketing services.
The potency of "Eternal Software Solution" lies in long term relations with our
clients. Our stress is always on top quality services and unmatched customer support.
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
JGCCA System Development Project (2009-2010)
16
4

Develop By Smit Patel
Existing System:
• Generates bill Manually
•Crop image in other software.
•Data store manually.
New System:
• Generates bill Automatically
•Crop image in own system
•Data store Automatically
action of Existing System
The main problem Area’s are as follows:
Data Redundancy
Data Inconsistency
Data Security
Data Integrity
As the System requires more time so it is less efficient & this result in more errors &
wrong information. In the manual system the modification is very hard. Observing the
manual, it is found that the system is time consuming and the accuracy is also less.
Data Redundancy
In manual System, each application has its own private files. This act can lead to
considerable redundancy in manual stored data. Because the data is distributed into
various systems, there is some data in which make redundancy.
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
Data Inconsistency
In manual Database System, if the redundancy is not controlled then the system is not
aware of the duplication. In such Situations, the data Updating Process will not be
handled properly, because the data is distributing there must be some Data
Inconsistency.
Data Security
In manual System, all the files are of Paper-work. So, we cannot provide any kind of
Security to our data. Data may be Viewed by anyone and Changed by anyone or lost by
some employee as well as no back-up is taken
Data Integrity
The Data Integrity means “The Incorrectness of data”. If there is no redundancy in he
system and dalais in consistent stage, then also the database might have wrong
information.
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
JGCCA System Development Project (2009-2010)
16
5

Develop By Smit Patel
Company has proposed following task to be complete in this project
-Searching should be performed speedily
-Data storage capacity must be high
-Reduce manual operations more as possible
-Application should be able to generate various reports
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
JGCCA System Development Project (2009-2010)
16
6

Develop By Smit Patel
Development tools and technology used
vb.net 2005 – Programming Language
vb.net 2005 is an interpreted, Object-oriented, Programming language.
vb.net 2005 has been used for managing server/Client machines and databases
by programmers. It is also serving web pages, interfacing to databases and
generating dynamic content.
Features of vb.net 2005
It is purely Object Oriented Programming language.
It is dynamic & interpreted language.
It is multi-platform.
It is thread capable and has the capability to handle exceptions.
It has an advanced array class and it is extensible.
It has operator overloading, finite-precision integer arithmetic and
Powerful string Handling.
It is concise and has rich set of libraries.
Many important data-structures are available(such as dynamic
Arrays, Strings).
Rich metadata.
No need For Separate Interface Language (Such as IDL).
A Strong Security model for the Components.
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
SQL Server 2005
Introduction
The database component of Microsoft SQL Server 2005 is a Structured
Query Language (SQL)–based, scalable, relational database with integrated
Extensible Markup Language (XML) support for Internet applications. Each of
the following terms describes a fundamental part of the architecture of the
SQL Server 2005 database component:
Database
A database is similar to a data file in that it is a storage place for data. Like
a data file, a database does not present information directly to a user; the user
runs an application that accesses data from the database and presents it to the
user in an understandable format.
Database systems are more powerful than data files in that data is more
highly organized. In a well-designed database, there are no duplicate pieces of
data that the user or application must update at the same time. Related pieces
of data are grouped together in a single structure or record, and relationships
can be defined between these structures and records.
When working with data files, an application must be coded to work with
the specific structure of each data file. In contrast, a database contains a
catalog that applications use to determine how data is organized. Generic
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
database applications can use the catalog to present users with data from
different databases dynamically, without being tied to a specific data format.
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel

A database typically has two main parts: first, the files holding the physical
database and second, the database management system (DBMS) software that
applications use to access data. The DBMS is responsible for enforcing the
database structure, including:
·Maintaining relationships between data in the database.
·Ensuring that data is stored correctly and that the rules defining data
relationships are not violated.
·Recovering all data to a point of known consistency in case of system
failures.
Structured Query Language
To work with data in a database, you have to use a set of commands and
statements (language) defined by the DBMS software. Several different languages
can be used with relational databases; the most common is SQL. The American
National Standards Institute (ANSI) and the International Standards Organization
(ISO) define software standards, including standards for the SQL language. SQL
Server 2000 supports the Entry Level of SQL-92, the SQL standard published by ANSI
and ISO in 1992. The dialect of SQL supported by Microsoft SQL Server is called
Transact-SQL (T-SQL). T-SQL is the primary language used by Microsoft SQL Server
applications.
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
JGCCA System Development Project (2009-2010)
16
7

Develop By Smit Patel
Data flow Diagrams
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
Entity Relationship Diagram
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
JGCCA System Development Project (2009-2010)
16
8

Develop By Smit Patel
Table: Login_Master
Field NameData Type LengthConstraintsDescription
Login_ID Numeric 3 P_K Stores Login ID
Login_Username Varchar 25 Not NullStores username
Login_Password Varchar 25 Not Null Stores password
Description:
This table is used by administrator to login purpose. This table contains
login information of administrator
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
Table: Category_Master
Field Name Datatype Length Constraint Description
Category_ID Numeric 3 P_K Unique ID
Category_Name Varchar 25 NOT NULL Information of
Category
Description:
This Table is used to store Category information
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
Table: Product_Master
Field Name Data type Length Constraint Description
Product_ID Numeric 3 P_K Stores Product
ID
Product_Name Varchar 25 NOT NULL Stores Product
Name
Product_Price Numeric 6 NOT NULL Stores Product
Price
Category_ID Numeric 3 F_K Stores
Category_ID
Description:
This Table is used to stores Product information
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
Table : Order_Master
Field Name Data typeLength Constraint Description
Order_ID Numeric 6 P_K Store order id
Bill_No Numeric 6 F_K Store bill number
Customer_Id Numeric 6 F_K Store customer id
Product_Id Numeric 3 F_K Store product id
Selected_Quntity Numeric 4 Not null Store quantity
Order_Date datetime 2 Not null Store order date
Description:
This table is used to store order
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
Table: Customer_master
Field Name Data typeLengthConstraintDescription
Customer_ID Numeric 6 P_K Store
customer id
Customer_Name Varchar 25 NOT NULL Store
customer
name
Customer_addressVarchar 500 NOT NULL Store
customer
address
Customer_Phone Varchar 25 NOT NULL Store
customers
phone
number
Description:
This table is used to store Customers Details
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
Table: Employee_Master
Field Name Data typeLengthConstraintDescription
Employee_ID Numeric 3 P_K Store
employee
id
Employee _Name Varchar25 NOT NULL Store
employee
name
Employee _address Varchar500NOT NULL Store
employee
address
Employee_DOB Datetime - NOT NULL Store
employee
dob
Employee_join_DateDatetime - NOT NULL Store
employee
join date
Employee_DesignationVarchar25 NOT NULL Store
employee
designation
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
Table: Salary_Master
Field NameData typeLengthConstraintDescription
Salary_ID Numeric 5 P_K Store salary
id
Salary_AmountNumeric 5 NOT NULL Store
amount
Salary_date Datetime - NOT NULLStore salary
date
Employee_ID Numeric 3 F_K Store
employee id
Description:
This table is used to store Salary of Employee
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
Table: Application_Settings_Master
Field NameData typeLengthConstraintDescription
Settings_Id Numeric 3 P_K Store
setting id
Settings_NmaeVarchar 25 NOT_NULL Store
setting
name
Settings_ValueVarchar 25 NOT_NULL Setting
value
Description:
This table is used to store Setting Details
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
Table : RawMaterials_Master
Field Name Data typeLengthConstraintDescription
Rawmaterial_IDNumeric 6 P_K Stores Raw
material ID
Rawmaterial_descVarchar 350 Not NullStore raw
material
description
Description:
This table is used to store Raw material details
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
Table : Bill_Master
Field NameDatatype Length ConstraintDescription
Bill_No Numeric 6 P_K Store bill
number
Product_id Numeric 4 F_K Store
product id
Customer_idNumeric 6 F_K Store
customer id
Selected
_quantity
Numeric 3 Not null Store
selected
quantity
Total_priceNumeric 6 Not nullStore total
price
Description:
This table is used to store Bill Details
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
JGCCA System Development Project (2009-2010)
16
9

Develop By Smit Patel
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
JGCCA System Development Project (2009-2010)
16
1
0

Develop By Smit Patel
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
JGCCA System Development Project (2009-2010)
16
1
1

Develop By Smit Patel
JGCCA System Development Project (2009-2010)
16

Develop By Smit Patel
We have used the following materials for reference:
Books:
ASP.NET 2.0 Unleashed .
Msdn(Microsoft Developers Network)
Asp.NET Black Book
ASP.NET Black Book.
Websitesvisited:
www.Msdn.com.
www.vbguru.com
www.codeplex.com
JGCCA System Development Project (2009-2010)
16

System development project document

About This Presentation

Slide Content

Tags

Categories

Download

Quick Actions

Statistics

Related Slideshows

System development project document

About This Presentation

Slide Content

Slide 1

Slide 2

Slide 3

Slide 4

Slide 5

Slide 6

Slide 7

Slide 8

Slide 9

Slide 10

Slide 11

Slide 12

Slide 13

Slide 14

Slide 15

Slide 16

Slide 17

Slide 18

Slide 19

Slide 20

Slide 21

Slide 22

Slide 23

Slide 24

Slide 25

Slide 26

Slide 27

Slide 28

Slide 29

Slide 30

Slide 31

Slide 32

Slide 33

Slide 34

Slide 35

Slide 36

Slide 37

Slide 38

Slide 39

Slide 40

Slide 41

Slide 42

Slide 43

Slide 44

Slide 45

Slide 46

Slide 47

Slide 48

Slide 49

Slide 50

Slide 51

Slide 52

Slide 53

Slide 54

Slide 55

Slide 56

Slide 57

Slide 58

Slide 59

Slide 60

Slide 61

Slide 62

Slide 63

Slide 64

Slide 65

Slide 66

Slide 67

Slide 68

Slide 69

Slide 70

Slide 71

Slide 72

Slide 73

Slide 74

Slide 75

Slide 76

Slide 77