Copper Kettle Restaurant Website

1
Copper Kettle Restaurant Website

• Mid Semester Presentation
• -Rainbow Group Incorporated

2
Purpose of the Project

• To enable the client publicize his restaurant
• Easy all-in-one access from one website
• Maintain restaurant information easily
• To gain a competitive advantage over other
  restaurants
• Attract customers from other regions

3
Present Problems

• Restaurant gained enough publicity but only in
  the local area
• Too many incoming phone calls asking for
  information
• Lack of a storage database with customer and
  staff information

4
Solution
A Website with a built-in database
5
Scope of the Project

• Website with details about the restaurant and its
  history
• Menu, opening and closing hours, etc
• Database for staff and customers with
  administrative rights to the website owner
• Staff database to contain list of full time, part
  time and casual staff
• Staff database also to include- number of hours
  worked by each of them
• Customer database with list of Regular
  customers and walk-in customers
• Customer membership status- discounts they are
  entitled for, depending on
• their number of visits in the last couple of
  months
• Online table booking and banquet hall, conference
  room callback facilities

6
Contd.

• Scope Summary
• Administrator login management
• One point access database with search function
• Security
• Customer attractions

7
The Client

• Ranjith Kumar PONNOJU
• Restaurant Manager
• Copper Kettle restaurant
• Hornsby, Sydney
• The client, Mr. Ranjith Kumar Ponnoju has an
  extensive experience in the
• Hospitality field. He has been the Team
  captain for 4 years at Leelas
• Resorts in Goa, India. Leelas is one of the
  most distinguished resorts in
• Asia and is frequently visited by
  international celebrities like Beatles start
• Sir Paul McCartney.
• Mr.Ranjith Kumar has also been the personal
  steward of Sir Paul McCartney
• on several occasions. He also worked as the
  head Steward in a number of
• five star hotels across the world. He is
  currently employed as the restaurant
• manager of Copper Kettle restaurant in
  Hornsby.

8
Project Team Structure
Project Supervisor
Client
9
The Team

• KESARI VENKAT KRISHNA REDDY
• Project Manager and system analyst
• SK MAHMUDUL HASAN
• Documenter and tester
• ANIRBAN ROY
• Database Administrator and Programmer

10
Supervisor

• Dr. James Hu
• PhD UNSW, B.E East China Ins
• Cert IV in Workplace and Training Assessment
• Email hjames_at_iibit.edu.au
• Unit
  Co-ordinator
• Kathleen Keogh
• Master Of Science by research,
• The University of Melbourne
• Graduate Diploma in education,
• ACU
• BSc(hons)

11
Development EnvironmentHardware Software

• Server Side
• Need to have a high bandwidth internet connection
• Operating System Windows 2000 Advanced Server/
  2003 Advanced server
• Processor Pentium 4 or 3.0 GHz or higher
• RAM 512 Mb or more
• Hard Drive 200 GB or more
• AGP Graphics Card
• Client side
• Operating System Windows 95/98/2000/XP UNIX
  LINUX.
• Internet explorer 6 or Above
• Processor 800 Mhz Processor or higher
• RAM 256 Mb or more
• Color monitor
• Screen resolution from 800 600
• Hard drive 40GB or more
• Sound Card

12
Prototype screen shots
13
Customer Details Page
14
Administrator Login Page
15
Database
16
Tables
17
Use case diagram
18
Risk Management

• Potential Risks
• Server Down ? Lost of money, bad reputation in
  the market
• Security Issue ? Privacy Problem, Lost of
  customer Data
• Hacking ? Hacking password, infrastructure crash
• Power Failure ? Loss of data, fail customer
  service
• Unexpected Tragedy? Server and total system Crash

19
Contd

• Solutions
• Server Down ?Try to Fixed as soon as
  possible
• Security Issue ?Changing password, upgrade
  Security level
• Hacking ?Change password, improve
  security
• strategy
• Power Failure ?Rent generators for power
  supply

20
Security

• Administrator (Restaurant Manager) has sole
  access to all the database features of the
  website except for booking (Customers have
  limited access to this feature)
• The server will constantly be upgraded with the
  latest Anti-virus and anti- spy ware utilities to
  avoid intruder access

21
Project Progress

• Accomplished tasks
• SPMP Ver 2.0
• SRS Ver 2.0
• Gantt Chart Ver 2.0
• Design Prototyping
• Database tables and fields
• Client requirements in full
• Next on track
• Upgraded SPMP Ver 3.0
• Gantt Chart Ver 3.0
• Database Script
• and some add-in features to the website.
• For more detailed information and to download the
  completed documents, please visit us at
• http//projects.iibit.edu.au/website/Cp783/Team2
  0S/index.html

22

• Any questions??????

END OF PRESENTATION