Madira Delivery Application

PROJECT REPORT

Submitted by:

VAIBHAV JOSHI
200640116001
In partial fulfillment for the award of the degree of

BACHELOR OF ENGINEERING

In

INFORMATION AND TECHNOLOGY ENGINEERING

K. J. INSTITUTE OF ENGINEERING AND TECHNOLOGY,

VADODARA

Gujarat Technological University, Ahmedabad

October, 2023
 K. J. INSTITUTE OF ENGINEERING AND
TECHNOLOGY, VADODARA, VADODARA

INFORMATION AND TECHNOLOGY ENGINEERING

CERTIFICATE
This is to certify that the project entitled “Madira Delivery Application” has been carried out by

VAIBHAV JOSHI (200640116001). under my guidance in partial fulfillment for the degree of Bachelor of
th
Engineering in INFORMATION AND TECHNOLOGY ENGINEERING, 7 Semester of Gujarat

Technological University, Ahmedabad during the academic year 2023-24.

Guides:

MRS. HIRAL PATEL MS. PRANAVI PATEL

(Associate Professor) (Head of the Department)
 K. J. INSTITUTE OF ENGINEERING AND TECHNOLOGY, VADODARA

INFORMATION AND TECHNOLOGY ENGINEERING

DECLARATION
I hereby declare that the project entitled “Madira Delivery Application” submitted in partial

fulfillment for the degree of Bachelor of Engineering in INFORMATION AND TECHNOLOGY

ENGINEERING to Gujarat Technological University, Ahmedabad, is a Bonafede record of original project

work carried out by me at “Athulya Tech” Under the supervision of Mrs. Hiral Patel and that no part of this

report has been directly copied from any student’s reports or taken from any other source, without providing

due reference.

Name of the Student Sign of Student.

VAIBHAV JOSHI (200640116001)

 ACKNOWLEDGEMENT

I would like to extend our heartiest thanks with a deep sense of gratitude to “Athulya Tech” and respect to

all those who provided me with immense help and guidance during our internship period.

I convey our sincere gratitude to my Mentor “Mr. Ridhdhish Chaudhary”, Sr Android Developer at Athulya

Tech, Vadodara. Without his kind direction and proper guidance, this study would have been a little success.

Inevery phase of the task, his supervision and guidance shaped this report to be completed perfectly.

Last but not the least, I would like to mention here that I am greatly indebted to each and everybody who has

been associated with my project at any stage but whose name does not find a place in this acknowledgement. I

would also like to thank my colleagues for giving me a clear idea about every task.

With sincere regards,

VAIBHAV JOSHI [200640116001]

I
 ABSTRACT

The aim of this project is to develop an online application called " Madira Delivery Application " that
provides a user- friendly interface for buying and selling liquor and wine. The application is designed to make
it easy for customers to find their preferred drinks, place orders, and receive them at their doorstep. The platform
also features a rating system that allows customers to rate their experiences with different products, making it
easier for others to make informed purchasing decisions.

To ensure the legality of the application, the team has researched and complied with all applicable liquor and
wine regulations in the target market. Additionally, to ensure customer privacy and security, robust security
measures have been implemented to protect personal and financial information.

The project has been developed using a combination of modern mobile technologies such as Kotlin and Kotlin
and makes use of RESTful APIs to communicate with the server. The Madira Delivery Application has been
designed to be scalable, modular, and easy to maintain, making it ideal for further development and
improvement in the future.

The outcome of this project is a mobile application that provides a convenient and secure way for customers to
buy and sell liquor and wine. It is hoped that the Madira Delivery Application will be well received by the target
market and provide a profitable business opportunity for investors.

II
 LIST OF FIGURES

SERIAL NO. DESCRIPTION PAGE NO.

4.1 Customer Use Case 12
4.2 Admin Use Case 13
4.3 Admin Class Diagram 14
4.4 Sequence Diagram 15
4.5 Admin Activity Diagram 16
4.6 Customer Activity Diagram 17
4.7 Deployment Diagram 18
6.1 Delivery boy signup and login 32
6.2 Delivery Details and Payment page 33
6.3 Track and Order 34
6.4 Accept Order 35
7.1 Test Strategies 38
7.2 Login Test Case 40

III
 LIST OF TABLES

SERIAL NO. DESCRIPTION PAGE NO.

5.1 Customer Master 22
5.2 Store Setting Details 24
5.3 Store Master 25
5.4 Product Master 26
5.5 Coupon Master 27
5.6 Offer Master 28
7.1 Login Test Case 39
7.2 Dashboard Test Case 41
7.3 Product Details Test Case 42
7.4 Offer Details Test Case 43

IV
 TABLE OF CONTENTS
ACKNOWLEGEMENT I
ABSTRACT II
LIST OF FIGURES III
LIST OF TABLES IV
TOPIC SUB TITLES PAGE NO.
NO. TOPIC NO.

1 Overview of the Company 1

