Christopher TraftonGet in touch
All work

Spring 2024 · Database Engineer

Restaurant Database

A relational database that organises a restaurant's orders by assigning staff to workstations that can cook specific menu items.

Role
Database Engineer
When
Spring 2024
Discipline
Data & Backend

Built with

  • SQL
  • SQL Server
  • EER diagrams
  • Information flow diagrams
SQL Server Management Studio with the restaurant database queries and their results.

Overview

A database that helps a restaurant organise its orders. Staff are assigned to specific workstations, and each workstation can cook a defined set of menu items, so every order item has a clear place to go.

SQL Server Management Studio running queries against the restaurant database

Building the schema in SQL Server Management Studio.

Design

I started with an information flow diagram and an enhanced entity relationship diagram, then implemented the schema in SQL and ran it on SQL Server.

Query results from the restaurant database

Querying orders, staff and workstations.