Database_Project

Julio Paniagua Andrea Peralta

Campus Eats @ UNC-Charlotte

Description: In this project, we have modified a database system for students, faculty, and staff to look up a rating for drivers and restaurants.

Use Case:

Business Rules:

• Customer can create an account and search the database for restaurants and their ratings.
• Customer may provide restaurant and/or driver ratings after each order.
• Administrators may look up drivers ratings and restaurant ratings.
• Administrators may look up who highest or lowest ratings.
• Administrator can add or remove drivers and/or restaurants.

EERD: You will find the name of each table highlighted in blue. The primary key has a key symbol next to it, located first in each table. The foreign keys have a red diamond symbol next to them. These link the tables together. The data type (INT, VARCHAR, FLOAT, DATE) is located next to each column name inside the table.

Data Dictionary:

MySQL Queries

Stored Procedure

Web/App Implementation

MySQL dump

PPT Video (link)