Scribd
Upload
1K views36 pages

Data Dictionary

The document describes the data dictionary for the Pizza Hut food-ordering system. It outlines the different databases that make up the system including sales revenue, customer, receipt, comment, report, menu upgrade, waiter, cashier, order, manager, payment, supplies, item, inventory, and customer information. For each database, it lists the data members (fields), their description, type, additional information like minimum and maximum values, default values, and whether they are mandatory or unique.

Uploaded by

Dheeya Nuruddin
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
1K views36 pages

Data Dictionary

The document describes the data dictionary for the Pizza Hut food-ordering system. It outlines the different databases that make up the system including sales revenue, customer, receipt, comment, report, menu upgrade, waiter, cashier, order, manager, payment, supplies, item, inventory, and customer information. For each database, it lists the data members (fields), their description, type, additional information like minimum and maximum values, default values, and whether they are mandatory or unique.

Uploaded by

Dheeya Nuruddin
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 36

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY

Sales Revenue
Database
Data Member

An item in the cataloque of products that are available


for purchase
by a custom
Additional
Type

Name

Description
Summation of Price of Items

Type

Information
Min:1

Total_sales
No_of_item
Item_price
Note

sold
Number or Units that the
customer will order
Quantity
of customer
payment
product for
consumption

Decimal
Byte
Decimal
String

Max:10,000
Min:1
Min:1 Max:256
Max:10,000
Min:0
Max:65000

or purchase by a customer
Default Value

Null
Null
Null

Mandatory?

Yes
0 Yes
Yes
No

Unique?

No
No
No
No

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY


System
Data Member
Name

An interactive and interdependent component


forming an
integrated set of elem
Additional
Type
Description

Name
No_orders_serve Title of the System
d
Count
of orders
served
Identifies
if the customer
record
Customer_record had
Briefaexplanation
of the
Description
system

Type

Information
Min:0 Max:

String
Byte
Boolean
String

65000
Min:0 Max: 256
True
False
Min:0orMax:
65000

ing an integrated set of elements and relationships which function as one.


Default
Value
Pizza Hut
Order Management

System
used for order entry and
processing

Mandatory?

No
0 Yes
0 Yes
No

Unique?

Yes
No
No
No

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY


Customer Feedback
This contains the comments and suggestion ofAdditional
the customers
database
Data Member
Type
Name
Information
Description
Type
Manager's note on
Min:0

Note
database
String
Comment
suggestion/comments
String
No_forms_answered Number of forms submitted Byte

Max:65000
Min:0
Max:65000
Min:1 Max:256

ustomers
Default Value

Null
Null

Mandatory?

No
No
0 Yes

Unique?

No
No
No

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY


Receipt
Data Member
Name

Receipt_no
Total_amount
Tax
Note

a piece of paper on which the things that you buy or the services that you pay fo
paid and the prices for each.
Additional Type
Information
Unique Identity
Type
Min:1
Unique
Identity
Decimal
Max:10000
Sum of prices of items
Min:1
delivered
Decimal
Max:10,000
percentage of total amount
Min:1
as tax
Max:10,000
Decimal
Min:0
Manager's note on database String
Max:65000

he services that you pay for are listed with the total amount
Default Value

Null
Null
Null

Mandatory?

0 Yes
Yes
Yes
No

Unique?

Yes
No
No
No

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY


Comment
Data Member
Name

Feedback from Customer


Description

Type

Customer_name Name
of customer
String
suggestion/comment
Comment
s
String

Additional Type
Information
Min:0 Max:

65000
Min:0
Max:65000

Default Value

Mandatory?

Unique?

Null
Null

No
No

No
No

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY


Report
Data Member
Name

Graphs and processed data


Description

Type

Sales_grpah
Payment_graph
Inventory_graph
Customer_infor
mation

Sales report
Payment report
Inventory
report
information
report

Image
Image
Image
Image

Additional Type
Information
Default Value

Null
Null
Null
Null

Mandatory?

Unique?

