Food Express is a database-driven platform that supports the operations of food ordering, processing, and delivery services. It is built on a robust database architecture designed to store, manage, and retrieve various types of information efficiently.
This repository contains the following files:
creation.sql: SQL script for creating the database schema.insertion.sql: SQL script for inserting initial data into the database.Documentation.pdf: Detailed documentation of the database design, including an introduction, ERD, relational schema construction, and descriptions of the database relations.
For detailed information on the database design and functionality, refer to the Documentation.pdf file included in this repository. This document covers:
- Introduction to the system
- Entity-Relationship Diagram (ERD)
- Construction of the relational schema using both top-down and bottom-up (Normalization) approaches
- Description of the database relations and their attributes
- Procedures for business logic
- Functions for reusable computations
- Views for simplifying complex queries
- Triggers for automated actions based on specific database events
- Relational data model