Elshrouk-Academy

**Project Description – Smart Inventory and Order Management System**

The Smart Inventory and Order Management System is designed to manage products, customer orders, and inventory in an organized and efficient way. The system allows businesses to track products, categorize them, manage suppliers, and monitor stock quantities in real time.

Each product in the system belongs to a specific category, which helps organize products and makes searching and management easier. Suppliers provide products to the system, and the inventory keeps track of the available stock for each product.

Customers can browse products, add them to a cart, and place orders. Every order may contain multiple products, and the system records important details such as order status, total amount, and payment information. Payments can be made using different methods such as cash, card, or online payment.

The system also supports delivery management. Drivers are responsible for delivering customer orders to their shipping addresses, ensuring that orders reach customers efficiently.

Additionally, the system manages customer addresses, order items, and payment records, providing a complete structure for handling e-commerce operations. By organizing these entities and relationships using an Enhanced Entity Relationship Diagram (EERD), the system ensures clear data structure, reduced redundancy, and efficient database management.

Overall, the project demonstrates how database design techniques such as entities, relationships, specialization, and categorization can be used to build a scalable and well-structured inventory and order management system.