Computer Science Database Project

BY IN CS - Database, IB Computer Science Comments Off on Computer Science Database Project , ,

A small restaurant called “PaPa Burger” needs to hire programmer to build the system for the restaurant. They need to record all the transaction everyday. The Cash Receipt will be given to their customer with the following layout

************************************
“PaPa Burger Restaurant”

Inv No: _______________
Inv Date: ______________

2pcs Small Burger $4.90 … $9.80
2pcs Ice Lemon Tea $0.90 … $1.80

_____
T.O.T.A.L $11.60
Paid $12.00
Change $0.40

Thank you for your business
You’re special served by: HARTONO
**************************************

The Interface for cashier

The interface needs to made as simple as possible. Several users might be able to access the same menu, therefore a user authentication is required. When the user has successfully logged on, the user can input the order of customer, such as choose the food from drop down list, entering the quantity, and it will calculated automatically. The user will also enter the amount of money that the customer pay, then the change will also calculated automatically. The cash receipt will then appear on the screen – ready to be printed

The Interface for administrator

Administrator will have several menu, which is can input the type of the food, display the history of the transaction, create a report for the monthly or certain period transaction

Technical Requirements

The database will be MySQL and the software should be build using PHP with JavaScript/AJAX for optimization. Sample of the database structure will be as follows:

Cashier
IDCashier
CashierName
LastLogin
Remarks

Item
IDItem
ItemName
SellingPrice
Remarks

Transaction
InvNo
InvDate
Total
Paid
Change
IDCashier

Transaction_Detail
InvNo
IDItem
Qty
SubTotal




Comments are closed.