Order management system for Maggi !

FMCG

Ours is a Fmcg company which produces noodles,ketchup and soups. For better inventory management and control we require a software. We plan PDA for all the salesforce who basically till now were confirming the order via telephone, we now plan to have real time data availble. This is what we require

1. An id for all the salesforce with unique password so that only they can acess their account apart from company personnel. An id for all three products . also id for allthe customers should simultaneously get cretaed in our datbase as the sales man confirms the order. An id for all our existing customers should be there.

2. Each employee should be able to acess central depot before placing or conforming the order

3. Real time availbity of data on all id.

each product id will show stock which is ordered , cancelled , availble.

consumer id will show their last order , how long ago it was, their total order till too date(for all three products seperately) and also how much they have cancelled(procuct wise), to which employee they have given order

employee id will show total amount of order they have been able to get(product wise) , how much of it has been cancelled(product wise) , from whom all they have taken order, what was the last order taken by them.

4. Before confirming the order the employee should be able to see the central depot for the availbility of the product and only then confirm the order. the amount should automatically get deducted from product id. if their are any cancellations it should get added back automatically.all other id should get updated accordingly

5.the sales manager in the office should have access to central depot and all the ids they should be able to make any changes. they should thus have an id and password. for eg they should be able increase the inventory if new batch has come in .

6. sale smanager should also be able to see the order in terms of real order , cancelled order , pending order and completed order.

OOPs

My sister called me up yesterday night as she had some doubts about oops that is object oriented programming. It is really amusing, that now she is coming up to me for IT related topic. This is how our conversation goes
Kari: Hey sis
Me: Hi! Long time no call?
Kari: Listen leave all that i really need a favour from you ........could you explain me object oriented
Programming asap
Me: Yeah sure oops is really simple
Kari: OOPS? what is that
Me: you really don’t know anything about it. That is short form for object oriented programming .
Kari: See ...could you help me out please
Me: Okay do you know about data modelling and entities attribute s and all that
Kari: Yeah I know that in fact I found it very interesting
Me: okay oops is quite similar to that.
Kari: oh
Me: In it what you first have is class .. it is collection of similar objects, instances, events
Kari: Is it something like entities
Me: Yeah exactly and in same way it has attributes
Kari: Then it is same as data modelling
Me: Don’t jump to conclusions ...... the difference in oops is that it has methods
Kari: Methods?
Me: They are simply instructions coded ones like in c++ or java that will have an impact on your objects
Kari: But why have them?
Me : See in data modelling rather than having to pass restrictive SQL statements to perform functions why not have methods attached . So rather than limiting yourself to CRUD that is create read update delete operations why not have flexibility in employee class in terms of Recruit Promote Terminate Appraise etc
Kari: Oh now I get it is that it
Me : Nope now you have Inheritance and Polymorphism
Kari: Now what is that?
Me: Inheritance is where you have a parent class and sub class and the sub class inherits the behaviour of the parent class like for example Teachers will also have name age sex and students will also have same attributes.
Kari: And what is Polymorphism
Me: It is when same method gives different result for different classes for example promote for teachers would mean on term of designation and also salary but in terms of student it means standard
Kari: Hope that is it
Me: yupp thats about it
Kari: thanks sis see you later will tell you then what this was all about

Tomorrow Private Ltd

Systems Architecture made easy

My sister has just started with her graduation in Bsc. One of her subjects is computer science. In that they are currently covering systems architecture .Even though she had computer science in her boards I was really surprised that she still was not clear on many areas. I was speaking to her yesterday night when we discovered that both of us were covering the same topics
Me: Hi! Kari
Kari: Hi
Me: How is college , I hope you are enjoying yourself,
Kari: Yeah I am after school this feels like freedom
Me: I know exactly how you feel ….hope studies are going well too
Kari: Yeah except comp science everything is great
Me: Hey I am also having that subject but I find it pretty good
Kari: Trust me sis you don’t have systems architecture so be happy
Me: Well I am doing that only, Let me try and explain you
Kari: Please I always knew more than you in computers
Me: At least let me try
Kari: Ok I am all ears
Me: You know all about hardware and software right
Kari: Of course what you take me for
Me: Ok so do you know about applications and platform?
Kari: Nope you got me there all I Know about platforms is that it is something like vista or Linux
Me: You are right in a way, See it is your operating system that sits on your hardware, together it is called platform
Kari: I lost you there
Me: Your hardware without operating systems is dead and together it is a platform for applications to operate in. For example you have vistas on your hardware, in it you have one application called word processor working.
Kari: Or it can be excel sheet or something
Me: Exactly so platforms which are connected to each other so as to allow flow of data between various applications running on them is system architecture.
Kari: Got it, but then you have something like two tier and three tier
Me: yeah
Kari: Have you done that it went over my head in the class
Me: Yeah I can explain you that. First we have single tier in that we have data and application on the same computer.
Kari: Something like what we have in our laptop.
Me: Exactly. Now what if you have multiple users?
Kari: Oh we can have dumb terminals
Me: Yeah but then that central computer gets bogged down and the speed is slow .
Kari: Then what do we do
Me: What if we separate the data and the application
Kari: Can we do that?
Me: Yes have all the data at one place and have applications on user computer which are all connected by LAN
Kari: hmmmmmm
Me: This is what two tiers is
Kari: Next we have three tiers
Me: Very smart. Yes to overcome the problem Geographic dispersion of employees
Kari: Carry on this is getting interesting.
Me: See in three tiers you further separate your application. Upfront you have your interface where the client sits and at the background at one place you have all your processing.
Kari: But are we not going backward to single tier
Me: Not exactly because earlier it was the interface which used consume a lot of processing.
Kari: Ok
Me: In multi tiers we go a step forward. We use the web so we don’t have the problem of updating interfaces now and then. Here, a web server is placed between the application server and the user. Your interface or client server is replaced by browser.
Kari: Is that it
Me: Yeah that’s about it
Kari: Wow thanks sis really appreciate it