irene ye jacqueline lo john staudt juichuan hu mehreen qureshi
TRANSCRIPT
Irene Ye Jacqueline Lo John Staudt Juichuan Hu
Mehreen Qureshi
MEROLA’S RESTAURANT
Small Restaurant
Italian Food
Buffalo, NY
WHAT ARE WE?
To ensure that each guest receives prompt, professional, friendly and courteous service. To maintain a clean, comfortable and well maintained premises for our guests and staff. To provide at a fair price - nutritional, well-prepared meals - using only quality ingredients. To ensure that all guests and staff are treated with the respect and dignity they deserve. To thank each guest for the opportunity to serve them. By maintaining these objectives we shall be assured of a fair profit that will allow us to contribute to the community we serve.
OBJECTIVE
• Lack of centralized data•Disorganized records•Constantly shuffling
through papers
THE PROBLEM?
Our database…• Centralizes data• Makes it easier and accessible to find
records• Shows patterns and trends• Updates all information at once using
referential integrity• ADDS BUSINESS VALUE!
THE SOLUTION
Report 1: Customer Demographics
• Marketing perspective: advertising
• Expansion: where should we open a new restaurant? Possible
franchise?
HOW BUSINESS VALUE IS ADDED
Report 2: Customer Reservations
• Used to determine trends and patterns of peak hours
of business• Promotions, sales.
HOW BUSINESS VALUE IS ADDED
Report 3: Daily Special Accommodations
•Preparation before reserved parties arrived •Handicap accessibility• Show number of special needs• Should we invest in more equipment?
HOW BUSINESS VALUE IS ADDED
FLOOR PLAN1
12345
10
11 6
7
9 812
13
14
Report 4: Employee Reservation Schedule
• States when employees have to work for reserved parties, specifically for them
• Depicts most requested employees
• Potential pay raise and promotions
• Great Valued Employee Awards!
HOW BUSINESS VALUE IS ADDED
Report 5: Frequency of Customers• Shows loyal/returning customers• Used to offer promotions and
discounts • Determine relationship of loyalty
and distance from restaurant
HOW BUSINESS VALUE IS ADDED