Final_Presentation_Furniture_Shop -.pptx

very UseFull

1. Guided By Ms. Pratiksha Patel Presented by Mr. Hiren Lakhani ( 4014 ) A Project report on “ Furniture Store ” As a partial fulfilment For the degree of   BACHELOR OF COMPUTER APPLICATION 5 th semester 2024-25 SHRI SHAMBHUBHAI V. PATEL COLLEGE

2. EXICUTIVE SUMMURY

3. Furniture online shopping – The act of purchasing products/services over the internet. Online shopping has become popular among people, they have become techno-savvy and feel very comfortable using the internet. It has grown popularity over the years, mainly because people find it convenient and easy to purchase from the comfort of their home or office. One of the most attractive factors about online shopping is, particularly during the holiday season, it alleviates to need to wait in long lines or search from one store to another for a specific item. The Furniture online shopping has all possible variants of furniture’s in their catalog like a sofa, futons, single- seat chairs, multiple seat chairs, Tv holder set, Desk, Coffee table, Dining table. The company is planning to add the latest models to the catalog at best prices and offers making it a one-stop for any online shoppers looking for furniture.

4. Competitive Advantage

5. Today online shopping is setting trends. It offers significant advantages to users in a modern way of marketing furniture products/services using the internet. Among its main advantages are- Availability – We can buy a product at any time of day without dependence of commercial opening hours. Comfort – We can buy the product from home or the workplace, avoiding trips. Speed – Process of accessing products is done without delay and bureaucratic procedures. Best offers – We can find better offers for products at a much more comfortable price. More Payment options – It often prefers to pay via PayPal method, Credit card, Debit card methods. Detail of the products – We can obtain the product/service characteristics that we want to acquire, ask for opinions from consumers. Products get delivered to your doorsteps, without any hassle or load of shipping. You get to choose a lot of products and buy them at your fingertips.  

6. Introduction

7. Online shopping is a form of electronic commerce which allows consumers to directly buy products or services from a seller over the internet using a web browser. There are many reasons for such a rapid developing of online shopping, which is mainly because of the benefits that the internet provides. Nowadays the lifestyle of people is different. People feel uncomfortable and time consuming for going to crowded markets. The internet offers a different kind of convenience to consumers. They do not need to go out looking for product information as the internet can help them to search from online sites. Online stores are available 24/7 and many consumers have internet access both at home and at work. Furniture online shopping system contains a wide variety of products both high quality and mild quality keeping in mind the level of people. There are no national and international barriers. Here the consumers will be in a demanding position and suppliers will not be in command position. There are enormous employment opportunities in this system.

8. Functional Specification

9. Use-case diagrams, Business Rules, and Users/Actors/Roles are described in this Functional Specifications USE-CASE DIAGRAM In UML diagrams, Use-case diagrams are defined as diagrams that capture the system’s functionality and requirements. It consists of use cases, persons, or various things that are involving the features known as actors/elements that are responsible for implementing the use cases. These are responsible for visualizing the external things that interact with the part of the system

10. The above Use Case diagram explains how the actors (vendor, registered customer, online customer, new customer, credit payment service, pay pal, admin, authentication) interact with the system in Furniture Online Shopping.

11. Description of all Users/Actors/Roles: Register Customer   Register customer means a customer who has register for and has an active customer account. The registered customers can use the services provided by the company/Online system/Bank.   Online Customer   The online customer group is Web-based gathering places for customers, partners and others to discuss post reviews, brainstorm new product ideas and engage with one another about the company’s products, services, and brand. Social media technologies, mobile devices and web communications are making interaction with companies faster in recent times. New Customer   New Customer is a person/business/organization that has not purchased one’s goods or services previously, but now made a purchase of those products or services.  

12. Authentication   Authentication is the process of giving individuals access to system objects based on their identity. This may mainly base on an individual username and password.   Admin   Admin provides security and offers user authentication as a service. This is a trusted provider that lets a person use single-sign-on to access many other websites. It maintains furniture information which is distributed by vendor.   Credit Payment Service   Credit Payment Service uses the software as a service model and form a single merchant service for their clients to use payment methods.

13. Business Rules: Registration of new users is possible only with a valid Email Adress . The system provides a 10% discount on the entire bill during checkout for every newly registered account/user. A valid credit card number must be provided for orders to be processed. Users could change/cancel their orders up to 24 hrs. after the order confirmation The return policy of products is 90 days and must be returned appropriately to avoid any deductions Every year for orders made on the first Sunday of July, free shipping is provided FUNCTIONAL TEST PLAN: Functional test plan measures the quality of the functional components of the system. It is testing the application from the customer’s viewpoint. The functional test plan is concerned with how the application is meeting business requirements. In this phase of plan, we try to capture as many test cases as possible to ensure the quality of the code and test all the business rules built into code

