Topic: BusinessE-Commerce

Last updated: April 15, 2019


1 HUSENA LOKHANDWALA 1406401070042 SHWETA KHATRA 1406401070063 PALAK PATEL 140640107023 VIMAL BHATT SOHIL SHAH (FACULTY GUIDE) (HEAD OF DEPARTMENT) ACADAMIC YEAR (2017-2018)K.J. Institute of Engineering & TechnologyComputer Engineering(2017-2018)CERTIFICATEThis is certified that HUSENA LOKHANDWALA (140640107004), SHWETA KHATRA (140640107006), PALAK PATEL (140640107023) has successfully completed the project work in INTERIO the course of PROJECT Semester – 8 during the term 2017-2018 She has been very much disciplined, hardworking and has submitted all our report on the project she has undergone.Project Guide Head of DepartmentVIMAL BHATT Prof. SOHIL SHAH Asst.

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!

order now

Prof Computer DepartmentComputer Department K.J.I.T SavliK.J.I.T Savli About the OrganizationINTERIOCompany Name: – KS TechnologiesWebsite: – http://www.”KS Technologies”, An ISO 9001:2015 certified software & Web DevelopmentCompany in field of information Technology. The company primarily engaged with Software & Website Designing & Development from last 3 years. The organization use latest technologies like .NET, C#.NET, ASP .NET, PHP, ORACLE, MYSQL, SQL server, JAVA & ANDROID etc.At KS Technologies with Technical proficiency and expertise, we cohesively integrate graphic design with web page layout with interactive programming, with database driven content, to plan, build and deploy e-business and to emerge as one of the top IT service providers.

We at KS technologies believe in teamwork with every new day the quest for accruing new competencies continues. Forever searching, experimenting, innovating, learning, moving ahead with our sincere efforts and dedication, shaping the future, and challenging our competencies to create new opportunities is a never-ending process in the company. INDEXChapter Title Page No ACKNOWLEDGEMENT 7 ABSTRACT 81 Introduction1.1 System Profile 9 1.2 Project Summary 9 1.3 Aim and Objective of project 1.4 Function Specification 1.4.

1 Description of Project1.5 Plan of Project Work1.6 Tools/ Technology used 10 101112152 Design: Analysis, Design Methodology and Implementation Strategy 2.1 CANVAS 2.

1.1 AEIOU Canvas 2.1.2 Empathy Canvas 2.1.3 Ideation Canvas 2.1.

4 Product Development Canvas 2.1.5 Business Model Canvas2.2 Non-Functional Requirement2.3 Literature review2.4 System Analysis & Design 2.

4.1 Current System Analysis 2.4.2 Feasibility Study 2.4.

3 Design (UML Diagrams) 17171818191920202222243 Implementation3.1 Screenshots of Application3.2 Screenshots of Admin Panel 3.3 Testing and Verification3.4 Data Dictionary 354042434 PPR & PDE 455? Summary & Conclusion4.1 Scope of Project4.2 Future Enhancement4.

3 ConclusionBIBLIOGRAPHY 58585859ACKNOWLEDGEMENTMany people have contributed to the success of this. Although a single sentence hardly suffices, we would like to thank Almighty God for blessing us with her grace. We extend my sincere and heartfelt thanks to MR. SOHIL SHAH (Head of Computer Department) for providing us the right ambience for carrying out this work. We are profoundly indebted to my project guide MR.

VIMAL BHATT (Asst. Prof. of CE Department.

) for innumerable acts of timely advice, encouragement and Invaluable contribution in making our project more presentable and without whom this project would have not been completed, we sincerely express our gratitude to him. We express our immense pleasure and thankfulness to all the teachers and staff of The Department of Computer Engineering, K.J Institute of Engineering and Tech for their cooperation and support. Last but not the least, we thank all others, and especially our classmates who in one way or another helped us in the successful completion of this work.HUSENA LOKHANDWALA (140640107004) SHWETA KHATRA (140640107006)PALAK PATEL (140640107023) ABSTRACTWe present an interactive furniture layout system that assist users by suggesting furniture arrangements that are based on interior design guidelines. Our system incorporates the layout guidelines as terms in a density.

