Online Food Ordering Database

A prebuilt datatbase to jumpstart your online food ordering applications.
Explore the docs »
View Demo · Report Bug · Request Feature

Table of Contents

1. About The Project
   • Built With
2. Getting Started
   • Prerequisites
3. Usage
4. Contributing
5. License
6. Contact
7. Acknowledgments

About The Project

This is a pre-built relational database structure designed and implemented for an online food ordering application to facilitate seamless food ordering and delivery processes for a restaurant. The database is meant to stores, manages, and displays customer, restaurant, employee, product, order and payment information.

Project create for CPT310: Database Systems & Management course at the University of Arizona Global Campus.

Built With

• MySQL Database Server
• SQL Web Server Package
• SQL Database Programming Language
• phpMyAdmin Database Management System

(back to top)

Getting Started

For more details on schema, table, and column creation, please refer to the User Documentation.
For a video walkthrough of the finished datatbase, please refer to Video Demo.

Prerequisites

Ensure you have a phpMyAdmin account and that your MySQL database server are running. It is assumed that database users have their own setup and can access the database management system.

(back to top)

Usage

1. Download the food-ordering.sql & testDatabase.sql from the repository files before moving to the next step.
   
2. Create a new database schema for downloaded files.

• [a] Select New on the left-side menu to create new datatabase.
• [b] Name the Database your own chosen name.
• [c] Ensure utf8bb4_general_ci is selected from the collation drop down menu.
• [d] Click Create.

3. Import Database files.

• [a] Ensure the new database is selected.
• [b] Click the Import tab at the top menu.
• [c] Ensure you are importing to the selected database.
• [d] Select Choose File and select the database file you imported earlier on your PC and click Go.

(back to top)

Contributing

Contributions are what make the open source community such an amazing place to learn, inspire, and create. Any contributions you make are greatly appreciated.

If you have a suggestion that would make this better, please fork the repo and create a pull request. You can also simply open an issue with the tag "enhancement". Don't forget to give the project a star! Thanks again!

1. Fork the Project
2. Create your Feature Branch (git checkout -b feature/AmazingFeature)
3. Commit your Changes (git commit -m 'Add some AmazingFeature')
4. Push to the Branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

(back to top)

License

Distributed under the MIT License. See LICENSE.txt for more information.

Contact

Karla Sanchez - ksanch7@gmail.com

Website - karlasanchez.us

Project Link: https://github.com/karlasanc/Online-Ordering-Database

Acknowledgments

• Eessaar, E. (2016). The database normalization theory and the theory of normalized systems: Finding a common ground. Baltic Journal of Modern Computing
• Coronel, C., & Morris, S. (2019). Database systems: Design, implementation, and management (13th ed.).
• Fatbit Technologies. (n.d.) Online Food Delivery Business Models.

(back to top)