Super Shop Management System

This documentation has been prepared to give an overview of the Super shop management software system specification for the real-life projects that each student of Database Design and Development , has to develop and implement group. Super shop management software system should be purchased from software package vendors and customized to the departmental Super shop’s needs, if necessary. Customer service refers to a departmental Super shop ability to satisfy the needs of its customers by this Super shop management software system.

1. University of Development Alternative Super Shop Management System Presentation On

2. Project Members Md. Sohel Sarker ID : 011121010 Md. Mehedi Hasan ID: 011121044 Md. Rayhanul Kibria Rifat ID: 011121040 Hajera Akter Bithi ID: 011121019

3. Project Supervisor Muhammad Abdullah Al Mamun Project Coordinator & Sr. Lecturer Department of Computer Science & Engineering U|O|D|A

4. Introduction Super Shop In a retail environment, a super shop is a large retailer who stocks and sells a wide variety of merchandise including groceries, clothing and general supplies, or a large store that sells a massive quantity of goods in one product line such as electronics or shoes . Super shops are very large supermarkets or shops selling household goods and equipment . Super shops are usually built outside city centers away from other shops.  The best example of a superstore is Wal-Mart . A superstore is also referred to as a super center or megastore. Super Shop is a special market with different specialty. Super shop is located in special area for the class of people in Bangladesh. The products are categories in the super shop. The products are allocated with a highly qualified way.

5. Objectives Customer service refers to a departmental Super shop ability to satisfy the needs of its customers. Customer service Cost-efficient operations Super shop facility cost-efficient operations in several ways. Super shop investment As a company achieves lower amounts of money tied up in inventory, that company’s overall cost structure will improve, as will its profitability.

6. Output(1) Product information Customer Information Product Category Discount on product Special offer Package system Vat on products

7. Output(2) Supplier Information Sales Details Administration Information Sales man Information Payment Method Print Information Total Price

8. Output Details Product Id Name Category Stock Qu Vat Priee Discount 11101 Lux Soap 100.00 22 BDT 0.00 Product Information Customer Information Customer Id Customer Name Address City Gender Contact 11101 Sakib Soap Dhaka Male 017********* Included 0.00%

9. Output Details Product Id Product Category Description Vat Discount Price 02101 Food ********* 5% 10% Taka- 550 Product Category Discount on Product. Item Id Item Name Categories Original price Discount 02099 Fried Chicken ******** 100 10%

10. Output Details Product Id Name Category Stock QU Supplier Id Product Id 11101 Lux Soap 100 101 11101 Storage Information Special offer Offer Type Item Name Item Id Price Offer Occasion Thai TH- 01 BDT 550 5% Daily Offer BFC BF-02 BDT 750 10% Seasonal Offer KFC KF-03 BDT 1050 15%

11. Output Details Item Id Item Name Categories Package Price Original Price 02101 ******* ******* Tk 820 TK 950 Package System Vat On Total Services Item Id Item Name Categories price Vat TH- 01 THAI ******** BDT- 550 12%

12. Output Details Supplier Id Name Email Phone 02101 Kashem [email protected] 01686961933 Supplier Information Sales Details Product Id Price Quantity Discount by Supplier Vat Subtotal Discount by Salesman Grand Total 0202 100 2 0.00% 10% 230 10 230

13. Output Details Administrator User Name Password Admin Password Administrator Info Salesman Information Salesman Id Name Email Phone Address User Name Password 0202 Ali Baba [email protected] 016899999 ******** Sales05_s sell230

14. Output Details Item Id Item Name Categories Price Payment Method 02101 ******* ******* Tk 820 Cash Payment Method Print Information Sales Id Sales Date Product Name Quantity Price Vat Discount Grand Total Payble Re turn 101 11/3/2015 Lux 2 BDT- 22 44 44

15. Input Details (1) Admin panel. Sales man panel Product form Customer Information Form. Product category Form. Discount on Product. Storage information Form. Special offer form.

16. Input List (2) Package System form. Supplier Form. Sales details. Payment method. Print Information

17. Product Id Name Category Stock Qu Vat Price Discount 11101 Lux Soap 100.00 Included 0.00% 22 BDT 0.00 Customer Id Customer Name Address City Gender Contact 11101 Sakib Soap Dhaka Male 017********* Product Form Customer Information Form Input Details

18. Product Category Form Discount on Product Input Details Product Id Product Category Description Vat Discount Price 02101 Food ……… 5% 10% TK- 550 Item ID Item Name Categories Original price Discount 00210 Fried Chicken ………. 100 10 %

19. Storage Information Form Special offer Form Input Details Product Id Name Category Stock QU Supplier Id 11101 Lux Soap 100 112 Offer Type Item Name Item ID Price Offer Occasion Thai. TH-01 BDT-550 5% Daily offer BFC BF-02 BDT-5050 15% Seasonal offer KFC KF-03 BDT-1050 10%

20. Package System Form Supplier Form Input Details Item ID Item Name Categories Package price Original price 03021 …….. …………. Tk-850 Tk-920 Supplier Id Name Email Phone Product Id Product Quantity Product Price Discount by Supplier 112 Kames [email protected] 0155555555 11112 500 100 0.00%

21. Sales Details Payment Method Input Details Product Id Price Quantity Discount By Supplier Vat Subtotal Discount By Salesman Grand Total 112 100 2 0.00% 15% 230 10 220 Item ID Item Name Categories Price Payment Method 20125 …………….. …………… Tk-2500 Cash.

22. Print Information Input Details Sales Id Sales Date Product Name Quantity Price Vat Discount Grand total Payable Intended Return 111 11/26/2015 Lux 2 22 BDT 44 44 50 6

23. Parameters to be computed Vat calculation Vat amount = product price*(vat/100) Price with vat = product price + vat amount Discount fare calculation Discount fare calculation = product price*(discount fare/100) Total price = price with vat + discount fare amount

24. Required Tools Software Operating system NetBeans IDE Adobe Photoshop Xammp

25. Languages JAVA Front End JAVA MySql Back End Personal Computer Or POS Computer Barcode Scanner Invoice Printer or Personal Printer Hard Ware

26. Task Estimated time(week) Planning 2 E-R diagram 2 Database design 2 Interface Design 3 Coding 4 Debugging and Testing 2 Documentation and reporting 2 Total time 17 weeks Time Frame

27. The People are having a lot troubles while buying the everyday necessary product. They also have to waste their time. But now a day’s every time of a person is most valuable, nobody wants to waste time if he or she has the facility to get his or her desired service at a single moment. We are confident that this Super shop management software system specification for the real-life Customer service refers to a departmental Super shop ability to satisfy of the management of supper shop needs. Conclusion

28. Thank You For Your Time