The EasyDelivery Management System is a relational database management system designed to streamline the operations of EasyDelivery Company, a food/product delivery service. The system efficiently stores and manages data related to employees, customers, restaurants, orders, and delivery logistics, providing a centralized and organized approach to managing the company's operations.
- MySQL or Oracle database management system.
- Compatible operating system (e.g., Windows, macOS, Linux).
- Employee and Customer Management: Store and retrieve information about employees and customers, including personal details, contact information, delivery addresses, membership statuses, and more.
- Shop Management: Manage restaurants and supermarkets, including details such as names, addresses, phone numbers, product inventory, contracts, and schedules.
- Order and Delivery Tracking: Track customer orders, order contents, payment details, delivery status, and assign deliverers and vehicles for efficient delivery management.
- Promotions and Comments: Handle shop promotions, customer reviews, ratings, and comments for improved customer engagement and feedback.
- Superclass/Subclass Relationships: Implement superclass/subclass relationships to optimize the database design, reduce redundancy, and improve scalability and maintainability.
- Business Rules: Incorporate additional business rules such as customer review restrictions, point accumulation for premium and silver customers, promotional codes for employees, and expedited delivery services.
- Clone the repository
git clone https://github.com/yashwanth-javvaji/easydelivery-management-system.git - Ensure that you have a compatible relational database management system (e.g., MySQL or Oracle) set up.
- Import the database schema and populate it with the provided SQL statements.