SUPERMARKET DATABASE MANGEMENT SYSTEM
A program written in C language intended to function as a database management system for supermarkets.
It doesn't require an interaction with any RDBMS software but still capable of synchronizing data by utiizing files as databases.
Being written in a low level language which is closer to machine code it has a very fast performance and minimal execution time.
It utilizes 3 files for it's proper execution namely database.txt, invoice.txt and cache.txt which are generated automatically when for the first time backup or synchronization is performed.
database.txt file stores the SN, ID, name, MRP, discount and quantity of all the products.
invoice.txt file stores all the invoices generated.
cache.txt stores an integer which indicates the number of products existing in the database.txt file.
For adding a certain product the user is asked to enter it's ID, name, MRP, discount and quantity.
Products are displayed with their corresponding SN, ID, name, MRP, SP, discount and quantity where SN and SP are generated automatically from discount and MRP (SP=MRP-MRPdiscount0.01)
For generating an invoice the user is asked to select a certain product by it's SN then enter the quantity.
The users can continue adding products to the invoice as long as the they want then they are asked to enter the customer's contact number and the invoice is generated.
The generated invoice contains customer's contact number, date and time, SN, ID, name, MRP, discount, quantity, amount and total amount calculated.
The quantity of a certain product in the database is reduced according to it's quantity added in the invoice.
For removing a certain product the user is asked to select it by entering it's SN.
An option is provided to synchronize the data with the database which first backs up data to the database then loads data from the database consecutively.
NOTE: It's recommended to synchronize the data after removing a certain product and before removing another product otherwise undesired changes may be reflected in the data.
LOADING DATA FROM THE DATABASE
ADDING PRODUCTS
DISPLAYING PRODUCTS
GENERATING INVOICE
data has been backed up to the database.txt file
REMOVING A PRODUCT
SYNCHRONIZING DATA WITH THE DATABASE
generated invoices have been backed up to the invoice.txt file
an integer has been typed on the cache.txt file which indicates the number of products existing in the database.txt file
