Online Grocery Management Store PHP & MySQL Database Project

The main objective of this Web application is to provide an online product/ grocery purchasing website. Everyone needs food to survive. If someone wants to cook food even by themselves, they’ll first have to go to some grocery store, buy items, and carry all that heavy load of raw materials themselves to their home. That’s where an online solution can help so we have implemented the Online Grocery Store web application. All one needs to do is order everything they need for their cooking requirements online and relax till it gets delivered to their homes.

Online Grocery Store Challenges:

  • To keep a record of existing users, allow for the addition of new users, and removal of existing ones, and maintain several of their addresses
  • To maintain a catalog of available products, and categorize products into different types, and manufacturers
  • To maintain a cart for every user (one per user), and also all the orders he has done in the past, each order having multiple products, alongside the quantity they are available in.

Features of the Online Grocery Store project, and our plan to overcome the challenges mentioned above:

  • We will create tables for the user, address, product, category, manufacturer, order, cart, and product_order. E-R analysis is submitted along with this description.
  • The above model will be modeled in the form of tables and stored in SQL-based RDBMS, preferably MariaDB.

Wish List (features to be included if time permits)

  • To implement a user interface for addition, updation of products, manufacturer, etc.
  • To provide discounts for bulk orders, sales, etc.

Tables for Database Design:

User

User_Id

Email_Id

Password

First_Name

Last_Name

Mobile_no

Address

Address_id

Address_1

Address_2

Zip_Code

City

State

User_Id

Product

Product_id

Product_Name

Units

Picture

Weight

Category_id

Price

Product_Description

Manufacturer_id

Category

Category­_id

Category_description

Category_Name

Manufacturer

Manufacturer_id

Manufacturer_Name

G_Order

Order_id

Payment_Method

Order_time

Billing_id

Amount

Shipping_id

Address_id

User_id

Cart (User_Product)

User_id

Product_id

Quantity

Product_Order

Product_id

Order_id

Quantity

Price(of 1 unit)

 

ER Design Diagrams:

ER Diagram for Grocery Store Project

Functional Dependencies:

1) User Table
2) Address Table
3) Product Table
4) Category Table
5) Manufacturer Table
6) Grocery Order Table
7) Cart Table
8) Product Order Table

Leave a Reply

Your email address will not be published.

Online Grocery Management Store PHP & MySQL Database Project - Download Free project Source code, Project Report Documentation, PPT and Guidance