Free Essays on Autoparts Sales & Inventory Management Data Model

Abstract / Introduction: The selling of automotive aftermarket replacement parts is both a retail enterprise selling to consumers and a wholesale operation selling parts to repair shops and other resellers. In consideration of the diverse customer base, this data model will be developed so that sales of auto parts either retail or wholesale can be recorded and tracked electronically. In addition, stock inventory levels will be monitored electronically with this model and an automated stock replenishment mechanism implemented. Due to time constraints this model will be a stripped down version only pertaining to the sales and inventory functions. The current design does allow for further development and the addition of other components. Since the heart of an auto parts store is in its inventory of parts we will begin with an explanation of how the inventory is managed. By the use of the MinQuantity field in the Inventory table the system will be able to indicate a low stock level once the quantity in stock is equal to or less than the minimum quantity specified by the MinQuantity attribute. At this point a View for Inventory can be generated to display inventory items whose quantity levels are below their specified minimum. This Reorder_View can be used by the system to generate purchase orders to vendors whose contact data and address are stored in the table named ‘Vendor’. Just as the Inventory table contains all the attributes for any given part the Vendor tabled does the same for all vendors. To complete the description of the model that will be created we will now discuss the sales tracking process. Once a sale is made, a record of that sale is recorded in the Daily_Sales table. A transaction number to be associated with this sale will be generated then used as part of the identifier for this sale. The store number and part number are also part of this unique identifier. From this record a sales invoice/r... Free Essays on Autoparts Sales & Inventory Management Data Model Free Essays on Autoparts Sales & Inventory Management Data Model Abstract / Introduction: The selling of automotive aftermarket replacement parts is both a retail enterprise selling to consumers and a wholesale operation selling parts to repair shops and other resellers. In consideration of the diverse customer base, this data model will be developed so that sales of auto parts either retail or wholesale can be recorded and tracked electronically. In addition, stock inventory levels will be monitored electronically with this model and an automated stock replenishment mechanism implemented. Due to time constraints this model will be a stripped down version only pertaining to the sales and inventory functions. The current design does allow for further development and the addition of other components. Since the heart of an auto parts store is in its inventory of parts we will begin with an explanation of how the inventory is managed. By the use of the MinQuantity field in the Inventory table the system will be able to indicate a low stock level once the quantity in stock is equal to or less than the minimum quantity specified by the MinQuantity attribute. At this point a View for Inventory can be generated to display inventory items whose quantity levels are below their specified minimum. This Reorder_View can be used by the system to generate purchase orders to vendors whose contact data and address are stored in the table named ‘Vendor’. Just as the Inventory table contains all the attributes for any given part the Vendor tabled does the same for all vendors. To complete the description of the model that will be created we will now discuss the sales tracking process. Once a sale is made, a record of that sale is recorded in the Daily_Sales table. A transaction number to be associated with this sale will be generated then used as part of the identifier for this sale. The store number and part number are also part of this unique identifier. From this record a sales invoice/r...

World Hunger Essay

World Hunger Essay World Hunger Essay World hunger essay An estimated 24000 people die from hunger so a world hunger essay should start by pointing out that hunger is an important issue in third world countries. A global problem A good way to start a world hunger essay is to give a birds eye view on the issue of hunger by referring to hunger statistics the world over. It makes sense to start a world hunger essay with statistics from countries that are most vulnerable to food shortages. One of the greatest anti-hunger advocates - Sir John Boyar examined how hunger is a thorn in the side of all Third World counties and tried to offer solutions as the director-general of the UNs Food and Agriculture Organization. One of the first things we have to do he said is to stop viewing food as any other commodity and to see it as an essential to life. Move over Im famished! A world hunger essay can also examine some of the worlds most devastating famines and how they could have been avoided. Develop the topic After giving the statistics the next thing your world hunger essay should do is to examine the causes for hunger and starvation. These can be as diverse as:Large population Free trade Viewing food as a means to earn money rather than to sustain life Ending on a hopeful note How can the problem of world hunger be solved? End by offering possible solutions to the problem. What active steps have been taken by the government of various nations to fight world hunger? What is the United Nations doing to get food for the needy? These are some of the points a thought provoking world hunger essay should touch upon. Lastly a world hunger essay would do well to analyze some sociological theories on dependency that can change the face of world hunger and make it smile. Farmers from the third world should be discouraged from sending all their produce to other countries for profit. The world would fare better if everyone realized that feeding the hungry is more important than money in the bank. Since a starving nation cannot be a productive one. These are some of the points to be covered in a good world hunger essay.