INTERIO is android based app to try and buy furniture, fittings and furnishings. The user of app can select the product and check it “How the product will look in room / office etc.” Using live mirror inside app. The application gives latest product catalogue with different categories. These products are available with competitive prices. User can check the product details within the app. User can also check the product in virtual mirror “How it looks?” if it is purchased. The mirror facility gives a user a virtual demonstration of product and place.

There are various payment options like Cash on Delivery (COD), online payment using payment gateway etc. The user can also move the location take snap of it before buying. The app gives total dynamic experience for buying furniture and furnishings to the clients. CHAPTER 1: INTRODUCTION1.1 System Profile:? Project Name: INTERIO? Operating System: Windows 7 OR Higher Version? Front End: Android, .Net? Back End: MY SQL, SQLite? Android Version: Kit Kat 4.4? Institute: K.J.

Institute of Engineering & Tech? Project Guide: Mr Vimal Bhatt? Developed By: Husena LokhandwalaShweta KhatraPalak Patel1.2 Project Summary:? INTERIO is android based app to try and buy furniture, fittings and furnishings. ? The user of app can select the product and check it “How the product will look in room / office etc.” using live mirror inside app.

? The application gives latest product catalogue with different categories. ? These products are available with competitive prices. User can check the product details within the app. ? User can also check the product in virtual mirror “How it looks?” if it is purchased. ? The mirror facility gives a user a virtual demonstration of product and place.

1.3 Aim and objectives of the Project:? Virtual demonstration of product in mirror.? Dynamic experience of buying.? Provides layout guidelines.

? Checks the product details.? Comparison of products based on prices, material etc.? Online buying with payment facility.1.4 Function Specification: Modules that will be there in the projects are:? Admin Module:- Admin Can Login.- Admin can Add, Update and delete the Category- Admin can Add, Update and delete the Product- Admin can Add, Update and delete the Product details- Admin can handle the details of user- Admin can check order from different user- Show Customer Detail.- Show Order Detail.- Show Payment Detail.

– Show Report? Registered User Module:- Users can register.- User can Login.- User can Check various category.- User can add the production the wish list- User can make the Order.

– User can give Payment by COD Or E-Wallet.? Visitors Module:- Visitor can search furnisher Category.- Visitor can order and give the payment by E-Wallet.

1.4.1 Description of the Project:? Everybody feels that his/her home, always looks in world. There are so best many products through which we can improve our home furnishings.? “INTERIO” app targets the facility to buy latest product like sofas, chairs, study & Laptop tables etc. To improve the look of our home.

? The app gives you latest products under different categories with assembling facility.? Customer can choose from thousands of products and make order.? The app has Admin, customer/user? Admin has responsible for various category management? Customer can look for various product try them into MIRROR and then order them? The virtual Mirror facility gives you virtual tours for how the product will look alike at your place before your order it.? Customer can also check for various colour combination, size and brand filtrations.? Customer can make online payment/cash on delivery (COD) after confirming order.? Customer can also cancel/update orders which are given earlier within 24 Hrs.? Customer can post feedback/reviews for those products 1.

5 Plan of Project Work: Requirement Analysis: Functional Requirement:? USER CLASS 1: AdminFR1 : LoginInput : Enter correct Username and PasswordOutput : Login Successfully. FR2InputOutput : Enter Category: Enter the cat_id, cat_name etc.: Category Details FR3InputOutput : Update Category Details: Change the Category Details: Category Successfully Updated. FR4InputOutput : Delete Category Details: Click on the delete button of Category Details: Category Details Successfully Delete FR5InputOutput : Enter Product: Enter pro_id, and pro_name etc.: Product Details display. FR6InputOutput : Update Product Details: Change Product Details: Product Successfully Updated.

FR7InputOutput : Delete Product: Delete Product Details: Product Details Successfully Deleted FR8InputOutput : Enter Company: Enter company_id, and company_name etc…

: Company Details display. FR9InputOutput : Update Company Details: Change Company Details: Company Successfully Updated. FR10: Delete CompanyInput: Delete Company DetailsOutput: Company Details Successfully Deleted? USER CLASS 2: Customer/user FR1InputOutput : Login: Enter correct Username and Password: User Login Successfully. FR2InputOutput : Update User Details: Change the User Details: User Details Successfully Update 1.6 Tools/Technology Used: List of hardware and software which is used to develop1. Hardware• Processor: I3• RAM: 4GB• HDD: 500 GB2.

