We have launched new website StudyGyaan where you can Get Programming Tutorials, Projects on different programming languages, and much more. Do visit our website. Click here for Projects. You can also contribute and publish your projects on StudyGyaan Contribution

DBMS MINI PROJECT - Online Shopping Management System


This is a free DBMS mini project on Online Shopping Management System using back-end MongoDB as a database, front-end Php and HTML.

SNAPSHOT

ABSTRACT
In this project we are created one application which is easy to access user friendly.For this application we used the backend as Mongo DB to store the data which is used in the application and for the user interface we had used the PHP and HTML.2 kinds of people are able to use this application as manager and the customer as well. The customer is able to do the online shopping very easily from any place by reading the details of product and by seeing the product image.The manager is the only person who is able to add and remove the products from the site.
INTRODUCATION - Overview
This report discusses the result of the work done in development of "Airline Reservation System on “PHP” Front-end Platform and “Mondo DB” as back-end Platform.
At the development of an application PHP provides a good connecting facility between all pages, also the back-end Mongo DB is most important to save all the data related the application.

BACKGROUND and MOTIVATION
The definition of our problem lies in manual system and a fully automated system.
Manual system: The system is very time consuming and lazy. This system is more prone toErrors and sometimes the approaches to various problems are unstructured.
Technical system: With the advent of latest technology if we do not update our system thenOur business results in losses gradually with time. The technical systems contains the tools of latestTrend i.e. computers printers, fax, Internet etc. The systems with this technology are very fast,Accurate, user-friendly and reliable.

OBJECTIVE:-Need of Online Shopping

  • Convenience
  • Better prices
  • More variety
  • Price comparisons
  • No crowds

METHODOLOGY

  • To implement the above goals, the following methodology needs to be followed:
  • Specifying the Application and various components of the Architecture.
  • Specifying the bindings between the tasks and the resources either manually or by the design tools.
  • Specifying the port interconnections between the resources.

SCOPE OF PROJECT
The scope of the project is clear to give a simple and attractive application to simplify the work as well as to reduce the efforts while doing it offline or we can say by doing it with old methods.
In this application we are able to save database of all products present on the site.
In this we can buy any product very easily.

REQUIRMENTS
We are going to perform the project on windows platform so we need the os as windows.Any version of windows as windows xp, windows 7or windows 8.The system should have minimum ram of 256MB as well as minimum storage capacity of 15GB.The system should contain the server software named as “EasyPHP” of version 14.1VC11.And mongo DB of version 2.6.3 or above.First we have to install both software and we have to do connectivity between them by changing the configuration file of “EasyPHP”.

E-R DIAGRAM:


RELATIONAL DATA BASE DESIGN
1]Login:-
User, pass, fname, lname, address, pincode, phone
2] Order_details:-
buyer fname,buyer lname,buyer address,buyer pincodebuyer phone,buyer purchase pro_id, buyer purchase pro_name,delivery date,purchase date,buyer purchase pro_price
3] payment:-
buyer fname,buyer lname,buyer address,purchase date,buyer phone,buyer purchase pro_id,buyer purchase pro_name,buyer purchase pro_price,buyer pincode
4]Product:-
product id,product name,product desc,product price,product stock,product image

DATABASE NORMALIZATION:

First Normal Form:-
The relation is in 1NF if it has no repeating groups. All tables has no repeating groups so they are in 1NF.

Second Normal Form:-
A relation is said to be in second normal form if it is already in first normal form and it has no partial dependency
1) Login:
The absence of partial dependency in relation takes it into 2NF without any modification
2) Order_details:
The absence of partial dependency in relation takes it into 2NF without any modification.
3) Payment:-
The absence of partial dependency in relation takes it into 2NF without any modification
4) Product:-
The absence of partial dependency in relation takes it into 2NF without any modification

Third Normal Form
A relation is said to be in third normal form if it is already in 1st and 2nd NF and has no transitive dependency.
1)Login:
In Customer every attribute depends on primary key so it is in 3rd normal form
2)Order_details:-
In order_details depends upon address so another table with address and pincode is form to remove transitive functional dependency.
3)Payent:-
In Payment depends upon address so another table with address and pincode is form to remove transitive functional dependency.
4)Product:-
In Product in both the table every attribute depends upon the primary key so it is in 3rd NF.