14. Below is the list of scenarios: New User: When a new user trying to order a product. The status of the product may be available/ unavailable product. Existing User: When an existing user wants to order a product. The status of the product may be available/ unavailable product. Guest User: Guest user ordering a product. The status of the product may be available/ unavailable product. Payment Processing: Payment processing or responses for various types of users. The user may be a new, existing or anonyms user. The following test cases are intended to test the complete functionality of the system and they must be validated before we can proceed to the next phase of the project. Test Case #1: Test Description: User log into application Test Prerequisites: None Required Input: Enter username and password Action Required: Press Submit to login Expected Result: User can able to login into the application and can view the complete list of items in the application.

15. Test Case #2: Test Description: User should be promoted to register Test Prerequisites: New User/ Unregistered user Required Input: None Action Required: Press Register Expected Result: The user will be redirected to the registration page.   Test Case #3: Text Description: Users should able to enter and submit the registration forms. Test Prerequisites: Test case #2 Required Input: None Action Required: Submit Expected Result: User will be redirected to the login screen and the user must give new username and password

16. Test Case #4: Text Description: User is redirected to login page Test Prerequisites: Test case#3 Required Input: Username and password Action Required: Submit to login into application Expected Result: User will be login into the application and the user can view the list of all items. Test case #5: Test Description: User can view the list of all the items in the application and can add the required items to the cart Test Prerequisites: None Required Input: None Action required: Add to cart Expected Result: List of items selected by the user should be saved to cart and allowing to continue shopping and browser more items.

17. Test case #6: Test Description: User Should provide the payment info to order the product that already added in cart Test Prerequisites: Test case #5 Required Input: Payment Information Action Required: Order Product Expected Result: The system must verify the payment information and place the order. Test case #7: Test Description: When the user-provided payment method is invalid or not processed then the user should see the alternative payment method message. Test Prerequisites: Test case #6 Required Input: Payment information Action Required: Order Product Expected Result: The system must verify the payment information and place the order.

18. Test case #8: Test Description: User should receive a confirmation of the order on successful payment. Test Prerequisites: Test case #6 Required Input: None Action Required: Order Product Expected Result: When the payment is successful the system should display the order confirmation page. When all the test plans are completed, the tester can execute the test plan. A Functional test plan plays an important role in the context of the application development cycle. It promotes communication between technical and business areas and help the development team better understand business requirement.

19. USER INTERFACE SPECIFICATIONS:   The user interface design specification is an essential step for building a product. It allows us to visualize a rough draft of the application which we are about to build. Usually, the most successful User interfaces are the ones that are simple to use. So, we have tried to do the specification for each feature or for each page in detail by visualizing it in a simple way. Below are the specifications for each page     If we consider/visualize the application the most important and distinct pages would be Login page Home page Shop Page  About page Contact-us page   All the pages would be built in such a way that they fit properly as per the screen resolution i.e., built for both desktop and mobile browsers. The application will be a responsive design that fits nicely and adjusts each page below as per the screen size.

20. ENTITY RELATIONSHIP DIAGRAM: Entity Relationship Diagram is also known as the ER diagram, ERD or ER model. It is a type of structural diagram for use in database design. An ERD contains different symbols and connectors that visualize major entities within scope and inter-relationships among these entities.

21. ISSUES TO FUTURE STUDIES: The Furniture Online Shopping can extend its services to mobile devices by creating GUI web interfaces for smartphones by developing apps for apple and android users, this leads to an increase in the user base. It may also lead to features like sending automatic emails to registered users when there is any clearance or discount sales and price drop on any item. It can also include a wish list for registered users in the application which allows the users to add an item they wish to purchase in the future without browsing through the catalogues for faster checkout.   CONCLUSION: The Furniture online shopping is a website exclusively developed for shopping furniture models with a variety of latest models and updated daily to the catalogue, allowing users to browse, add items to cart and order the products for shipment by paying online. Furniture Online Shopping is designed for people to shop online rather than searching for furniture by visiting the shop.

22. Output Screens

23. Home Page

24. Registration Page

25. L ogin Page

26. S hop Page

27. A bout Page

28. C ontact Page

29. C art Page

30. W ishlist Page

31. Database Table

32. Database Table     Registration Database table Products Database table Contact Database table 4) Payment Database table Field Name Key Datatype id Primary Key integer username   varchar email   varchar password   varchar Registration Database Table :

33. Product Database Table: Field Name Key Datatype id Primary Key integer name   varchar Price   Integer image   varchar Contact Database Table: Field Name Key Datatype id Primary Key integer name text email   text subject   text message   Text

34. Payment Database Table: Field Name Key Datatype id Primary Key integer Card-Holder-Name varchar Card-No   varchar Exp-Date   varchar Cvv   varchar email Foreign Key varchar

35. Adminside OutputScreen

36. Admin-Login Page Registration Page

37. Contact Page Product Page

38. Payment Page

39. F or PHP https://www.w3schools.com/php/default.asp https://www.sitepoint.com/php https://www.php.net/ For MySQL https://www.mysql.com/ http://www.mysqltutorial.org For XAMPP https://www.apachefriends.org/download.html F or UI-DESIGN https://themes.getbootstrap.com REFERENCES

40. THANK YOU