1.1 History 1
1.2 Different Product/Scope of Work 1
1.3 Capacity of Department 2
1.4 Experience 2
2 Production Management 3
2.1 Work being carried out in Each Department 3
2.1.1 Web Development 3
2.1.2 Mobile Apps 3
2.1.3 Brand Promotions 3
2.2 Technical Specification of Major Equipment 3
2.2.1 App Development 3
2.2.2 Website Development 4
3 Internship Management 5
3.1 Internship Summary 5
3.2 Purpose 5
3.3 Objective/Scope 5
3.4 Internship Planning 5
3.5 Internship Scheduling 6
3.6 Technology and Literature View 6
3.6.1 MYSQL Workbench 6
3.6.2 JavaScript 6
3.6.3 NodeJS 6
4 System Analysis 7
4.1 Study of Current System 7
4.2 Problem & Weakness of Current System 7
4.3 Feasibility Study 7
4.4 Functions of System 8
4.4.1 Customer Use Case 8
4.4.2 Admin Use Case 9
4.5 Data Modelling 10
4.5.1 Admin Class Diagram 11
 4.5.2 Sequence Diagram 12
4.5.3 Activity Diagram 13
4.5.4 Deployment Diagram 14
4.5.5 E-R Diagram 15
4.6 Selection of Hardware & Software & Justification 16
4.6.1 Hardware 16
4.6.2 Software 16
5 System Design 17
5.1 Data Dictionary 17
5.1.1 Customer Master 17
5.1.2 Store Setting Details 18
5.1.3 Store Master 20
5.1.4 Product Master 21
5.1.5 Coupon Master 22
5.1.6 Offer Master 23
5.2 Input/output Interface 24
5.2.1 Sample of forms, reports and interface 24
6 Implementation 25
6.1 Implementation Environments 25
6.2 Program/Modules Specifications 25
6.3 Security Features 25
6.4 Application Layouts 26
7 Testing 30
7.1 Testing Plan 30
7.2 Testing Strategy 30
7.3 Test Cases 32
8 Conclusion and Discussion 37
8.1 Summary of Internship 37
8.2 Dates of Continuous Evolution (CE-I & CE-II) 37
8.3 Future Enhancement 37
References 38
TEAM ID: 344256 OVERVIEW OF THE COMPANY
CHAPTER 1
OVERVIEW OF THE COMPANY
1.1 History:

Founded in 2015, “AthulyaTech” began as a mobile application development firm, has since created a
wide range of apps serving a different interests and industries.
In the process, we have developed deep expertise and a consultative-driven approach to providing end-to-end
enterprise technology solutions.
We work closely with you to ensure you receive the best possible outcomes and return on your branding.
We are dedicated to inside low-cost solutions to various technologies under the following:
• Mobile App
• Web Development
• Software Development
• Brand Promotion
• Database, Design, Programming, and Management
• SEO Expert Services
We have leveraged our deep experience and entrepreneurial history to partner with innovative start-ups,
together creating state of the art digital products and bringing fresh ideas and investment to the mobile space.
Several of our clients and partners have been named among the top “must-watch” digitally disruptive
enterprises.

1.2 Different Products/Scope of Work:

Our commitment to quality, on-time delivery and cost control helps us to retain 85% of clients. If you are
looking for a cost-effective software solution, give us a call and we will be happy to help you bring your
product/service into reality.
We offer a wide range of design and development services that are all delivered using the latest greatest
technologies with a personal experience.
Our goal is to provide our customers the means to effectively present and market themselves online
successfully.
We strategically help build your brand, improve your global web presence, and develop meaningful
relationships with your customers.
We also use our local marketing skills to help hundreds of smaller businesses in a variety of industries.
Dentists, plumbers, veterinarians, dermatologists, and other specialized industries benefit from our dedicated,
professional digital marketing campaigns.

GUJARAT TECHNOLOGICAL UNIVERSITY 1 KJIT

TEAM ID: 344256 OVERVIEW OF THE COMPANY

1.3 Capacity of Department:

Vision: Our vision is to see all our business associates succeed & set themselves apart from others.
Mission: Let’s Grow Your Business defines our mission to elevate all direct and indirect associates including,
customers, their end customers, employees and partners, Growth Together!
1.4 Experience:
Persisting in the market for over 7 years, we have developed a credible reputation amongst the market
facilitators. Our skilled professional has on-hand experience of mobile and web development for more than
years.

GUJARAT TECHNOLOGICAL UNIVERSITY 2 KJIT

TEAM ID: 344256 PRODUCTION MANAGEMENT

CHAPTER 2
PRODUCTION MANAGEMENT

2.1 Work being carried out in Each Department:

In our company, there are mainly four department working like Backend Development, Front-end
Development,Testing Department, Database Designer, and Analysis Management.

2.1.1 Web Development:

