90 likes | 228 Views
CHINA KING RESTAURANT . By: Di Ni Jeffrey Huang Jieqiong Feng Yue Lin. China King Background . In business for over 10 years 5 branches in different areas of buffalo U sed to be under one manager but now all dispersed Current Owner: Chun Zhou Ni ( 8 years)
E N D
CHINA KING RESTAURANT By: Di Ni Jeffrey Huang JieqiongFeng Yue Lin
China King Background • In business for over 10 years • 5 branches in different areas of buffalo • Used to be under one manager but now all dispersed • Current Owner: Chun Zhou Ni ( 8 years) • 3500 Main Street #330 Buffalo NY 14226 • Specialized in Szechuan, Hunan and Cantonese Style • Eat In or Take Out • Operates 7 days a week, 11 hours a day • Well-Known for the low price and General Tso’ Chicken
Business Problem • Customer Relationship • Reliability • Time Efficiency
Business Value • Build a closer relationship with the customers • Provide efficiency
Database Design • China King Restaurant Entity-Relationship Diagram
User Interface Design • Use red background • China King LOGO at the bottom right of reports
Project Demonstration • Cashier’s Bonuses • Employees performance • Customers By Location • Business Expansion • Customers Ordering History • Tracking Customer’s order • Customers Visit Frequency • Customers of the Month • Popular Foods • Best sale product • Total Weekly Orders • Weekly profit http://www.acsu.buffalo.edu/~jieqiong/
Conclusion • Overall, improve business operation • build a stronger relationship with their customers