GRAPHICAL USER INTERFACE
The application is very user friendly and uses a GUI interface implemented in PHP and HTML to Communicate with the user. Various features are self – explanatory. Forms are easy to fill in and components can be added, removed and updated very easily through a Single dialog box. The application includes tool-tip hints to give a brief description of the particular input Field.
List boxes are used to display all the components at once so that user can see all the components of a Particular type at once. One can just select the component and modify and remove the component.(based on the access control of the person)

FEATURES

  • Clean separation of various components to facilitate easy modification and revision.
  • All the data is maintained in a separate file to facilitate easy modification
  • All the data required for different operations is kept in a separate file.
  • Quick and easy saving and loading of database file.

CONCLUSION:
THUS WE HAVE SUCCESSFULLY IMPLEMENTED ONLINE SHOPPING DATABASE MANAGEMENT WHICH HELPS US IN CENTRALIZING THE DATA USED FOR MANAGING THE TASKS PERFORMED IN A ONLINE SHOPPING
WE HAVE SUCCEFULLY IMPLEMENTED VARIOUS FUNCTIONALITIES OF MONGODB AND PHP AND CREATED THE FULLY FUNCTIONAL DATABASE MANAGEMENT SYSTEM FOR ONLINE SHOPPING.

CONCEPTS USED

  • MONGODB-(DATABASE BACKEND)
  • HTML & PHP-(FRONT END)
  • EASY PHP-(CONNECTIVITY)
  • PROCEDURES

SOFTWARE USED

  • EASYPHP DEVSERVER 14.1
  • BROWSER



Click here for PHP and MongoDB - Wildlife Sanctuary 

Click here for PHP and MySQL - Hardware Store

Click here for PHP and MongoDB - Online Shopping Management System

Click here for JAVA Projects


                

7 comments:

  1. Wonderful & Funky Designing of Mobile Cover thanks for sharing your blog..... i like you’re crazy cover....Go to online shopping on www.crazybeta.com we are manufacturer of mobile covers, t-shirt for men’s & women’s, coffee mugs, beer mugs, vodka shot and sunglasses for men’s & women’s in different design & funny quotes for youth at best price in India....

    Visit here:- https://www.crazybeta.com/accessories/coffee-mugs/crazy-mugs

    ReplyDelete
  2. If one puts all the parameters together, online furniture rental makes complete sense where one can use the furniture as per the convenience and pay as per the budget, without having the need of owning the furniture. online furniture in India

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. JCECE Admit Card will be available to download in the 2nd Week of May,2018. Details about JCECE 2018 Admit Card are given in this article.

    Assam CEE admit card to be released on 9th April 2018. Click Here to know more. Step by step guide to view and download the admit card. Important instructions to be followed on the exam day. contents of Hall Ticket

    GUJCET Admit Card will be available to download in the Month of May. Get the latest information on GUJCET 2018 Admit Card here. The procedure to view and download the GUJCET 2018 admit card is also given in the article. GUJCET 2018 Hall Ticket link will be provided here as soon as it officially released.

    Get the detailed information about the Admit Card of Uttarakhand State Entrance Examination UKSEE for the academic session 2018-19 here UKSEE admit card

    GCET Admit card will be available from 27th April 2018. Get the latest information on GCET 2018 Admit Card. The admit card for GCET 2018 will be handed over to the applicant as soon as the candidate submit the application form at the application reception center.

    OJEE Admit Card Important Dates Related To OJEE Admit Card 2018, How To Download OJEE 2018 Admit Card, Information In OJEE 2018 Admit Card, OJEE 2018 Admit Card Important Highlights. Also Find Complete details.

    Get the latest information on IPU CET Admit Card. Step by step guide is provided to view and download the IPU CET admit card is also provided in the article. IPU CET 2018 Admit Card Download link will be made available here as soon as GGSIPU Releases the Admit Card.

    ReplyDelete
  5. canu send mongodb datatbase file for online shopping

    ReplyDelete