Project Overview: Designed and implemented a relational database system for a food delivery application, focusing on database schema design, ER modeling, SQL query development, and data normalization to ensure efficient data management and integrity,
Tools Used: SQL, Relational Database Design
Database Components: ER Diagram, Relational Schema, Tables with Primary & Foreign Keys, Sample Data Records
Key Implementations: ER diagram design and schema mapping, Creation and population of tables, Development of 15+ SQL queries for data analysis and management, Application of normalization principles, Implementation of backup procedures
Objectives: Ensure data integrity and reduce redundancy, Enable efficient restaurant and order data management, Simulate real world database functionality