• Development With .Net C#
• Development With ANDROID
• Development With Android
• Development With Asp.net
• Development With NodeJS
2.1.2 Mobile Apps:
Cross-Platform Apps: We create advanced dynamic cross-platform apps to give your users great
functionality and accessibility with unmatched UX/UI.
Windows Apps: We develop premium-quality applications for windows. They are highly practical and
give measurable results.
Hybrid Apps: We develop the best hybrid apps for your users. Our teams, with years of experience,
develop unique and ideal hybrid applications with marveling features and smooth-interface.
Native Apps: We create native applications that are platform-specific with the latest technology. Our team
of experts makes it outstanding with a user-friendly interface.
2.1.3 Brand Promotions:
1. Search Engine Optimization
2. Social Media Optimization
3. Pay Per Click
4. Email Marketing
5. Digital Strategy
2.2 Technical Specification of Major Equipment:
2.2.1 App Development:
Our Technical Competency for undertaking application development contracts are listed below:
• Asp.net/ VB.net/ C# Programming/ C++ Programming
• Java/ J2EE / J2ME Programming
• Database (SQL Server, MySQL 5.0 and Oracle)

GUJARAT TECHNOLOGICAL UNIVERSITY 3 KJIT

TEAM ID: 344256 PRODUCTION MANAGEMENT

• Visual Basic Programming

• ASP/ PHP Programming
• Visual C++/ C++ Programming
2.2.2 Website Development:
• Java Script
• Node JS
• HTML/CSS
• Databases
2.2.3 App Development

⚫ Kotlin

⚫ Swift

GUJARAT TECHNOLOGICAL UNIVERSITY 4 KJIT

TEAM ID: 344256 INTERNSHIP MANAGEMENT

CHAPTER 3
INTERNSHIP MANAGEMENT

3.1 Internship Summary:

Completed my internship at “AthulyaTech” Vadodara. The Internship was for duration of about 12 weeks and
it involved a lot of learning all around. My internship is based on Android and Kotlin Language. I have worked
with offline mode to develop my skills; I have been working on a project titled Madira Delivery Application.
3.2 Purpose:
The software is for the automation of Madira Delivery Application. It maintains two levels of users:
• Administration Level
• User Level
The Software Includes:
• Maintaining Customer Details
• Providing customers to Purchase Easily.
• Providing and maintaining all kinds’ benefits of offer.
• Account Confidentiality
• Dynamic Database
• Feedback & Inquiry Feature
• Tracking
• Fast Delivery
3.3 Objective/Scope:
This is an application so it has much scope over the internet. It helps to provide best and reliable services
to clients. It can provide the best offer to the customers and also provide the best delivery experience on the
wine, whiskey, beer and cigarettes etc.
3.4 Internship Planning:
Internship planning is part of project management, which relates to the use of schedules such as charts to
plan and subsequently report progress within the project environment.

Initially, the project scope is defined and the appropriate methods for completing the project are determined.

The duration for the various tasks necessary to complete the work are listed and grouped into a work breakdown
structure.

Project planning is often used to organize different areas of a project, including project plans, workloads and
the management of teams and individuals.

GUJARAT TECHNOLOGICAL UNIVERSITY 5 KJIT

TEAM ID: 344256 INTERNSHIP MANAGEMENT

3.5 Internship Scheduling:

• Project Scheduling is the culmination of a planning activity that is primary component of software
project management.
• When combined with estimation method sand risk analysis, scheduling, establishes a road map for the
project management.
• The task network is used to compute the critical project path, a time line chart and a variety of project
information.

3.6 Technology and Literature View:

The Back-End tool is MYSQL Workbench, and I have developed in Android platform, language used is Kotlin.
3.6.1 Kotlin:
⚫ Kotlin is a fantastic way to write software, whether it’s for phones, desktops, servers, or anything
else that runs code.
⚫ It’s a safe, fast, and interactive programming language that combines the best in modern language
thinking with wisdom from the wider Google engineering culture and the diversecontributions
from its open-source community.
⚫ The compiler is optimized for performance and the language is optimized for development, without
compromising on either.
⚫ Kotlin is friendly to new programmers. It’s an industrial-quality programming language that’s as
expressive and enjoyable as a scripting language
⚫ Writing Kotlin code in a playground lets you experiment with code and see the results immediately,
without the overhead of building and running an app.
3.6.2 Android:
• Android is the world’s most advanced mobile operating system.
• Android 14 provides an abundance of exciting new APIs and capabilities that help you empower
people to do more, more easily.
• Bring widgets to the Lock Screen, take advantage of enhancements in Maps, let people
conveniently complete tasks using Google with new App Shortcuts, make it simpler to share your
content, and so much more.

GUJARAT TECHNOLOGICAL UNIVERSITY 6 KJIT

TEAM ID: 344256 SYSTEM ANALYSIS

CHAPTER 4 SYSTEM ANALYSIS

4.1 Study of Current System:

We selected this model because it’s quite easy to work with to when you are developing uncommitted
project or application then this model is suitable as well as very effective also you can change your prototype
as per customer requirement so we selected prototype model.

4.2 Problem & Weakness of Current System:

Take and advice from some senior level people are always best answer of any volunteer while they stuck
in some problems blink provide their best but sometimes it’s quite difficult to get desirable answer due to false
answer posting myth things on answer etc. plus there are huge possibility to post same answer as well as same
question on any category by user.

4.3 Feasibility Study:

Objective of Feasibility Study:
An important outcome of the preliminary investigation is the determination that the system requested
is feasible. The feasibility study is carried out to examine the likelihood that the system will be useful to the
organization. There are four aspects in the feasibility study namely.

• Operational Feasibility
• Technical Feasibility
• Economic Feasibility
• Schedule Feasibility
Operational Feasibility:

The main purpose of checking Operational Feasibility is to find out whether the system will be
functional after its development and installation or not. The outcomes of the operational feasibility are as
follows:

• Madira Delivery Application provides help for customers and distributor simple to sell and
purchase the liquor.
• So, it’s supposed to improve the working efficiency of customer.
• So, this application is operationally feasible.
Technical Feasibility:
The main purpose of checking Technical Feasibility is to examine whether the current technology is
sufficient for the development of the system. The outcomes of technical feasibility are as follows:
• Madira Delivery Application front-end is Android, iOS, .net and Back-end is MYSQL.

GUJARAT TECHNOLOGICAL UNIVERSITY 7 KJIT

TEAM ID: 344256 SYSTEM ANALYSIS

• The Application developed in NodeJS can run on any of web browser and android or iOS.

GUJARAT TECHNOLOGICAL UNIVERSITY 8 KJIT

TEAM ID: 344256 SYSTEM ANALYSIS

Economic Feasibility:
Economic Feasibility is the most frequently used method for evaluating the effectiveness of a
candidate system. More commonly known as Cost/ Benefit analysis, the procedure is to determine the
benefits and savings that are expected from the candidate system and compare them with costs. If the
benefits outweigh costs, then the decision is made to design and implement the system.

Schedule Feasibility:
This type of the feasibility includes a measure of how reasonable the projected with respect to time
aspect. When developing software, it is difficult to measure such things as software complexity, quality
and to estimate the amount of effort it will take to complete the project.

4.4 Functions of System

4.4.1 Customer Use Case:

[Figure 4.1 Customer Use Case]

GUJARAT TECHNOLOGICAL UNIVERSITY 9 KJIT

TEAM ID: 344256 SYSTEM ANALYSIS

4.4.2 Admin Use Case:

[Figure 4.2 Admin Use Case]

GUJARAT TECHNOLOGICAL UNIVERSITY 10 KJIT

TEAM ID: 344256 SYSTEM ANALYSIS

4.5 Data Modelling:

4.5.1 Class Diagram:

• Admin

[Figure 4.3 Admin Class Diagram]

GUJARAT TECHNOLOGICAL UNIVERSITY 11 KJIT

TEAM ID: 344256 SYSTEM ANALYSIS

4.5.2 Sequence Diagram:

[Figure 4.4 Sequence Diagram]

GUJARAT TECHNOLOGICAL UNIVERSITY 12 KJIT

TEAM ID: 344256 SYSTEM ANALYSIS

4.5.3 Activity Diagram:

• Admin Activity Diagram

[Figure 4.5 Admin Activity Diagram]

GUJARAT TECHNOLOGICAL UNIVERSITY 13 KJIT

TEAM ID: 344256 SYSTEM ANALYSIS

• Customer Activity Diagram

[Figure 4.6 Customer Activity Diagram]

GUJARAT TECHNOLOGICAL UNIVERSITY 14 KJIT

TEAM ID: 344256 SYSTEM ANALYSIS

4.5.4 Deployment Diagram:

[Figure 4.7 Deployment Diagram]

GUJARAT TECHNOLOGICAL UNIVERSITY 15 KJIT

TEAM ID: 344256 SYSTEM ANALYSIS

4.6 Selection of Hardware & Software & Justification

4.6.1 Hardware:
RAM 4 GB

Device Android Phone, iOS Phone, Windows

4.6.2 Software:
Operating System Android, iOS, Windows

Application Software Installation Required

Website Internet Connectivity Required

GUJARAT TECHNOLOGICAL UNIVERSITY 16 KJIT

TEAM ID: 344256 SYSTEM DESIGN

CHAPTER 5
SYSTEM DESIGN

5.1 Data Dictionary:

5.1.1 Customer Master
Sr. No Field Name Data Type Size Constraint Key Description

1. CustomerID Bigint 20 Not Null AI, PK Contain information of CustomerID

2. Customer No Bigint 20 Not Null - Contain information of Customer No

3. First Name Varchar 50 Not Null - Contain information of First Name

4. Last Name Varchar 50 Not Null - Contain information of Last Name

5. Phone Varchar 15 Not Null - Contain information of Phone

6. Email Varchar 50 Not Null - Contain information of email

7. StoreID Varchar 50 Not Null - Contain information of StoreID

8. Username Varchar 25 Not Null - Contain information of Username

9. Password Varchar 50 Not Null - Contain information of Password

10. Create Date datetime Not Null - Contain information of Create Date

11. Verification Code Bigint 20 Not Null - Contain information of Verification Code

12. Temporary Password char 1 Not Null - Contain information of Temporary Password

13. DOB date 45 Not Null - Contain information of DOB

14. Status int 11 Not Null - Contain information of Status

15. Country varchar 45 Not Null - Contain information of Country

16. Device Token varchar 50 Not Null - Contain information of Device Token

