Gurukrupa Restaurant MBA Porject Report Prince Dudhatra
-
Upload
prince-dudhatra -
Category
Documents
-
view
216 -
download
0
Transcript of Gurukrupa Restaurant MBA Porject Report Prince Dudhatra
-
8/6/2019 Gurukrupa Restaurant MBA Porject Report Prince Dudhatra
1/7
Gurukrupa Restaurant
Sales Transaction
and
Inventory control
Developed By :
Jadeja Jyoti J.
Jadeja Nehaba J.
Smt.J.J.Kundalia Commerce College
Computer Science Department
-
8/6/2019 Gurukrupa Restaurant MBA Porject Report Prince Dudhatra
2/7
Index
1 Preface
2 Project Overview
3 Objective of Project
4 The Proposed System
5 Advantages of Propose System
6 Limitation of system
7 Future Expansion
8 Software Requirement
9 Why Visual Basic 6.0 used for this Project
10 Forms
-
8/6/2019 Gurukrupa Restaurant MBA Porject Report Prince Dudhatra
3/7
PREFACE
Smt.J.J.Kundalia Commerce College
Computer Science is affiliated with Saurashtrauniversity. The institutes has multiple objectives the
basic being an urge to cater to explosion of popular
expectation for standard education in the field of
computer and technology over and above equipping
the post independence generation of Saurashtra with
the updated global trends in commerce and industry.The college also intends to develop universal
perception , qualities of humanism and development
of the comprehensive character, leadership ,
executive acumen and the spirit of entrepreneurship
among the youth.
The Post Graduate Diploma in computerApplication is the dynamic degrees, course offering
unique chance to be able to find ones way through
the intricacies and complexities at the info world.
The Project development is the acid test of
theoretical knowledge of the students aftercompleting the course. This project development
aims at bridging the gap between theatrical and
practical knowledge.
-
8/6/2019 Gurukrupa Restaurant MBA Porject Report Prince Dudhatra
4/7
VARIOUS TABLES USED IN OUR SOFTWARE :-
FOOD CATEGORY
FIELDS DATA TYPE SIZE
CATEGORY_ID NUMBER 2
CATEGORY_NM TEXT 50
EMPLOYEES
FIELDS DATA TYPE SIZEEMPLOYEE_ID NUMBER 3
FIRSTNAME TEXT 50
LASTNAME TEXT 50
TITLE TEXT 50
EXTENSION TEXT 50
WORKPHONE NUMBER 8MENU ITEMS
FIELDS DATA TYPE SIZE
PRODUCT_ID NUMBER 4
PRODUCT_NM TEXT 50
PRODUCTDESCRI TEXT 50CATEGORY_ID TEXT 4
SERIALNUMBER NUMBER 8
UNITPRICE NUMBER 4
PURCHASE_ORDERS
-
8/6/2019 Gurukrupa Restaurant MBA Porject Report Prince Dudhatra
5/7
FIELDS DATA TYPE SIZE
DATE DATE 8
PURCHASE_ORDER NUMBER 8PONUMBER NUMBER 8
PURCHASE_ORDER TEXT 20
SUPPLIER_ID NUMBER 4
EMPLOYEE_ID NUMBER 4
ORDERDATE DATE 8
DATE_REQUIRED DATE 8DATE PROMISED DATE 8
SHIP DATE DATE 8
SHIPPING METHODS TEXT 50
FREIGHT CHARGE NUMBER 5
SALES
FIELDS DATA TYPE SIZE
TRANSAC_ID NUMBER 4
TRANSAC_DATE DATE 8
PRODUCT_ID NUMBER 4
PURCHASEORDER NUMBER 20
TRANSACTION_DESC TEXT 50
UNITPRICE DOUBLE 5UNITORDERED NUMBER 8
UNITSOLD NUMBER 8
UNITS_SHRINKAGE NUMBER 8
-
8/6/2019 Gurukrupa Restaurant MBA Porject Report Prince Dudhatra
6/7
SHIPPING METHODS
FIELDS DATA TYPE SIZE
SHIPPING_ID NUMBER 5SHIPPINGMETHODS TEXT 50
SUPPLIERS
FIELDS DATA TYPE SIZE
SUPPLIERS_ID NUMBER 4
SUPPLIERS_NM TEXT 20CONTACT_NM TEXT 15
CONTACTTITLE TEXT 15
ADDRESS TEXT 20
CITY TEXT 15
POSTALCODE NUMBER 8
STATEPROVINCE TEXT 8COUNTRY TEXT 8
PHONENUMBER NUMBER 8
FAXNUMBER NUMBER 15
-
8/6/2019 Gurukrupa Restaurant MBA Porject Report Prince Dudhatra
7/7
Acknowledgement
No serious and lasting achievement or success
one can ever achieve without the help of friendlyguidance and co-operation of so many people
involved in the work.
We are also thankful to Mr.Hasit Metha, who
gave as our project guide and superior.
Our Special thanks to our family members, our
friends and our well-wisher for their moral supportand inspiration.
We are thankful to our college under whose
guidance, we have successfully completed our project
with all valuable suggestion.
We are especially thankful to Mr. shamik Rathod
Head of Department of our college for his end-less
and great support.
Jadeja Jyoti J.
Jadeja Nehaba J.