For the system’s maintenance, we require the Manager to create a back-up of the database
every day after office hours. To help facilitate this activity the system uses the mysqldump.exe, a built in
application of MySQL. After office hours, the manager is required to click the back-up button to create
an SQL file that will contain the details of the database the POS inventory is using.
The system implements user login and password encryption to ensure that the proper users will
see the screens they are authorized to see. Details about the users will be managed by the Manager
through the functionality included in the application.
Subject Object Action Constraint
Kitchen Staff Cooked_food record Read, Modify None
Manager Cooked_food record Read, Insert, Modify, None
Delete
Manager Department record Read, Insert, Modify, None
Delete
Manager Employee record Read, Insert, Modify, None
Delete
Manager Grocery record Read, Insert, Modify, None
Delete
Kitchen Staff Grocery record Read, Modify None
Manager Inventory_slip record Read, Insert, Modify None
Manager Item record Insert, Delete None
Manager’s application Leftover record Read, Insert, Modify Leftover for the current
date
Cashier’s application Order_line record Insert Upon ordering only
Manager Order_line record Delete Void orders only
Cashier Purchase record Insert Purchase due only
Manager Selling_price record Read, Insert, Modify None
Manager User record Read, Insert, Modify, None
Delete
The system will be completely turned over to the NATCCO IT Department together with user
manual and other documentations Maintenance requests will also be handled completely by the IT
Department of the organization.