System development project document

Develop By Smit Patel

1

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

18

4.2.2

First Level Diagram

19

4.2.3

Second Level Diagram

20

4.2.4
JGCCA

Data Flow Diagram.

Entity Relationship Diagram

21

System Development Project (2009-2010)

16

5.

Data Dictionary

23

6.

Forms Layout

34

7.

Reports Layout

80

8.

Bibliography

87

JGCCA


16


2

JGCCA


16


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


16


3

JGCCA


16


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


16


4

JGCCA


16


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


16


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


16


5

JGCCA


16


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


16


6

JGCCA


16


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


16


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


16

database applications can use the catalog to present users with data from
different databases dynamically, without being tied to a specific data format.

JGCCA


16


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


16


7

JGCCA


16


Data flow Diagrams

JGCCA


16


JGCCA


16


Entity Relationship Diagram

JGCCA


16


8

JGCCA


16


Table: Login_Master

Field Name

Data Type

Length

Constraints

Description

Login_ID
Login_Username
Login_Password

Numeric
Varchar
Varchar

3
25
25

P_K
Not Null
Not Null

Stores Login ID
Stores username
Stores password

Description:
This table is used by administrator to login purpose. This table contains
login information of administrator

JGCCA


16


Table: Category_Master
Field Name
Category_ID
Category_Name

Datatype
Numeric
Varchar

Length
3
25

Constraint
P_K
NOT NULL

Description
Unique ID
Information of
Category

Description:
This Table is used to store Category information

JGCCA


16


Table: Product_Master
Field Name
Product_ID

Data type
Numeric

Length
3

Constraint
P_K

Product_Name

Varchar

25

NOT NULL

Product_Price

Numeric

6

NOT NULL

Category_ID

Numeric

3

F_K

Description
Stores Product
ID
Stores Product
Name
Stores Product
Price
Stores
Category_ID

Description:
This Table is used to stores Product information

JGCCA


16


Table : Order_Master
Field Name
Order_ID
Bill_No
Customer_Id
Product_Id
Selected_Quntity
Order_Date

Data type
Numeric
Numeric
Numeric
Numeric
Numeric
datetime

Length
6
6
6
3
4
2

Constraint
P_K
F_K
F_K
F_K
Not null
Not null

Description
Store order id
Store bill number
Store customer id
Store product id
Store quantity
Store order date

Description:
This table is used to store order

JGCCA


16


Table: Customer_master
Field Name
Customer_ID

Data type
Numeric

Length
6

Constraint
P_K

Customer_Name

Varchar

25

NOT NULL

Customer_address

Varchar

500

NOT NULL

Customer_Phone

Varchar

25

NOT NULL

Description
Store
customer id
Store
customer
name
Store
customer
address
Store
customers
phone
number

Description:
This table is used to store Customers Details

JGCCA


16


Table: Employee_Master
Field Name
Employee_ID

Data type Length
Numeric
3

Employee _Name

Varchar

25

Employee _address

Varchar

500

Employee_DOB

Datetime

-

Employee_join_Date

Datetime

-

Varchar

25

Employee_Designation

JGCCA

Constraint Description
P_K
Store
employee
id
NOT NULL
Store
employee
name
NOT NULL
Store
employee
address
NOT NULL
Store
employee
dob
NOT NULL
Store
employee
join date
NOT NULL
Store
employee
designation


16


Table: Salary_Master

Field Name
Salary_ID

Data type
Numeric

Length
5

Constraint
P_K

Salary_Amount

Numeric

5

NOT NULL

Salary_date

Datetime

-

NOT NULL

Employee_ID

Numeric

3

F_K

Description
Store salary
id
Store
amount
Store salary
date
Store
employee id

Description:
This table is used to store Salary of Employee

JGCCA


16


Table: Application_Settings_Master

Field Name
Settings_Id

Data type
Numeric

Length
3

Constraint
P_K

Settings_Nmae

Varchar

25

NOT_NULL

Settings_Value

Varchar

25

NOT_NULL

Description
Store
setting id
Store
setting
name
Setting
value

Description:
This table is used to store Setting Details

JGCCA


16


Table : RawMaterials_Master

Field Name
Rawmaterial_ID
Rawmaterial_desc

Data type
Numeric

Length
6

Constraint
P_K

Varchar

350

Not Null

Description
Stores Raw
material ID
Store raw
material
description

Description:
This table is used to store Raw material details

JGCCA


16


Table : Bill_Master
Field Name
Bill_No

Datatype
Numeric

Length
6

Constraint
P_K

Product_id

Numeric

4

F_K

Customer_id

Numeric

6

F_K

Selected
_quantity

Numeric

3

Not null

Total_price

Numeric

6

Not null

Description
Store bill
number
Store
product id
Store
customer id
Store
selected
quantity
Store total
price

Description:
This table is used to store Bill Details

JGCCA


16


9

JGCCA


16


1
0

JGCCA


16


1
1

JGCCA


16


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


16

System development project document

Recommended

Recommended

More Related Content

What's hot

What's hot (20)

Similar to System development project document

Similar to System development project document (20)

More from Smit Patel

More from Smit Patel (12)

Recently uploaded

Recently uploaded (20)

System development project document