Software• Microsoft Word, PowerPoint, Dream viewer• Eclipse, Android Studio• MySQL• Microsoft Visio 2013Front End:Android:Android is an open source and Linux-based Operating System for mobile devices such as smartphones and tablet computers. Android was developed by the Open Handset Alliance, led by Google, and other companies.Android has a dictionary meaning of being a human that resembles automation. The true character of its name is it’s the Google created software stack for creating comprehensive Mobile Applications and Software to realize the full potential of one’s Mobile handset and its possibilities.

Android is a comprehensive software stack of mobile devices that includes an operating system, middleware and key application. This rich source of software bunch is used in Mobile Technology through its innovation module of The Android Software Development Kit (SDK). Android offers a unified approach to application development for mobile devices which means developers need only develop for Android, and their applications should be able to run on different devices powered by Android.

The first beta version of the Android Software Development Kit (SDK) was released by Google in 2007 where as the first commercial version, Android 1.0, was released in September 2008.Back End:MySQLMySQL is currently the most popular open source database server in existence.On top of that, it is very commonly used in conjunction with .net to create powerful and dynamic server-side applications. CHAPTER 2: Design: Analysis, Design Methodology and Implementation2.1 CANVAS:? AEIOU CANVAS: ? EMPATHY MAPPING CANVAS: ? IDEATION CANVAS: ? PRODUCT DEVELOPMENT CANVAS: ? BUSINESS MODEL CANVAS: 2.2 Non-functional Requirement? SecurityThe system uses SSL (secured socket layer) in all transactions that include any confidential customer information.

The system must automatically log out all customers after a period of inactivity.? ReliabilityThe system provides storage of all databases on redundant computers with automatic switchover. The reliability of the overall program depends on the reliability of the separate components. The main pillar of reliability of the system is the backup of the database which is continuously maintained and updated to reflect the most recent changes.? AvailabilityThe system should be available at all times, meaning the user can access it using a web browser, only restricted by the down time of the server on which the system runs. In case of a of a hardware failure or database corruption, a replacement page will be shown.

Also in case of a hardware failure or database corruption, backups of the database should be retrieved From the server and saved by the administrator. Then the service will be restarted. It means 24 X 7 availability.? MaintainabilityA commercial database is used for maintaining the database and the application server takes care of the site. In case of a failure, a re-initialization of the program will be done.

Also, the software design is being done with modularity in mind so that maintainability can be done efficiently.2.3 Literature Review:? The main function of every application is to give latest data. Review of this survey is help to recognize the basic idea of our system. Using this system user can save their important time. Our main aim is to provide the user-friendly environment for giving all real time latest data to the admin of an organization (Society). 2.4 System Analysis and Design:2.

4.1 Current System Analysis:In day to day life, we will need to buy lots of goods or products from a shop. It may be food items, electronic items, house hold items or furniture etc. Now days, it is really hard to get some time to go out and get them by ourselves due to busy life style or lots of works. In order to solve this, E-Commerce websites have been started.

Using this application, we can buy furniture products online just by visiting the application and ordering the item online by making payments online.This existing system of buying furniture has several disadvantages. It requires lots of time to travel to the particular shop to buy the furniture.

Since everyone is leading busy life now days, time means a lot to everyone. Also there are expenses for travelling from house to shop. More over the shop from where we would like to buy something may not be open 24*7*365. Hence we have to adjust our time with the shopkeeper’s time or vendor’s time.In order to overcome these, we have e-commerce solution, i.e. one place where we can get all required furniture products online. The proposed system helps in building an application to buy or sell furniture products online using internet connection.

Purchasing it online, user can choose different furniture products based on categories, online payments, delivery services and also try it virtually using virtual mirror concept hence covering the disadvantages of the existing system and making the buying easier and helping the vendors to reach wider market.2.4.2 Feasibility Study: Technical issues were also raised during the feasibility study. It has been observed that technical knowhow is available in penalty and it is easy accessible to the organization. The requirement required for the proposed system is also easy available and it has the technical capacity to hold the volume of the data required for the new system.

The system can also be expanded if the need arises. There are technical guarantee of accuracy, reliability and ease of access of data, and data security. Preliminary investigation examine the project feasibility, the system will be useful to the organization. These tests are as follow:1.

