CMSC-127-Project

A database management system for recording data on food reviews and food items from food establishments.

To-Do

Features

• Add, update, delete a review on a food establishment or food item
  • Food Establishment
    • Add
    • Update
    • Delete
    • Search
  • Food Item
    • Add
    • Update
    • Delete
    • Search
• Add, update, delete, search a food establishment
  • Add
  • Update
  • Delete
  • Search
• Add, update, delete, search a food item
  • Add
  • Update
  • Delete
  • Search

Reports to be generated

• View all food establishments
• View all food reviews for an establishment or a food item
  • View all reviews for an establishment
  • View all reviews for a food item
• View all food items from an establishment
• View all food items from an establishment that belong to a food type
• View all reviews made within a month for an establishment or food item
  • Food Establishment Reviews
  • Food Item Reviews
• View all establishments with a high average rating (rating >= 4; ratings from 1-5; highest is 5)
• View all food items from an establishment arranged according to price
• Search food items from any establishment based on given price range and/or food type