Restaurant Application

port1

Summary:

This project is a restaurant application to allow the user to navigate businesses and their information based on a selected location. I did this project with two other students in my databases course.

My Role:

My role in this project was to initially create the ER (Entity Relationship) diagram for the data we were using and then create the tables, attributes and relationships based on that diagram. I also created those tables for our PostgreSQL database to allow for the data to be inserted. I also worked on the Triggers and Updates for the database when event occurred in the UI. I created the checkin window with functioning checking button as well as helped with other various UI tasks and SQL calls within the application.

Technologies Used:

  • C# / Winforms
  • Visual Studio
  • SQL
  • PostgreSQL
  • Notable Features:

  • Find user
  • Find business based on location
  • Sort business' based on catagories
  • See business reviews with the ability to like reviews or leave new reviews
  • View number of checkins per month for a selected bussiness and add a checkin to that business
  • Project Demonstration:

    Github: https://github.com/lshearer20/Restaurant_Application