Technical Feasibility: ? Technical Feasibility determines whether the work for the project be done with the present equipment, current procedure, existing software’s technology and available personal?? It happens that after a system is prepared a new technology arises and the user wants the system based on that technology. Thus it is important to check the system to be technically feasible. ? Here the system Curative application it needs big storage for dictionary of address, diseases detail, hospital detail, medical store detail, comments, websites, user profile etc. Also require high speed operation for user friendly application output.2.

Economic Feasibility:? Economic feasibility looks at the financial aspects of the project. Economic feasibility concerns with the returns from the investments in project. ? In this system we are using the necessary hardware and software requires for the system and there is no economic problem to purchase. 3.

Behavioural Feasibility:? Behavioural feasibility defines the user response to the system. It is important to concern with user who is dealing with the system. ? In this our system is usable by any of the people who is aware or not with technical programming even if he/she can use our system. ? Our system is user friendly and also we provide easy navigation, attractive look, with useful guidance with the processes.

4. Implementation Feasibility:? The Implementation feasibility deals with the study whether the service, which is being developed will run in the environment available with us, will the management of the organization approve the system? ? This service can run in any environment with one constraint that there is internet connection for the site to be viewed. It does not cause any harm to the running system.2.4.3 Design:? Context Level Diagram:Admin User INTERIO Login Sign Up, Login Manage Supplier Search, Buy a Product, Make order Get User Details Get Product ? Admin Side: ? User Side: ? Use case Diagrams:Admin: User: ? Sequence Diagram: ? State Diagram:Admin: 8 User: ? Activity Diagram: Admin: User: ? Class Diagram: Supplier Registration -S_id : int -U_id : int -S_name : string -U_name : string -Address : string -Password : string -Contact_no : string -Gender : string -Email_id : string -Location : string -Email_id : string 1..1 Carpainter -City : string -Password : string -Contact_no : int -Cat_id : string +Register() 1.

.* -Cat_name : string +login() +Register() -Contact_no : string -Email_id : string 1..* 1..* 1.

.1 -Address : string -City : string 1..* -Pincode : string +Register() Product +login() -Pro_id : string Order -Pro_name : string -Pro_discription : string Category -Order_id : string -Order_date : string -Cat_id : string -Cat_id : string -Cust_id : string – -Cat_type : string -Order_amt : string Order_detail -Pro_type : string * -Cat_img : string -Name : string -Retail_Price : string -Onwords : string -Orderdetail_id : string -Email_id : string -Offer_Price : string 1 -Title : string -Order_id : string -Address : string -Discount : string +Add_category() -City : string 1 -Pro_id : int -height : string +Add_image() -Qty : decimal -Contact_no : string -Width : string 0..* +Get_category() -Discount_status : string -Price : int -Depth : string -Amount : string -Pay_mode : string -Seating_Hight : string Company +Add_order() -Color : string -Assembly_type : string -Other_details : string -Company_id : int -Warranty : string +Check_order() +Add_orderdetail() -Company_name : string +Placeorder() 1.

.* -Primary_Material : string +Cancel_order() -Password : string -Room_type : string +Return_order() -Email_id : string -Pro_img : string -Address : string +Add_product() 1 -City : string +Add_image() -Pincode : string +Browse_product() -Contact_no : string Feedback Notification -F_id : string +Add_Company() 1..* -F_date : string -N_id -Name : string -N_date User -F_detail : string -N_detail -Cust_id : string +Delete_feedback() +Add_Notification() -Cust_name : string 1..1 +Check_Notification() 1..

* -Address : int 1..* -City : string 1.

.* -Contact_no : string Admin -Email_id : string -Adminname : string -Password : string Login -Password : string -Cpassword : string -Email_id : string 1..1 +Login() 1..1 +Register() -Password : string +Add_admin() +Add_detail() +Register() +Get_login() 1.

.1 1..1 1..1 +Forgot_pwd() +Change_pwd() 1.

.1 1..* 1.

.* Payment Assembly 1..1 Primary_material -Assembly_id : string -Primary_Material_id : string -Pay_id : string -Assembly_type : string -Primary_Material_type : string -Pay_date : long +Check_Assembly() -Pay_mode : string +Add_Material() +Get_Assembly() -Order_id : string +Get_Material() -Pay_amount : int 1..* +Manage_Material() +Check_Payment() 1..

