Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Inventory Control Project Documentation – A school project based on managing and tracking stock efficiently using simple methods to reduce errors and improve organization.
Typology: Assignments
1 / 52
This page cannot be seen from the preview
Don't miss anything!
OpenOffice Base Project Database Table Structure
Screen Shot of Table Structure Relationship Design & Structure Screen Shot of Query Screen Shot of Forms Report
taken. For instance, in a departmental store, many items are kept and sold. When these items are sold out, the store orders for more quantity so as to meet the customers' demands. In order to successfully manage the departmental store, the authorities have to decide about various things like (i) What all items are being sold every day and how much stock is left for them. (ii) If the stock for a particular item is below reorder level i.e., the minimum stock maintained for an item, then the same item is reordered. (iii) When an item is sold, the quantity sold out is subtracted from the Stock in Hands i.e., the current stock so as to keep it updated. (iv) Similarly, if some quantity for an item is purchased, then this quantity is added to Stock in Hands to keep the stock updated. In order to make such decisions, the information related to inventories i.e., the products and their transactions is stored in files. Following sample project is based on these guidelines. In this project, we have created three tables namely Items, Supplier, and Transactions table design of these tables are as follows: ** Source : Google
Table Structure Table Name : Item Field Specifications Field Name Field Type Itemcode BigInt [BIGINT]; Primary key ItemName Text [VARCHAR] ; ItemDescription Text [VARCHAR] ; Price Decimal [DECIMAL]; StockAvailable Number [NUMERIC] ;
Table Name : Transactions Field Specifications TranID BigInt [BIGINT]; Primary key TrDate Date[DATE] PrID Number [NUMERIC]; TranType Text [VARCHAR] ; Quantity Number [NUMERIC];
