1 / 6

China Garden

China Garden. Presented by: Zixi Chen Kevin Jones Gregory Lucsok Paul Taber Chang Zeng. Project Background. Chinese restaurant The overall goal of this database is to track customer ordering patterns Database keeps track of: Customers and favorite dishes Chefs Dishes

oria
Télécharger la présentation

China Garden

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. China Garden Presented by: Zixi Chen Kevin Jones Gregory Lucsok Paul Taber Chang Zeng

  2. Project Background • Chinese restaurant • The overall goal of this database is to track customer ordering patterns • Database keeps track of: • Customers and favorite dishes • Chefs • Dishes • Customer order times • VIP Customers • Tracks Daily Revenue patterns

  3. Business Problem/Opportunity • Over/Under staffed • Customer loyalty • Customer’s favorite dishes • Daily Patterns (Orders and Revenues) • Location of Customers • All of these increase efficiency

  4. Database Design • Tables • Customer, Chef, Dish, Customer’s Favorite Dish, Orders • Queries • Order times, Customer Loyalty, Zip Code, Daily Revenues • Forms • Customer, Chef, Dish, Customer’s favorite dish sub, Orders sub • Reports • Order times, Customer Labels, Customer Location, Daily Revenues

  5. User Interface Design • Menu items on the website • Navigation Form • Attachment of Chef photos • Print and close form buttons • Help button

  6. Project Demonstration

More Related