17. Notification status Int 2 Not Null - Contain information of Notification status

18. Device Type varchar 50 Not Null - Contain information of Device Type

[Table 5.1 Customer Master]

GUJARAT TECHNOLOGICAL UNIVERSITY 17 KJIT

TEAM ID: 344256 SYSTEM DESIGN

5.1.2 Store Setting Details

Sr. No Field Name Data Type Size Constraint Key Description

1. StoreDetailsID Bigint 20 Not Null AI, PK Contain information of Product Store Id

2. StoreID Int 11 Not Null Foreign Contain information of Store Id

3. Delivery_charge_constatnt Decimal 18,2 Not Null - Contain information of

Delivery_charge_constatnt

4. Delivery_charge_percent Decimal 18,2 Not Null - Contain information of

Delivery_charge_percent

5. Delivery_miles_allowed Int 11 Not Null - Contain information of Delivery_miles_allowed

6. Status Int 11 Not Null - Contain information of Status

7. Ncust_discount_percent Decimal 18,2 Not Null - Contain information of

Ncust_discount_percent

8. Ncust_discount_constant Decimal 18,2 Not Null - Contain information of

Ncust_discount_constant

9. Ncust_min_order_amount Decimal 18,2 Not Null - Contain information of

Ncust_min_order_amount

10. Cs_phone_number Varchar 25 Not Null - Contain information of Cs_phone_number

11. Cs_email_address Varchar 25 Not Null - Contain information of Item cs

12. Cs_contact_name Varchar 50 Not Null - Contain information of Cs_contact_name

13. Store Order Terms Varchar 100 Not Null - Contain information of Store Order Terms

14. smtp_user_name Varchar 50 Not Null - Contain information of smtp_user_name

15. smtp_password Varchar 20 Not Null - Contain information of smtp_password

16. smtp_server_name Varchar 50 Not Null - Contain information of smtp_server_name

17. smtp_server_port Varchar 50 Not Null - Contain information of smtp_server_port

18. smtp_email_address Varchar 50 Not Null - Contain information of smtp_email_address

19. delivey_allowed_time_from Datetime Not Null - Contain information of

delivey_allowed_time_from

20. delivey_allowed_time_to Datetime Not Null - Contain information of

delivey_allowed_time_to

21. delivery_setup_minutes Decimal 18,2 Not Null - Contain information of delivery_setup_minutes

22. Is CodAllowed Int 11 Not Null - Contain information of Is CodAllowed

23. Is SelfPickupAllowed Varchar 45 Not Null - Contain information of Is SelfPickupAllowed

GUJARAT TECHNOLOGICAL UNIVERSITY 18 KJIT

TEAM ID: 344256 SYSTEM DESIGN
24. Is CoupenAllowed Int 11 Not Null - Contain information of Is CoupenAllowed

25. IsVertualshow Int 11 Not Null - Contain Information of IsVertualshow

26. PaymentGetwayKey Varchar 50 Not Null - Contain information of PaymentGetwayKey

27. IsNotificationAllowed Int 11 Not Null AI, PK Contain information of IsNotificationAllowed

28. purchase_limit Decimal 18,2 Not Null Foreign Contain information of purchase_limit

29. single_item_quantity_limit Int 11 Not Null - Contain information of

single_item_quantity_limit

30. total_item_quantity_limit Int 11 Not Null - Contain information of

total_item_quantity_limit

31. Is_For_Next Day Bit 1 Not Null - Contain information of Is_For_Next Day

32. PaymentGatewayUsername VarChar 45 Not Null - Contain information of

PaymentGatewayUsername

33. PaymentGatewayPassword Varchar 45 Not Null - Contain information of

PaymentGatewayPassword

34. MinutesForItemUpdate Varchar 45 Not Null - Contain information of MinutesForItemUpdate

35. selfpicup_service_charge Decimal 18,2 Not Null - Contain information of

selfpicup_service_charge

36. Is_Recipe_Allowed Int 11 Not Null - Contain information of Is_Recipe_Allowed

37. Is GiftCardAllowed Int 1 Not Null - Contain information of Is GiftCardAllowed

38. TERMINAL_NBR Varchar 15 Not Null - Contain information of TERMINAL_NBR

39. DBA_NBR Varchar 15 Not Null - Contain information of DBA_NBR

40. CUST_NBR Varchar 15 Not Null - Contain information of CUST_NBR

41. MERCH_NBR Varchar 15 Not Null - Contain information of MERCH_NBR

42. MAC_ADDRESS Varchar 50 Not Null - Contain information of MAC_ADDRESS

43. PaymentGatewayType Varchar 45 Not Null - Contain information of PaymentGatewayType

44. UTC_From_Time Varchar 50 Not Null - Contain information of UTC FROM TIME

45. UTC_To_TIme Varchar 50 Not Null - Contain information of UTC TO TIME

46. Time Zone Varchar 50 Not Null - Contain information of Time Zone

[Table 5.2 Store Setting Details]

GUJARAT TECHNOLOGICAL UNIVERSITY 19 KJIT

TEAM ID: 344256 SYSTEM DESIGN

