Restaurant Manager

A Database Modeling the Backend of a Restaurant

About

Project Overview

The objective of this project is to create an integrated database focusing on the back end of the restaurant. This database will not be the sole database in the restaurant but a starting point to get a newly or transitioning restaurant started in the right direction. Our vision is to cater information that the owner, management, and other employees will need to see in or outside the restaurant to keep things running smoothly.

Project Guidelines

This project was broken down into seven parts under the guidance of our instructor.

  1. Database Proposal
  2. ER diagram
  3. Converting our ER diagram to Relations
  4. Normalization
  5. Initializing MySQL Database
  6. Testing Our Database Throught Queries
  7. Displaying Our Database To The Web

ER Diagram

Relations

Choose a Relation
  • Restaurant_Information
  • Employee_Information
  • Employee_Dependents
  • Supplier
  • Sales
  • Expenses
  • Orders
  • Food_Drink_Stock
  • Equipment
  • Staff
  • Generates
  • Pays
  • Operated_By
  • Distributes
  • Utilizes
  • Delivers
  • Contacts
  • Managers