Yes
Yes
Yes
yes

No
No
No
No

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY


Menu
Upgrade
Data Member
Name

Changes made by management to the Menu


Description
Brief explanation of the changes

Type

Additional Type
Information
Min:0 Max:

Description
Name
Price

made to the menu


Name of new change
Quantity of payment

String
String
Decimal

65000
Min:0 Max:
65000
Min:1
Max:10,000

Default Value

Mandatory?

Unique?

New
Pizzaproduct
Hut Order Management
System
Null

No
No
Yes

No
Yes
No

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY


Waiter
Data Member
Name

One who serves at a table, as in a restaurant

Employee_no
Contact_no
Name
Address

Unique identity
Byte
Contact information of employee Byte
Name of Employee
String
Address of Employee
String

Description

Type

Additional Type
Information

Min: 0 Max: 256


Min:
Min: 0
0 Max:
Max: 256
65000
Min: 0 Max:
65000

Default Value

Mandatory?

Unique?

Null
Null
Null
Null

Yes
No
Yes
No

Yes
No
No
No

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY

CASHIER
Data Member
Name

The employee designated to receive and record payment


Description

Type

Employee_no
Contact_no
Name
Address
Order_status
Payment_status
Payment_metho
d
Total_payment
Change
Cash_received

Unique Identity
Contact information of employee
Name of Employee
Address
of whether
Employee
The
status
order has been
served
The
status whether payment has
beenmethod
received
The
of payment chosen by
customer
Total amount of value paid by
customer
The amount of cash returned to
customer
in excess
cash paid
The amount
of cashof
received
by
cashier

Byte
Byte
String
String
Enumerated
Enumerated
Enumerated
Decimal
Decimal
Decimal

cord payment
Additional Type
Information

Default Value

Min: 0 Max: 256


Min: 0 Max: 256
Min: 0 Max: 65000
Min: 0 Max: 65000
On Process, Served
Paid, Unpaid
Cash, Debit, Credit
Min: 0 Max: 10000
Min: 0 Max: 10000
Min: 0 Max: 10000

Null
Null
Null
Null
Null
Null
Null

Mandatory?

Yes
No
Yes
Yes
Yes
Yes
Yes
0 Yes
0 No
0 No

Unique?

Yes
No
No
No
No
No
No
No
No
No

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY

ORDER
Data Member
Name

The products requested by the customer


Description

Type

Order_no
Quantity
Wait_time
Time_order_plac
ed
Time_order_serv
ed
Special_instructi
ons

Unique identity
The
number
items ordered
the order
wasofplaced
and the time it
was time
served
The
the order was received by
the kitchenb
The
time the order was served by the
kitchen
Additional
instructions to kitchen
regarding order

Byte
Byte
Time
Time
Time
String

Additional Type
Information
Default Value

Min: 0 Max: 256 Null


Min: 0 Max: 256
hh: mm: ss
hh: mm: ss
Null
hh: mm:
ss
Null
Min:
0 Max:
65000

Mandatory?

Yes
0 Yes
0 Yes
Yes
Yes
0 No

Unique?

Yes
No
No
No
No
No

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY

MANAGER
Data Member
Name

The one who supervises the management of theAdditional


business Type
Description

Type

Information

Employee_ID
Contact_no
Name
Address

Unique
Contactidentity
information of
employee
Name of Employee
Address of Employee

Byte
Byte
String
String

Min: 0 Max: 256


Min:
Min: 0
0 Max:
Max: 256
65000
Min:
0 Max:
65000

ss
Default Value

Mandatory?

Unique?

Null
Null
Null
Null

Yes
No
Yes
No

Yes
No
No
No

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY

PAYMENT

The total value paid by customer

Data Member Name Description


The method of payment chosen

Type

Method
Cash_paid
Creditcard_no
Debitcard_no
Pin
Status
Change

Enumerated
Decimal
Byte
Byte
Byte
Enumerated
Decimal