5.1.3 Store Master:

Sr. No Field Name Data Type Size Constraint Key Description

1. StoreID Bigint 20 Not Null AI, PK Contain information of Store Id

2. POSID Bigint 20 Not Null Foreign Contain information of POS Id

3. Store Name Varchar 50 Not Null - Contain information of Store Name

4. Address1 Varchar 60 Not Null - Contain information of Address 1

5. Address2 Varchar 60 Not Null - Contain information of Address 2

6. City Varchar 30 Not Null - Contain information of City

7. StateID Bigint 20 Not Null - Contain information of State Id

8. ZipCode Varchar 10 Not Null - Contain information of Zip Code

9. Status Int 11 Not Null - Contain information of Status

10. CreateDate Datetime Not Null - Contain information of Create Date

11. CreateBy Int 11 Not Null - Contain information of Create By

12. CreateIP Varchar 50 Not Null - Contain information of Create IP

13. ModifyDate Datetime Not Null - Contain information of Modify Date

14. ModifyBy Int 11 Not Null - Contain information of Modify By

15. ModifyIP Varchar 50 Not Null - Contain information of Modify IP

16. Latitude Double Not Null - Contain information of Laptitude

17. Longitude Double Not Null - Contain information of Longitude

18. EmailID Varchar 45 Not Null - Contain information of Email ID

19. LoginID Varchar 45 Not Null - Contain information of Is Login ID

20. Password Varchar 45 Not Null - Contain information of Password

21. MobileNumber Varchar 45 Not Null - Contain information of Mobile Number

22. StoreNo Varchar 45 Not Null - Contain information of Store Number

23. Total_Rating Double Not Null - Contain information of Total Rating

24. No_Of_Rating Int 11 Not Null - Contain information of No of Rsting

25. BlkCustList Varchar 50 Not Null - Contain Information of BlkCust List

26. AlertMobileNo Varchar 20 Not Null - Contain information of Alert Mobile No

[Table 5.3 Store Master]

GUJARAT TECHNOLOGICAL UNIVERSITY 20 KJIT

TEAM ID: 344256 SYSTEM DESIGN

5.1.4 Product Master

Sr. No Field Name Data Type Size Constraint Key Description

1. ProductStoreId Bigint 11 Not Null AI, PK Contain information of Product Store Id

2. StoreID Bigint 20 Not Null Foreign Contain information of Store Id

3. CategoryID Bigint 20 Not Null Foreign Contain information of Category Id

4. BrandID Bigint 20 Not Null - Contain information of Brand Id

5. ProductID Bigint 20 Not Null - Contain information of Product Id

6. Upc_Code VarChar 50 Not Null - Contain information of Upc Code

7. AppID Int 11 Not Null - Contain information of App Id

8. Product_store_no Bigint 20 Not Null - Contain information of Product Store No

9. RegularPrice Decimal 18,2 Not Null - Contain information of Regular Price

10. SalePrice Decimal 18,2 Not Null - Contain information of Sale Price

11. Item_Qty Bigint 20 Not Null - Contain information of Item Quantity

12. Display_Order Bigint 20 Not Null - Contain information of Display Order

13. Tax_Amount Decimal 18,2 Not Null - Contain information of Tax Amount

14. Deposit_Amount Decimal 18,2 Not Null - Contain information of Deposit Amount

15. Status Int 11 Not Null - Contain information of Status

16. Discount Decimal 18,2 Not Null - Contain information of Discount

17. Size Varchar 45 Not Null - Contain information of Size

18. NonInventory Int 11 Not Null - Contain information of non-inventory

19. Is_VirtualItem Int 11 Not Null - Contain information of Is Virtual Item

20. VirtualProductName Varchar 45 Not Null - Contain information of Virtual Product Name

21. Is_Top_Pic Int 11 Not Null - Contain information of Top Pic

22. Is_In_Offers Int 11 Not Null - Contain information of Offers

23. PurQtyLimit Int 11 Not Null - Contain information of Pur Qty Limit

24. Is_once_inday Int 11 Not Null - Contain information of Is taking once in a day

25. Is_once_inLife Int 11 Not Null - Contain Information of once in a life

26. Is_Once_On_Address Int 11 Not Null - Contain information of Once on Address

[Table 5.4 Product Master]

GUJARAT TECHNOLOGICAL UNIVERSITY 21 KJIT
TEAM ID: 344256 SYSTEM DESIGN

5.1.5 Coupon Master

Sr. No Field Name Data Type Size Constraint Key Description

1. CouponID Bigint 20 Not Null AI, PK Contain information of Product Coupon Id

2. StoreID Int 11 Not Null Foreign Contain information of Store Id

3. AppID Int 11 Not Null - Contain information of App Id

4. Coupon_No VarChar 50 Not Null - Contain information of Coupon No

5. Coupon_Title VarChar 20 Not Null - Contain information of Coupon Title

6. Discount_Flat Decimal 18,2 Not Null - Contain information of Discount Flat

7. Discount_Percent Decimal 18,2 Not Null - Contain information of Discount Percent

