1 / 11

Pistacho's Dining Service Database

Pistacho's Dining Service Database. Breslin, Karisa Covert, Jason Hadiya, Ashok Kraatz, Alyssa Spencer, John. Overview of Company. Pistachios Dining Experiences Dining Service Reservation of Tables Ashok Hadiya – Business Expert Current Database – Paper Scheduling Book

Download Presentation

Pistacho's Dining Service Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Pistacho's Dining Service Database Breslin, Karisa Covert, Jason Hadiya, Ashok Kraatz, Alyssa Spencer, John

  2. Overview of Company • Pistachios Dining Experiences • Dining Service • Reservation of Tables • Ashok Hadiya – Business Expert • Current Database – Paper Scheduling Book • Harder to get information

  3. System Description • Database Information Areas • Customers • Employees • Table Reservations • Backup Strategies • Incremental Backup • Full Backup • Future Enhancements • Redesign & compatible with other database software

  4. Benefits of Database • Convenience • Report Generation • Predictions • Accuracy • Cost Saving

  5. Forms • Customer Reservation • User-Friendly • Easy to Access • Short • Employees • Convenience • Easy to Navigate • Print

  6. Reports Total Sales on Particular Date with Payment Type Sales by Meal Type on Particular Day Sales Report of any particular Date With Payment type; Cash, Credit Card, Check or Other Check every end of the day in cash register Hottest Meal Numbers of people Sales from each Meal Total Sales

  7. Reports Busiest Day by Number of Customers Email Notification Busiest day first Compare with other day Assist management in sales goal More than 80 customers indicates very busy day Introduce New Menu Promotions E-Coupons Follow FB and Twitter

  8. Reports Total Salary Salary by Employee Type Shows which type of employees are receiving the highest total salary Keeps finances in order Shows amounts to be paid by end of each month Organizes employee’s monthly salary Compares employee type to wage Aids estimation of new employee salary Assists management in budgeting

  9. Report: Customers by City • Report highlights where customers are located • Adds precision to advertising • Increase revenue/advertising dollar

  10. Summary • This database will • Save time • Ensure Accuracy • Increase Sales • Cut Costs • Further Pistachios grip on monopolizing it’s UB restaurant empire.

More Related