1 Enquiry -Enq_id : string Roomtype -Enq_name : string -Room_id : string -Contact_no : string -Room_type : string -Enq_date : string +Add_Room() -Enq_detail : string +Get_Room_Details() -Email_id : string -Cust_id : string +Add_Enquiry() +View_Enquiry() ? ER Diagram: CHAPTER 3: Implementation3.1 Screenshot of Application: Splash Screen Login Registration Home Navigation drawer Category Virtual Mirror 3.2 Screen Shots of Admin Panel: ? Here, admin can log in to the system and add, update and delete the category and products.? Admin manage the activity of users, orders, and related payments. 3.

3 Testing and Verification:Testing:? Incremental Integration Testing: Bottom up Approach is done. Continuous Testing of an application as a new functionality is added. Application functionality and modules should be independent enough to test separately done by programming or by testers.? Testing Planning involves how to plan testing before we are going to start making test suite .First step of testing is to test the System Module by Module that is once the module has been completed we test the module. Blank space indicates required field in database, thus manual testing is done.

3.4 Data Dictionary:? dbo.Registration: Entities Datatype Constrain Description U_id Int Auto Increment Unique Id Name Nvarchar(30) Not Null Name of User Gender Nvarchar(30) Not Null User’s gender State Nvarchar(30) Not Null User’s state Email Nvarchar(30) Not Null User’s Email ID? dbo.Category: Entities Datatype Constrain Description C_id Int Auto Increment Category Id Cat_Name Nvarchar(30) Foreign Key Name of category? dbo.Product: Entities Datatype Constrain Description P_id Int Auto Increment Product Id Name Nvarchar(30) Not Null Name of Product Price Nvarchar(30) Not Null I_path Nvarchar(30) Not Null Image Path Description Nvarchar(30) Not Null ? dbo.Order: Entities Datatype Constrain Description O_id Int Auto Increment Order ID Name Nvarchar(30) Not Null C_Name Nvarchar(30) Foreign key Category Name I_path Nvarchar(30) Not Null Image Path Price Nvarchar(30) Not Null ? dbo.

Order_Detail: Entities Datatype Constrain Description OD_id int Auto Increment Order Detail ID Name Nvarchar(30) Not Null Address Nvarchar(30) Not Null Mobile Nvarchar(30) Not Null User Name Nvarchar(30) Not Null ? dbo.Feedback: Entities Datatype Constrain Description F_id int Auto Increment Feedback ID Name Nvarchar(30) Not Null Email Nvarchar(30) Not Null Description Nvarchar(30) Not Null User Name Nvarchar(30) Not Null ? dbo.Enquiry: E_id int Auto Increment Enquiry ID Name Nvarchar(30) Not Null Email Nvarchar(30) Not Null User Name Nvarchar(30) Not Null CHAPTER 4: PPR & PDE1. Periodic Progress Report (PPR): 2. Patent Drafting Exercise(PDE): CHAPTER 5: Summary & Conclusion5.1 Scope of Project:Interio provides a full scope of services like: analysing the client’s need and goals, formulating design concepts that are functional, fiscally appropriate and also user can try their product virtually using this application.

5.2 Future Enhancement:For the future enhancement, we provide some new features.The Application can be improved in many ways and can be extended to support more devices like IOS devices.Push notifications..

.5.3 Conclusion:Thus, on successful completion of the application, it is concluded that it will help the user who are member of the “Interio” and working in application will never face any problem in doing the error less project with the planning ; tracking operation of that particular system.

At the end of this report we would like to conclude that we have successfully analysed and designed the project which is much secure and user friendly. BIBLIOGRAPHY:Search Engine: Google:

inOther Websites: YouTube: Pepperfry: https://www.pepperfry.comReferences:1 http://www.tutorialspoint.

com/android/android_login_screen.html3 Dr. Manish Kumar, Dr. M Hanumanthappa, Dr. T V Suresh Kumar, International Journal of Advanced Research in Computer and Communication Engineering4 Installation: 5 For SQL:


I'm Piter!

Would you like to get a custom essay? How about receiving a customized one?

Check it out