by
customer
Total
amount of cash given by
customer
Unique identity
Unique identity
Security number
of card
Determines
whether
payment has
beenresidual
given amount returned to
The
customer in excess of payment

Additional Type
Information

Cash, Debit, Credit


Min: 0 Max: 10000
Min: 0 Max: 256
Min: 0 Max: 256
Min: 0 Max: 6
Paid, Unpaid
Min: 0 Max: 10000

Default Value

Null
Null
Null
Null
Null

Mandatory?

Yes
0 No
No
No
Yes
Yes
0 No

Unique?

No
No
Yes
Yes
No
No
No

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY

SUPPLIES
Data Member
Name

Materials purchased by the company to be used inAdditional


productionType
Description

Type

Information

Order_no
Weight
Expiry_date
Date_ordered

Unique
identityof the supplies
The heaviness
received
The date at when the supplies
will expire,
if they
The
date when
thewill
supplies
were ordered

Byte
Decimal
Date
Date

Min:
Min: 0
0 Max:
Max: 256
10000
DD-MM-YY
DD-MM-YY

ction
Default Value

Mandatory?

Unique?

Null
Null
Null
Null

Yes
Yes
Yes
Yes

Yes
No
No
No

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY

ITEM
Data Member
Name

An item in the cataloque of products that areAdditional


available for
purchase by a custom
Type
Description

Type

Information

Quantiy
Price
Description
Product_no

Number of items ordered


Value
of items ordered
Brief explanation
of the
item
Unique Identity

Byte
Decimal
String
Byte

Min:
Min: 0
0 Max:
Max: 256
10000
Min: 0 Max:
65000
Min: 0 Max: 256

ble for purchase by a customer


Default Value

Null
Null
Null

Mandatory?

0 Yes
Yes
Yes
Yes

Unique?

No
No
No
Yes

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY

INVENTORY DATABASE Contains data regarding the overall inventory of the restaurant
Data Member Name

Description

Type

Total_quantity
Raw_materials_used
Raw_materials_availab
e
Note

Number of raw materials purchased


Amount
of raw
raw materials
materials used
used from total
deducting
quantity
Short description of the payment item

Integer
Integer
Integer
String

e restaurant
Additional Type
Information
Default Value
Mandatory?
Min: 0 Max:
10,000
0 Yes
Min: 0 Max:
10,000
0 Yes
Min: 0 Max:
10,000
0 Yes
Min: 0 Max:
65,000
Null
No

Unique?

No
No
No
No

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY


Payment
Database
Data Member

Contains data regarding the payment history of the restaurant

Name
Amount_per_ite Description

Type

m
Total_quantity
Total_amount
Note

Byte
Byte
Byte
String

Amount purchased per item


Total
number
mulitplied
by of
theitems
pricepurchased
of the item (Total
amount the customers pay)
short description of the payment history

he restaurant
Additional Type
Information

Default Value

Min: 0 Max: 256


Min: 0 Max: 256
Min:
0 Max:
Max: 256
Min: 0
65,000
Null

Mandatory?

0 Yes
0 Yes
0 Yes
No

Unique?

No
No
No
No

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY

MENU
Data Member
Name

Description
Categories
Sub_items

Shows the items offered by the company for sale


Additional Type
Description
Type
Information
Brief description of menu
Min: 0 Max:
items
String
65000
Division of items offered for
Min: 0 Max:
sale
65000
String
Min: 0 Max:
Items under each category String
65000

Default Value

Mandatory?

Unique?

Null
Null
Null

Yes
Yes
Yes

Yes
Yes
Yes

PIZZA HUT FOOD-ORDERING SYSTEM DATA DICTIONARY


Customer Information
Database

Contains data regarding the customers of the restaurant

Data Member Name

Description
Short description of the

Type

Note
Information_content

customer
customersinformation
that the restaurant
possess

String
String

of the restaurant
Additional Type
Information
Default Value
Min: 0 Max:
56,000
Null
Min: 0 Max:
56,000
Null

Mandatory?

Unique?

No
Yes

No
No

You might also like