Loading presentation...

Present Remotely

Send the link below via email or IM


Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.


Restaurant Database

No description

Malika Ladha

on 3 December 2013

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Restaurant Database

Restaurant Database
SQL Query - Employee Shifts
Add more menus
Add more shifts for employees
Implement rewards program for frequent customers
Add inventory table to track vendors and suppliers
Requirements Analysis
The restaurant database will store information of the following;

Customer Information
Menu Items and Pricing
Employee Work Schedules based on job position
Customer Orders and Billing
Table Booking/Reservation Information
Business Rules
Reservations and Walk-in guests
Tracking walk-in guests
Lunch, Dinner and Specialty Menus
Tables & Seating
Staff roles (job position)
No. of employees per shift
Structured Query Language
SQL Query - Drinks Menu
SELECT MenuItem.menuItemDescription, MenuItem.menuItemPrice, Menu.MenuDescription
FROM menuItem, menu
WHERE menuItem.menuID = menu.menuID and menu.menuDescription = "Drinks";
SQL Query - Reservations
SELECT c.customerFirstName AS ["First Name"], c.customerLastName AS ["Last Name"], b.dateOfBooking AS ["Date of Reservation"], b.timeBooked AS ["Time of Reservation"], t.tableNumber AS ["Table Number"]
FROM Customer AS c, Booking AS b, TableSeating AS t
WHERE (((b.dateOfBooking)=#12/4/2013#) AND ((t.tableNumber)=[b].[tableNumber]) AND ((c.customerID)=[b].[customerID]));
Lunch Menu Report
Employee Work Schedules
Reservations Report
Database Development Life Cycle
Requirements Analysis
Business Rules
Entity Relationship Diagram (ERD)
SQL Queries
Database Development Life Cycle
Requirements Analysis & Business Rules
Entity Relationship Diagram
DBMS (MS Access), Create Database & Load Data
Test & Fine-Tune Database
Operational Database
Entity Relationship Diagram
SELECT Staff.staffFirstName, Staff.staffLastName, Staff.staffRoleCode, Shift.ShiftDate, Shift.ShiftTimeID, ShiftTimes.ShiftTime, StaffRole.staffRoleDescription
FROM (StaffRole INNER JOIN Staff ON StaffRole.staffRoleCode = Staff.staffRoleCode) INNER JOIN (ShiftTimes INNER JOIN Shift ON ShiftTimes.ShiftTimeID = Shift.ShiftTimeID) ON Staff.staffID = Shift.staffID
WHERE (((Shift.ShiftDate)=#12/5/2013#))
ORDER BY Staff.staffLastName, Staff.staffFirstName;
What: Restaurant Database
How: Business Rules, Requirements Analysis & ERD
Tools: SQL Queries, Reports
Looking ahead: Scalability plans
Bloopers and Key Takeaways
At first, things went horribly wrong...

Designing a database isn't as easy as it looks
Access WILL modify your queries when you run them
Inserting consistent data between different tables
Full transcript