Portfolio - Restaurant Database Management System

Posted on In Views: Disqus: Symbols count in article: 532 Reading time ≈ 1 mins.

Restaurant Database Management System

A solution based on Oracle SQL for restaurant’s daily maintainance including order, reservation, checkout and financial management.

Highlights

  • Basis the past choices a custom menu will be available to each customer along with the traditional menu.
  • Free delivery of birthday cake for the prime members.
  • Automatic calculation of related data such as stock number, order total and tips.
  • Support overview and digests organizing in reports for easy analysis.

Structure

  • EAD
    DAMG-6210_Project5_final_ERD.jpeg

Example

  • CRUD of Customer
    Customer_CRUD.png
  • CRUD of Member
    member_CRUD.png
  • Customized Menu
    customized_menu.png
  • Dine-in Order
    dineinorder.png
  • Delivery Order
    deliveryorder.png
  • Order food
    orderfood.png
  • Check Out
    checkout.png
  • Reservation
    reservation.png