1
AUTOMATIC INVENTORY CONTROL SYSTEM
Mohammad Mohsin Rumi
07141003 [Old ID: 02201070]
Department of Computer Science and Engineering
May 2007
BRAC University, Dhaka, Bangladesh
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
Guidelines and tips
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
Understanding the Impact of Climate Change on Agriculture, Thesis of Software Project Management
The effects of climate change on agricultural productivity, focusing on extreme weather events, changing precipitation patterns, and the potential for adaptation strategies. It provides insights into the challenges farmers face in adapting to these changes and the role of scientific research in developing sustainable agricultural practices.
Typology: Thesis
2017/2018
1 / 85
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Understanding the Impact of Climate Change on Agriculture and more Thesis Software Project Management in PDF only on Docsity!
AUTOMATIC INVENTORY CONTROL SYSTEM
Mohammad Mohsin Rumi 07141003 [Old ID: 02201070]
Department of Computer Science and Engineering
May 2007
BRAC University, Dhaka, Bangladesh
Supervisor -
Sayeed Salam, Ph. D. Chairman, Department Of Computer Science and Engineering BRAC University[URL – www.bracuniversity.net] 66 - Mohakhali, Dhaka – 1212, Bangladesh
Table of Contents
- 1.0 Introduction No Topic Name Page
- 2.0 Environment Entity
- 2.1.1 Pharmacy
- 2.1.2 Pharmaceutical Company
- 2.1.3 Raw Material Supplier
- 3 .0 Hierarchy
- 4.0 Current Scenario
- 4.1.1 Current Scenario Analysis
- 4.1.2 Problems of Current Scenario
- 5 .0 Proposed Model
- 5 .1.1 Complete E-R Diagram of the New Model
- 5 .1.2 E-R Diagram between Pharmacy and Patient
- 5 .1.3 E-R Diagram between Pharmacy and Pharmaceutical Company
- 5.1.4 E-R Diagram between Pharmaceutical Company and Raw Material Supplier
- 6 .0 Block Structure of Proposed Model
- 7.0 Logic that will be Implemented
- 8 .0 Some Important Points to Focus
- 9.0 Comparison between Old Model and New Model
- 10.0 Our Realization
- 11.0 Conclusion
- 12 .0 Complete Code
- 13 .0 Figure List
- 14 .0 Bibliography
Keyword: Pharmacy, Pharmaceutical Company, Raw Material Supplier, Email, Message Exchange System 1.0 Introduction An Automatic Inventory Control System is an integrated package of software and hardware used in warehouse operations, and elsewhere, to monitor the quantity, location and status of inventory as well as the related shipping, receiving, picking and put away processes. In common usage, the term may also refer to just the software components. An inventory control system may be used to automate a sales order fulfillment process. Such a system contains a list of order to be filled, and then prompts workers to pick the necessary items, and provides them with packaging and shipping information. Real time inventory control systems use wireless, mobile terminals to record inventory transactions at the moment they occur. A wireless LAN transmits the transaction information to a central database. Physical inventory counting and cycle counting are features of many inventory control systems which can enhance the organization. 2.0 Environment Entity In this thesis, we have there entities. They are Pharmacy, Pharmaceutical Company and Raw Material Supplier. There is another entity which is not a part of our project but not less important. Actually we are talking about Patient i.e. sick person for whom drugs have been made. We all know when a person becomes ill s/he goes to either local pharmacy or in serious case admits in the hospital. S/he definitely needs to take drug, as recommended by the doctor, to cure up from the disease. 2.1.1 Pharmacy In this paper we are calling those shops as a pharmacy from where people buy drugs as their need. Actually it’s a layer or media between pharmaceutical company and patient. A patient never goes to a pharmaceutical company to buy drugs. Again a pharmaceutical company is not a retail shop. 2.1.2 Pharmaceutical Company It’s a layer between pharmacy and raw supplier. A pharmacy never produces drugs for patients. They don’t have equipments to make drugs. Pharmaceutical company revolves around people and medicines with special emphasis on the manufacture of medicines, their supply, appropriate use and effects. The ultimate concern of pharmaceutical company is to ensure that the patient receives the appropriate medicines and benefits from the proper use of these.
4.0 Current Scenario Figure 02 This is the figure of current scenario. From Raw Material Supplier raw material comes to Pharmaceutical Company. Then Pharmaceutical Company processes those raw materials and makes drugs. Then delivery those drugs to the local pharmacies and from those Pharmacies, people buy those drugs. 4.1.1 Current Scenario Analysis We will consider only a segment of the total scenario for our discussion. And from that we will find how much ineffective the current process is.
Figure 03 In this scenario, Medical Promotion Officer is keeping an important role. What we say in our every day life, pharmaceutical companies appoint some medical promotion officers to sell their products to the local pharmacies. Now what they do, move from this pharmacy to that pharmacy, show what are the products his/her company makes and as requirement of pharmacy personnel, s/he sells to him. In many cases they also collect the request for drugs and this is happened, when they don’t have available drugs with them or don’t carry the drugs. 4.1.2 Problems of Current Scenario Problems that we find out are as follows:
- Dependency: Company totally needs to depend on the Promotion Officer. And if we think our-self, this is really a serious problem. That person is reflecting the company image to the local pharmacies. Actually company is depending on his/her appearance. If s/he is able to make understand about their product to the buyers then it is ok but s/he fails company has to suffer. Again the honesty of promotion officer is another point to think.
- Slow: The current process is really slow. Because a person [Medical Promotion Officer] has to move from here to their and then sell the drugs as requirement. We
pharmacy never depends on a single pharmaceutical company for its supply of drugs. Same thing happens for pharmaceutical company and raw material supplier. 5.1.2 E-R Diagram between Pharmacy and Patient If we look at following figure [Figure 03] then we will find relation between pharmacy and the patient in our process. The earlier figure was the complete E-R Diagram of the whole process. Now we are segmenting it and move to deeper of our design. Figure 05 In the relation, we can see that we have two entities. (a) Entity: Patient Attribute: 1. Name
- Sex (b) Entity: Drug/s Attribute: 1. Name
- Drug ID [Primary Key]
- Supplier
- Price
- Quantity
As patient buys drugs from the pharmacy so we use drugs as an entity rather than pharmacy. In the process Drug ID is the primary key. 5.1.3 E-R Diagram between Pharmacy and Pharmaceutical Company The figure [Figure 04] is mentioned below: Figure 06 In the relation, we can see that we have two entities. (a) Entity: Pharmacy Attribute: 1. Name
- Reg. No. [Primary Key]
- Address
- Email (b) Entity: Pharmaceutical Company Attribute: 1. Reg. No. [Primary Key + Foreign Key]
- Name
- Address
Attribute: 1. Reg. No. [Primary Key + Foreign Key]
- Name
- Address
- Email In the entity, Pharmaceutical Company we have the primary key ‘Reg. No.’ i.e. register number of that pharmacy. And in Raw Material Supplier ‘Reg. No.’ i.e. register number of the Raw Material Supplier, is the primary key. 6.0 Block Structure of Proposed Model Figure 08 This is the block structure of our proposed model. We are putting a central mail server so that every single company who are involved in this field can take the advantage of the new technology. Other than that every one has their local database. Now a company can use their personal mail server but that is option and is not important for our project. Every company will send or receive their mails by using that mail server.
7.0 Logic that will be Implemented For sending mail message we have developed a condition and every time when a sell or delivery will be made, the condition will be checked and based on that mail message will be sent to the desired company. The logic is very simple. X → Limit of a Product Y → Current Status of that Product If Y < X then Send a Message to its Supplier That is, X is the boundary of a product that must be maintained by entity of this scenario. Y is the current status i.e. after a sell or delivery of that product what is the status. When Y will become less than X then a message will be sent to its supplier for a purchase request. Now the company will make a contact with the sender about the quantity and also assurance that the drugs or product is required to continue the business. 8.0 Some Important Points to Focus To develop this model we also have to focus some important points. Because if we neglect them then we think for time being it may be possible develop the model but in the long run the project will fail. The points are:
- New System is developed based on Internet Technology. So until we get the complete implementation of this technology in our society the new model is not feasible.
- As we have told in our earlier point that for time being it may not feasible but it is not impossible.
- New system totally depends how we adopt new technology i.e. our eagerness to accept the change in our day to day life in technology side. We should remember if we keep our self back we can never move to forward place. 9.0 Comparison between Old Model and New Model If we compare the old model with the new model we think every one must have to say that, wow it’s really a good model. Before developing this model we have to make some analysis so that we can find the weakness of our model but it’s our pleasure to say that we don’t find any limitation or drawbacks of our model. We also tried to enhance the current process so that every one involved in this field get the benefit of our proposed model. 10.0 Our Realization While developing this model for our project we have found that this model can be implemented in a collaborative business environment.
12.0 Complete Code
/*******************************Pharmacy Folder*************************/ /**********************************************************************/ /Pharmacy-Login.php/
Green Life Pharmacy
GREEN LIFE PHARMACY
User Name
GREEN LIFE PHARMACY
Select an Action from the List
Go Back
/New-Drug.php/
Keep Record of New Drug
GREEN LIFE PHARMACY