Corey Schneider || Josh Clinkscales || Avimael Obispo || James Perez || Nicholas Smith
- Introduction
- Use Case for Rating System
- Business Rules
- EERD
- Data Dictionary
- MySQL Queries
- Stored Procedure
- Index
- MySQL dump
- Video
The idea of this project is to enhance a system for an existing database by adding a rating system. The system is a food delivery service to campus for students and faculty. This rating system will allow users to leave ratings for both the restaurants and the delivery drivers.
- The project adds a rating system to an already existing database, the ratings are applied to both the restaurants and the delivery drivers.
- Persons can be faculty, staff, and students.
- Persons can also be drivers, all delivery drivers are students.
- A person can order food one to many times, an individual order is tied to only one person for the order.
- The orders are for only one restaurant.
- The order can only have one location.
- The items on the order will only need to keep the total price and delivery charge, as well as keep the driver and delivery times.
- Locations where the food can be delivered, as well as a food delivery drop-off are included in the database.
Narrative: This ERD displays the relationships of a food delivery service handled by a university. Restaurants make food based on the orders made. Students are drivers that deliver food to an address. Restaurants and Drivers are given ratings based on their on performance and quality.
Procedures that get the average ratings as well as get the ratings tables.
See Dump File at the top of repository, "CampusFeedSqlDumpV2.sql".