Automate Supermarket Management System with Group Project Requirement

Programming II Super Market Management System

Problem Statement To automate Super Market Management system

Important The project to be done with a group of three students All project members must participate actively on all part. Submission date: A week after your final exam Defense dates: To be announced Deadline must be respected Project must be done according to the specification

Features Files The system must support at least five file. 1. Item file, 2. Order 3. Order detail 4. Purchase 5. Purchase Detail

Features Item file itemId:- unique id for an item(auto increment integer field. Must be generated automatically by the system) name:- Description(or name) of item location:- place where an item is stored The store contains a lot of cabinet identified by a single letter(A,B,C ) Each cabinet is partitioned in to 10 cells identified by a single digit(0, 1, 2, ) Therefore each cell is identified as (A0, A1, A2, ,B1, B2, ) containing one type of item unitPrice: selling Price of an item determined by the latest purchase. Discount:- discount for an item avaliQuantity:-available quantity for an item in supermarket. Updated everytime order and purchase is made

Features Order: invoiceNo :- a unique id for an order(auto increment integer generated by the system) date:- date of sale, customerName: name of customer

Features OrderDetail: orderId:- unique id for a particular item sold(auto increment integer generated by the system) Invoice: invoice of order(reference to order) itemId:-the id of the item being sold, quantity:-no of item sold, unitPrice:- unit price of item being sold(obtained from item file), discount:- discount of item being sold(obtained from item file),

Features Purchase: invoiceNo :- purchase invoice number date:- date of purchase, supplier: name of supplier Note: Only registered item in item file can be bought

Features PurchaseDetail: purchaseId:- unique id for a particular item being purchased(auto increment integer generated by the system) Invoice invoice of purchase(reference to purchase) itemId:-the id of the item being purchased, quantity:-no of item purchased, unitPrice:- unit price of item being purchased Note: the selling unit price of an item is determined during purchase by accepting the profit factor from the user. The unit price field of the particular item in item file must be updated then.

Functionalities(Expressed in terms of Menu)-Main Menu MAIN SWITCH BOARD 1. Item 2. Order 3. Purchase 4. Report 5. Exit

Functionalities(Expressed in terms of Menu)-Sub Menu Item 1. Add New Item 2. Search By item Id By Name By Location 3. Edit 4. Back To Main Switch Board 5. Exit 1. 2. 3.

Functionalities(Expressed in terms of Menu)-Sub Menu Purchase 1. New Purchase //purchase and purchase detail file required 2. Search By Purchase Id By InvoiceNo By Date By Item Id 3. Edit 4. Back To Main Switch Board 5. Exit 1. 2. 3. 4.

Functionalities(Expressed in terms of Menu)-Sub Menu Order 1. New order //must allow user to print real receipt in appropriate format//order and order detail file required 2. Search By Order Id By InvoiceNo By Date By Item Id 3. Edit 4. Back To Main Switch Board 5. Exit 1. 2. 3. 4.

Functionalities(Expressed in terms of Menu)-Sub Menu Report 1. Item Inventory //total in, total out and net by item 2. Order Total Order of the day by item Total Order of the day for particular item Total Order By Item Total Order 3. Purchase Total Purchase of the day by item Total Purchase of the day for particular item Total Purchase By Item Total Purchase 4. Profit Total Profit By Item 2. Total Profit 5. Back To Main Switch Board 6. Exit 1. 2. 3. 4. 1. 2. 3. 4. 1.

Strategy For memory efficiency only the search index fields to be loaded in to the array(memory). Your application should allow search by name and itemid. Therefore only this fields from item file and file position reference should be loaded in to memory. All other files will be opened at the beginning but not loaded in to memory as they are not used frequently.