Scribd
Upload
51 views1 page

Deepti Assignment 2

The document outlines various tables related to a restaurant management system, including customer information, reservations, sales orders, menu items, credit card details, cash receipts, dining arrangements, ingredients, recipes, staff details, and next of kin information. Each table contains specific fields relevant to its function, such as customer names, reservation numbers, meal descriptions, and employee details. This structured data is essential for managing restaurant operations efficiently.

Uploaded by

Deepti Dighe
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
51 views1 page

Deepti Assignment 2

The document outlines various tables related to a restaurant management system, including customer information, reservations, sales orders, menu items, credit card details, cash receipts, dining arrangements, ingredients, recipes, staff details, and next of kin information. Each table contains specific fields relevant to its function, such as customer names, reservation numbers, meal descriptions, and employee details. This structured data is essential for managing restaurant operations efficiently.

Uploaded by

Deepti Dighe
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Customer_T

Customer_number Customer_name Customer Address Customer_phone Customer_email

Reservation

Reservation_number DateTime Customer_number


PartyOf

Sales_Order_T

S_order_number Customer_number S_Date S_order_type Table_number

Menu_T

Menu_number Meal_number Start_time End_time Season Menu_period


T

Credit_Card_T

Credit_Card_number Customer_number Billing_Address

Cash_Receipt

Customer_
Receipt_number Credit_Card_number Bill_number Date Time Payment_Type
number

Dining_T

Table_number Reservation_Number Number_seats Status

Ingredients_T

Ingredient_name Ingredient_number desciption Measurement_unit Qty_on_hand Calories_per_unit Recipe_id Item_number

RecipeDirection

Recipe_id Serving_Size Direction

Staff

Employee_Number Employee_LastName Employee_FirstName Employee_Street Employee_City Employee_ZipCode Position SSN DOB Salary Department_Number Date Joined

Manager

M_Employee_number Car_Allowance Monthly_Bonus

Waiter_T

Employee_number M_Employee_number Waiter_Number Allocation_Number

Meals

Meal_number Meal_Name Description Price Employee_Number Menu_Number Recipie_ID

Recipie

Recipie_id Item_Number Quantity Ingredient_id

Bill

Bill_Number Row1 Row2

NextofKin

NextofKin_number Employee_number city state Zipcode Relationship

You might also like