A prebuilt datatbase to jumpstart your online food ordering applications.
Explore the docs »
View Demo
·
Report Bug
·
Request Feature
Table of Contents
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.
- MySQL Database Server
- SQL Web Server Package
- SQL Database Programming Language
- phpMyAdmin Database Management System
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.
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.
- Download the food-ordering.sql & testDatabase.sql from the repository files before moving to the next step.
- 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.
- 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.
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!
- Fork the Project
- Create your Feature Branch (
git checkout -b feature/AmazingFeature
) - Commit your Changes (
git commit -m 'Add some AmazingFeature'
) - Push to the Branch (
git push origin feature/AmazingFeature
) - Open a Pull Request
Distributed under the MIT License. See LICENSE.txt
for more information.
Karla Sanchez - ksanch7@gmail.com
Website - karlasanchez.us
Project Link: https://github.com/karlasanc/Online-Ordering-Database
- 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.