Pizza-Delivery-website

Author Sailee Phal

Project Overview: Pizza Delivery Management System

This pizza delivery project involves the development of a database system to manage various aspects of a pizza delivery service.
The system is designed to handle orders, track customer information and manage inventory.

Key Components:

1.Orders Management:

• The orders table stores essential order details, including order ID, creation timestamp, item information, quantity, customer ID, delivery status, and delivery address.
  
• Customers are identified and tracked using the customers table, which contains customer IDs, first names, and last names.
  

2.Delivery Address:

• Delivery addresses are maintained in the address table, which includes details like delivery address lines, city, and zip code.
  Each address is associated with an add_id.

3.Menu Items:

• The item table holds information about menu items, such as item IDs,names, costs, sizes, and prices.

Description of Modules

Customer Registration Module:
Allows new customers to register by providing their contact information and delivery address.
Provides the functionality to update or delete customer information.

Order Processing Module:
Allows customers to place orders by selecting menu items and specifying quantities.
Manages order details, including delivery status and addresses.
Supports order updates and cancellations.

Menu Management Module:
Enables the addition, modification, and removal of items from the menu.
Associates ingredients and prices with menu items.

Inventory Management Module:
Tracks ingredient levels and ensures sufficient stock for menu items.
Alerts when ingredients need replenishment or when an item cannot be prepared due to low inventory.