Purpose

India has a major market where there is a strong demand for top quality in flight catering services. A complicated system like airline catering needs to consider various issues. It is the independent international system which provides a collaboration work made easy by chef and administrator.

Project Scope

Airline Catering Services software provides a better user interface in the catering system. Here we maintain all the details of the chef and we maintain the all the goods available in the store. This makes the chef work more reliable. Apart from this Airline Catering Services application we also maintain transport details we have different vehicles to carry different food materials.

Communication interfaces:

System Design:

Study of Existing system

“India is a major market where there is a strong demand for top quality in-flight catering services”. A complicated system like airline catering needs to consider various issues. Till now this type of system is not yet integrated to provide automated catering services.

Technical architecture:

Proposed system

Airline catering services is the independent international airline caterer services which provides a collaboration work made easy by chef and administrator. Transport and Retrieval System have been devised manually, making the entire material handling/stacking process completely mechanized.

Using this Airline Catering Services application administrator can get the details such as number of passengers traveling in the aircraft, the items to be packed for the airlines, what type of food Items (veg or non-veg), beverages that are to be supplied. He can send the required information for administrator.

UML Diagrams:

Use Case Diagram:

Class Diagram:

Sequence Diagram for User:

Sequence Diagram for Admin:

Sequence Diagram for Chef:

Database design:

Requirements

Functional requirements

The following modules are present in this Airline Catering Services application:

  • Administration System: In this module admin can send all the details required to other members. Details like number of passengers travelling in the aircraft, the items to be packed for the airlines, what type of food items (veg or non-veg), beverages that are to be supplied will be configured.
  • Chef: The chef should have the details like number of dishes to be prepared. He will plan what are the items and beverages to be purchased from the vendor. He has to take care of each and every goods that is required for the chef, and he has to maintain each and every flight timings and what the food to be served for that particular airline he has to maintain all that details
  • Care taker: He is responsible to transfer the goods from the transporter to airlines. He plays a major role, he has to maintain all the records of what all the goods he delivered and at what time he received the good. He has check whether the food is good or spoiled during the traveling.

Database tables

TABLE NAME:  Airreg

Column name Data type Length Allow null
Id int 4 0
name varchar 50 0
email varchar 50 1

 

telephone varchar 50 1

 

address varchar 150 1

 

pin varchar 50 1

 

city varchar 50 1
status char 10 0

TABLE NAME:  Chef_Orderproducts

Column name Data type Length Allow null
chefProductsId int 4 0
ProductsOrdered varchar 2000 1
OrderId int 4 1
ChefEmpId int 4 1

TABLE NAME:  roles

Column name Data type Length Allow null
role_Id Int 4 0
role varchar 50 0

TABLE NAME:  Flightdetails

Column name Data type Length Allow null
FlightId int 4 0
FlightName varchar 50 1
FlightTimings varchar 50 1
Deliverytime varchar 50 1
Reporteename varchar 50 1
Reporteephno varchar 50 1


TABLE NAME
:  Food_Type

Column name Data type Length Allow null
foodTypeId int 4 0
foodType varchar 50 1
description varchar 150 1
status bit 1 1

TABLE NAME:  ItemImages

Column name Data type Length Allow null
imageId int 4 0
imageName varchar 50 1
imagePath varchar 50 1
IsActive bit 1 1

TABLE NAME:  Items

Column name Data type Length Allow null
ItemId int 4 0
itemName varchar 50 0
itemDescription varchar 150 1
itemCost float 8 1
ItemTypeId int 4 0
imageId int 4 1
foodTypeId int 4 1
categoryId int 4 1
ItemTempId varchar 50 1
IsActive bit 1 0

TABLE NAME:  Item temperature

Column name Data type Length Allow null
ItemTempId int 4 0
Temperature varchar 50 1

TABLE NAME:  Itemtype

Column name Data type Length Allow null
ItemTypeId int 4 0
ItemType varchar 50 1
description varchar 150 1
status bit 1 1

 Software :

  • Language : Microsoft C#
  • Microsoft ASNet
  • Runtime : Microsoft Framework
  • Environment : Microsoft Visual Studio IDE
  • Web server: Internet Information Services (IIS)
  • Database : Microsoft SQL Server
  • Operating system : Microsoft Windows

6.2 Test cases:

Test case number #01
Module Airline
Description Registration
Input Provide the details in the registration page for the airlines
Expected Output Request for username and password to be entered
Actual output Request for username and password to be entered
Test case number #02
Module Airline
Description registration
Input Provide the login details
Expected Output Displays a message that registration is successful
Actual output Displays a message that registration is successful
Test case number #03
Module Airline
Description login
Input Provide the login details and select the user option in dropdown
Expected Output Displays catering services home page
Actual output Displays catering services home page
Test case number #04
Module Airline
Description Home page
Input Click on about us link
Expected Output Displays the catering management information
Actual output Displays the catering management information
Test case number #05
Module Airline
Description Home page
Input Click on contact us
Expected Output Displays the address of catering services
Actual output Displays the address of catering services
Test case number #06
Module Airline
Description Place an order page
Input Select the food timings and food type
Expected Output Displays the item name, image, description and quantity information
Actual output Displays the item name, image, description and quantity information
Test case number #07
Module Admin
Description Home page
Input Click on orders link
Expected Output Displays the flight details, order details and delivery time
Actual output Displays the flight details, order details and delivery time
Test case number #08
Module Admin
Description Home page
Input Click on orders and view
Expected Output Displays the order details previously entered and  the items ordered
Actual output Displays the order details previously entered and  the items ordered
Test case number #09
Module Admin
Description Home page
Input Click on orders and accept
Expected Output Request to select the chef to whom order has to be assigned
Actual output Request to select the chef to whom order has to be assigned
Test case number #10
Module Admin
Description Home page
Input Select the chef from the drop down list
Expected Output Displays the particular chef information
Actual output Displays the particular chef information
Test case number #11
Module Admin
Description Home page
Input Click on submit
Expected Output Displays a message that the order has assigned successfully
Actual output Displays a message that the order has assigned successfully
Test case number #12
Module Chef
Description View order
Input Click on order link
Expected Output Displays the order item details and order status
Actual output Displays the order item details and order status
Test case number #13
Module Admin
Description view status
Input Click on order status
Expected Output Displays status as product ordered by chef
Actual output Displays status as product ordered by chef
Test case number #14
Module Chef
Description if the order is ready
Input Click on chef inprocess order link
Expected Output Click on completed preparing food link
Actual output Click on completed preparing food link

Output Screens shots

  1. Login
  2. “User” home page
  3. Select Food as per our choice
  4. Place Order
  5. Admin Login
  6. “ADMIN” check for orders with respective of flight details , food types. He sends order information to “CHEF”
  7. CHEF logins and check his orders and prepares food .

Conclusion:

This  proposed  project  “Airline Catering services” is  analyzed ,designed , developed and  tested in the specified  period  of time  using the Advanced Microsoft  .Net technology   to automate the general operations held in a catering system