Database Design and Implementation for a Food Delivery App using PostgreSQL
🍽️ Yemeksepeti Database Project(PostgreSQL) This project is a Relational Database Management System (RDBMS) solution designed within the scope of the Database Management course to model the business logic and data flow of the popular food ordering application Yemeksepeti.
🌐 Used Technologies -Database Management System: PostgreSQL -Management Interface: pgAdmin -Data Modeling: Entity-Relationship (E-R) Diagram -Query Language: SQL (DML and DDL)
📊 Data and Analysis (DML and Query) The yemeksepeti_dml_sorgular.sql file contains the following basic database operations:
- Data Insertion (INSERT): 10 sample data entries into all tables (7 tables).
- Data Update and Deletion (UPDATE/DELETE): Examples of comment updates and order deletions.
- 10 Queries (SELECT): 10 different SQL queries analyzing the application's business logic (including JOIN, GROUP BY, EXCEPT, etc.).