1 of 14

  • Parekh Jigna G.
  • Parmar Darshana S.

Third Year B.C.A

(2008-09)

Submitted to:

NAVGUJARAT COLLAGE OF COMPUTER APPLICATION

Navgujarat Campus,Ashram Road, Ahmedabad-380014

Online Food Shopping

2 of 14

Index

  • Acknowledgement
  • College profile
  • Project profile
  • Hardware & Software specification
  • Data Flow Diagram
  • ER Diagram
  • Data Dictionary
  • Relationships
  • Description of Forms
  • Screen shots

3 of 14

Acknowledgement

It is indeed a great pleasure to look and take this Opportunity to express my gratitude towards all the people who helped us and to make this project successful.

I extend my sincere gratitude to my project guide Prof. Kaushar Ghachi who has constantly remained helpful in suggesting directions and providing us with invaluable guidance throughout this project.

We would like to express whole hearted thanks to my all friends and well-wishers who are innovative and true guide in the situation of difficulties.

4 of 14

College Profile

  • Name: Navgujarat College Of Computer Application
  • Address: Navgujarat Campus,
          • Ashram Road,
          • Ahmedabad.

5 of 14

Project profile

Project Name

Online Food Shopping

Project Definition / Goal

To Keep Every Day’s Data Of Customer Who is Ordered From Online Food Shopping.

Internal Guide

Prof. Kaushar Ghachi

Team size

Two Person

Developed By

Parmar Darshana S.

Parekh Jigna G.

6 of 14

H/W & S/W Specification

  • Hardware

System :- Pentium 4 dual core or faster processor

Memory :-512MB RAM or Higher

  • Software

O/S :- Microsoft Windows XP Professional

Web Server :-IIS (Internet Information Service)

Tools :- Front End -> ASP.NET2005

Back End -> SQL SERVER2005

Scripting Language :- VB Script

HTML (Hyper Text Mark-up Language)

7 of 14

Structure Of Table

Field Name

Data Type

Size

Constraint

Description

UserID

Varchar

9

Primary Key

User Identity Number

Password

Varchar

20

User Password

Access

Number

1

Access Specification

Top Level Authorities

Mid Level

Clerk Use

DATA DICTIONARY

Table Name : - Customer Master

8 of 14

Table Name : - Category Master

Field Name

Data Type

Size

Constraint

Description

CateID

numeric

9

Primary Key

Category Identity Number

CateName

Varchar

35

Category name

Catpid

numeric

9

Company Id

CateRemark

Varchar

100

categorymark

9 of 14

Table Name : - Item Master

Field Name

Data Type

Size

Constraint

Description

ItemID

Numeric

9

Primary Key

Item Identity Number

ItemName

Varchar

35

Item Name

ItemBillingPrice

Numeric

9

Item Billing Price

ItemMRP

Numeric

9

Max Retail Price

Item Date

Varchar

11

Item Date

CateID

Numeric

9

Foreign Key

Category Identity

Item Remark

Varchar

100

Item remark

10 of 14

Table Name : - Scheme Master

Field Name

Data Type

Size

Constraint

Description

Scheme id

numeric

9

Primary Key

Scheme id

Scheme name

Number

9

Scheme name

Scheme start Date

Date/Time

9

Scheme start Date

Scheme end date

Varchar

9

Scheme end date

Item id

numeric

9

Scheme item id

Scheme min qty

numeric

9

Scheme quantity

Scheme free itemid

numeric

9

Scheme free qty

numeric

9

11 of 14

Screen Shots

12 of 14

Screen Shots

13 of 14

Screen Shots

14 of 14

Screen Shots