8. Use_Multiple Char 1 Not Null - Contain information of Use Multiple

9. Exp_Date_From DateTime Not Null - Contain information of Exp Date From

10. Exp_Date_To Datetime Contain information of Exp Date To

11. Min_Order_Amount Decimal 18,2 Contain information of Minimum Order

Amount

12. Status Int 11 Contain information of Status

[Table 5.5 Coupon Master]

GUJARAT TECHNOLOGICAL UNIVERSITY 22 KJIT

TEAM ID: 344256 SYSTEM DESIGN

5.1.6 Offer Master

Sr. No Field Name Data Type Size Constraint Key Description

1. Offered Bigint 20 Not Null AI, PK Contain information of Product Offer Id

2. StoreID Int 11 Not Null Foreign Contain information of Store Id

3. Templated Int 11 Not Null Foreign Contain information of Template Id

4. Offer_No VarChar 50 Not Null - Contain information of Offer No

5. Offer_Title VarChar 50 Not Null - Contain information of Offer Title

6. Discount_Flat Decimal 18,2 Not Null - Contain information of Discount Flat

7. Discount_Percentage Decimal 18,2 Not Null - Contain information of Discount Percentage

8. Use_Multiple Char 1 Not Null - Contain information of Use_Multiple

9. Exp_Date_From Datetime Not Null - Contain information of Exp_Date_From

10. Exp_Date_To Datetime Not Null - Contain information of Exp_Date_To

11. Min_Order_Amount Decimal 18,2 Not Null - Contain information of Min Order Amount

12. Status Int 11 Not Null - Contain information of Status

13. Max_Order Int 11 Not Null - Contain information of Max Order

14. Max_Discount Decimal 18,2 Not Null - Contain information of Max Discount

15. Is_Birthday_Offer Int 11 Not Null - Contain information of Birthday Offer

[Table 5.6 Offer Master]

GUJARAT TECHNOLOGICAL UNIVERSITY 23 KJIT

TEAM ID: 344256 SYSTEM DESIGN

5.2 Input/output Interface:

5.2.1 Sample of forms, reports and interface
5.2.1.1 Input Design
Input Design is a part of overall system design which requires very care attention. If an error occurs in the
input data, then the result of that error may lead to unwanted problems. Errors committed by users can be
controlled by a proper input design. Normally the data will be keyed into the system through the standard
input device like keyboard. In such case, a validation program should be there to check the validity of the
data.

5.2.1.2 Output Design

The output is the most important direct source of information to the user. Intelligent output Design will
improve the systems relationship with the user and also helps in decision making, once the output
requirement is determined, the system designer can decide, what to include in the system and how to
structure it, so that the required output can be produced. Hence the output requirements are to bedetermined
before going to actual system design.

GUJARAT TECHNOLOGICAL UNIVERSITY 24 KJIT

TEAM ID: 344256 IMPLEMENTATION

CHAPTER 6
IMPLEMENTATION

6.1 Implementation Environments:

During the time line of the project, we applied the Prototype process model concept of the softwareengineering
approach in that we set priorities for that requirement specification and followed that as per our time line chart.

• Single VS Multiuser:
As the Secure application we going to be developed ideal mobile application, at the time of the
implementation it should be kept in mind that the system will be used concurrently. So, the development
approach would remain for the concurrent use.

• GUI VS Non-GUI:
The system is completely GUI. This is because today customer feels comfortable while working with pdf
or web view. The user should feel comfortable while working with the system.

6.2 Program/Modules Specifications:

In the above two modules we were just retrieving the data from database which already store JSON format
in the form of map. Now we need to query that map. So as per the type of query fired, we could be able to get the
result using query builder. Thus, in order to get the detail and display of the desired location we make use of
query builder.

6.3 Security Features:

Any infrastructure/application development for the web should be there to the Security Policy detailed by the
organization. It is assumed that Organization has a detailed Security policy for protecting its resources and
information.
Security Layers:
1. Application Security
2. Database Security
3. Network - Data Transfer Security
4. External Security: Firewall and Antivirus

GUJARAT TECHNOLOGICAL UNIVERSITY 25 KJIT

TEAM ID: 344256 IMPLEMENTATION

6.4 Application Layouts:

• Delivery boy signup and login:

[Figure 6.1 Delivery boy signup and login]

GUJARAT TECHNOLOGICAL UNIVERSITY 26 KJIT

TEAM ID: 344256 IMPLEMENTATION

• Delivery Details and Payment page:

[Figure 6.2 Delivery Details and Payment page]

GUJARAT TECHNOLOGICAL UNIVERSITY 27 KJIT

TEAM ID: 344256 IMPLEMENTATION

• Track and order:

[Figure 6.3 Track and Order]

GUJARAT TECHNOLOGICAL UNIVERSITY 28 KJIT

TEAM ID: 344256 IMPLEMENTATION

• Accept the order from the application:

[Figure6.4 Accept Order]

GUJARAT TECHNOLOGICAL UNIVERSITY 29 KJIT

TEAM ID: 344256 TESTING

CHAPTER 7
TESTING

7.1 Testing Plan:

The aim of testing process is to identify all defects existing in software product. Testing a program
consists of subjecting the program to as test inputs and observing if the program behaves expectedly or not.
If the program fails by any means or gives unexpected results than the failure occurred are noted for later
debugging and corrections.

The aim of the testing process is to identify all defects existing in software Product. However, for most
practical systems, even after satisfactorily carrying out the testing phase, it is not possible to guarantee that the
software is error free.

This is because of the fact that the input data domain of most software products is very large. It is not practical
to test the software exhaustively with respect to each value that the input data may assume. Even with this
practical limitation of the testing process, the importance of testing should not be underestimated.

It must be remembered that testing does expose many defects existing in a Software product. Thus, testing
provides a practical way of reducing defects in a System and increasing the users’ confidence in a developed
system.

7.2 Testing Strategy:

7.2.1 System Test
The system test will be focus on the behavior of the system. User scenario Android will be executed
against the system as well as screen mapping and error message testing. Overall, the system tests will be
testing the integrated system and verify that it meets the requirements defined in the requirements
document.

7.2.2 Performance Test

Performance test will be conducted to ensure that the system’s response times meet. The user
expectation and do not exceed the specified performance criteria. During these tests, response times will
be measured under heavy stress and/or volume.

7.2.3 Security Test

Security test will be determined how secure the system is. The tests will verify that unauthorized
user access to confidential data is prevented.

7.2.4 Automated Test

GUJARAT TECHNOLOGICAL UNIVERSITY 30 KJIT

TEAM ID: 344256 TESTING

A suite of automated tests will be developed to test the basic functionality of the system and
perform regression testing on areas of the system that previously had critical/major defects. The tool will
also assist us by executing user scenario there by emulating several users.

7.2.5 Stress and Volume Test

We will subject the payroll system to high input condition and high volume of data during the pick
times. The system will be stress tested using twice the number of expected users.

7.2.6 Recovery Test

Recovery test will force the system to fail in a various way and verify the recovery is properly
performed. It is vitally important that all payroll data is recovered after a system failure and no corruption
of the data occurred.

7.2.7 Documentation Test

Test will be conducted to check the accuracy of the user documentation. These tests will ensure
that no features are missing, and the contents can be easily understood.

[Figure 7.1 Test Strategies]

GUJARAT TECHNOLOGICAL UNIVERSITY 31 KJIT

TEAM ID: 344256 TESTING

7.3 Test Cases:

• Login Test Case:

[Table 7.1 Login Test Case]

GUJARAT TECHNOLOGICAL UNIVERSITY 32 KJIT

TEAM ID: 344256 TESTING

[Figure 7.2 Login Test Case]

GUJARAT TECHNOLOGICAL UNIVERSITY 33 KJIT

TEAM ID: 344256 TESTING

• Dashboard Testing:

[Table 7.2 Dashboard Test Case]

GUJARAT TECHNOLOGICAL UNIVERSITY 34 KJIT

TEAM ID: 344256 TESTING

• Product Details Test Case:

[Table 7.3 Product Details Test Case]

GUJARAT TECHNOLOGICAL UNIVERSITY 35 KJIT

TEAM ID: 344256 TESTING

• Offer Details Test Case:

[Table 7.4 Offer Details Test Case]

GUJARAT TECHNOLOGICAL UNIVERSITY 36 KJIT

TEAM ID: 344256 CONCLUSION AND DISCUSSION

CHAPTER 8
CONCLUSION AND DISCUSSION

8.1 Summary of Internship:

Android is a mobile operating system developed by Google Inc, while Kotlin is a programming language
used to create applications for Android. MySQL is a popular open-source relational database management
systemused for storing and managing data, while Postman is a collaboration platform for developing and
testing APIs.

In Android app development, developers might use Kotlin to build the app's functionality, while using MySQL
to store and manage data used in the app. Postman can be used to test APIs, ensuring that the app can effectively
communicate with the backend systems that use MySQL for data storage. Overall, the combination of Android,
Kotlin, MySQL, and Postman can provide a comprehensive platform for developing robust and efficient
mobile applications

The “Madira Delivery Application” project -involved creating a mobile application related to alcohol, such
as an e-commerce platform or a social media platform. My role in the project included developing and
implementing various features using the above technologies, such as user authentication and authorization,
database integration, API integration, and testing using Postman.

8.2 Dates of Continuous Evolution (CE-I & CE-II):

8.2.1 Review – I: 7/03/2023

8.2.2 Review – II:

8.3 Future Enhancement:

• Integration of a Payment Gateway
• Implementation of User Reviews
• Integration of social media
• Implementation of Machine Learning
• Implementation of Data Visualization

GUJARAT TECHNOLOGICAL UNIVERSITY 37 KJIT

TEAM ID: 344256 CONCLUSION AND DISCUSSION

References
1. Kotlin Documentation: https://kotlinlang.org/docs/home.html

2. Android documentation: https://developer.android.com/docs

3. Stack Overflow: https://stackoverflow.com/

GUJARAT TECHNOLOGICAL UNIVERSITY 38 KJIT