Thursday, November 29, 2012



 This post is created as a requirement of MIS Course, Autumn Semester, MBA, Batch of 2014, Vinod Gupta School of Management, IIT Kharagpur

# The work is done by Koyel Dutta (12BM60080) and Hitarth Saini (12BM60077)
The required deliverable of the project have been explained below :

Tata Steel is looking for an original idea that will use any aspect of digital technology (cloud, mobile, Android, IoS etc ) to create a application or platform that can be integrated with the strategic management requirements of the company. Since this is an ideation contest, no software need to be built but paper must contain the following sections.

  1. Identify a need or a gap in the current management architecture of Tata Steel. Information available in the public domain can be used for this purpose.
  2. Propose a solution that will show how the current gap can be closed or narrowed significantly
  3. If possible give examples where a similar solution has or is being implemented.
  4. List benefits -- economic or otherwise -- that will accrue to the company if it is implemented. Also identify potential problems or difficulties that need to be guarded against.
  5. Provide  rough estimate of costs including people costs that the company would have to incur as a one time expense and as a regular expense.

The link for the presentation is provided below :::



Thursday, September 20, 2012

Requirements for Aniket Sarkar(12BM60081)


                             
Canteen Feedback System for IIT-Kharagpur Students….

Develop an application to receive feedback from students and visitor of the IIT Kharagpur campus regarding the food available in various canteens and messes.

The system should have the following structure…



    Basic Requirements:
  1. Users without log-in or the first time user should be redirected first to the user registration page.
  2. Users without proper log in details should be alerted and asked to input the correct details.
  3. Once the registration is completed the customer should receive an email containing all details entered by him.
  4. The details to be entered in the during Registration are : Name,Gender,Email ID,Contact Number.
  5. The contact number field should validated.
  6. The Email ID field should be validated.
  7. The fields Name,Department,Email ID,Gender,Contact Number must be filled by the application user.
  8. Once registration is completed the user should be redirected to the LogIn page.
  9. The login page should check for username and password validity.
  10. The user once logged in should be redirected to the canteen selection page.
  11. This page should contain option of selecting a canteen from:
    1. MMM
    2. Lallu
    3. Tikka
    4. Veggies
    5. VS Hall
  12. Depending on the canteen selected the food items available should vary.
    1. MMM canteen should provide 
      1. Vegetarian
      2. Non vegetarian
      3. Snacks
      4. Beverages
    2. Lallu should provide
      1. Juices
      2. Fried Maggi & Specialities
      3. Chai & Bournvita
    3. Tikkas should provide
      1. Chai & Pakode
      2. Bread Omelettes
      3. Chips and Cold drinks
    4. Veggies should provide
      1. Chai & Pakode
      2. Bread Omelettes
      3. Chips and Cold drinks
    5. VS hall should provide
      1. Chai & Pakode
      2. Bread Omelettes
      3. Chips and Cold drink
  13. Other fields in this page are :Frequency , Order items
  14. The user should then be asked to give feedback.
  15. The user should receive an email after feedback is recorded.
  16. After giving feedback the user should be redirected to the home page.
Additional Features:
  1. The users should not be able to access the feedback or canteen selection pages if not logged in.
  2. The users should in fact not be able to see these pages unless logged in.
  3. The navigation from Registration -> Login -> Canteen Selectio -> Feedback -> Home page should be carried out automatically.
  4. The users should be able to either register(for new users) or log in (for existing users) from the home page.
  5. Since it is a feedback page customers should feel secure about the comments given.


The developed application is located here.

Customer certification:

Not all of the features mentioned have been implemented correctly. Most of the basic utilities are there but a few validations and checking and also the most important Log In feature has not been implemented. Please check these utilities.

Saturday, August 4, 2012

System Architecture - A conversation

Me: Mom really you cannot just expect the computer to be able to understand and do everything magically. You need to talk to it properly. N by talking I don’t mean literally.
Mother: I am not an idiot ok , just because you did some computer engineering thing you think you know better.
M: No Ma , I was just saying that it takes time for these PF queries and all to be taken care of cause this is no just a bank deal , it’s about the company and its database and architectural system.
Mother: How does the structure of the company’s building come into the picture here?
Me: Not that architecture ma JJ..i am talking about system architecture as in how that computer that the guy at finance has it connected to the actual data in the company.
Mother: If he is the guy who is supposed to handle these things why doesn’t he have the data on his machine?? This is just laziness.
Me: Arre no Ma J.. see like in your core banking system you can access the actual data of any account from your machine no matter which branch the account is in , it’s the same.
Let me see if I can explain it to you a little.
See like when we have a little fever we simply go to a general physician cause he has all the information or knowledge needed and also the authority to check and give me medicine – that is in a nut shell a 1-tier architecture.1 man - or in the system’s case ‘Machine’- for everything both the data and the applications that are working on it.

                                                             
But imagine with the number of people coming to see trusted old Doc Banerjee he would never ever have been able to survive if there wasn’t Shankar da.
So , Doc checks the patient cause he has all the knowledge  – data - and Shanti di gives the medication, injections  n all – so application.
That’s 2-tier architecture. Application and data are separated J
Mother: Ok so how many tiers are there???
Me: Well in reality the systems are normally multi-tiered. Lemme elaborate
Say now like Shanti di there are others too working for docs and they have an idea of a particular medicine. Now if that medicine needs to be changed, then all of them have to be informed !!!

                                      
Mother: That would be difficult.
Me: Exactly so docs use the prescriptions as the medium. All the basic calculations are in the prescriptions only and the meds are given by shops.
So , in effect in a 3-tiered architecture we have a client machine , that only displays stuff and in the back we have a data server and an application server which does the actual manual work. This all is connected by a WAN.
Mother:  What is a WAN now????You keep throwing jargons at me.. L
Me: No Mom , see you don’t know WAN cause it cannot be used widespread , after a certain limit say 1000 people in one area. So we use the “INTERNET” for all these things- making it even simpler. So no need for any application at all for the clients , simple web browsers are used and just add a web server at the organizational end- much like the reception people who guide the patients to the doctors depending upon their sicknesses. J
Mother: Ok n I know why the machines in the bank have firewalls so that people from outsider cannot misuse the important information , kind of like the medical files and lockers which are strictly confidential.
Me: Kudos Ma!! J

                                                
So now we have the web server taking info from the client web browsers and translating it to the applications server needed and the application server then using the data server to solve the request. A lot of data transfer is no longer happening over the wires and so it’s faster.
Nowadays they use the ERP system and a Integrated corporate database so that all the data and applications are together and also all the applications can talk to each other well.
Mother: Why is that needed?
Me:  If is sit you next to someone who speaks hindi , you will both stop talking permanently with your extremely bad hindi vocabulary , right? So that way it’s better to keep applications which are compatible. J
Mother: That’s so easy!! So tell me now then why if the system is so efficient is the guy taking so long for the PF results? But more importantly how come you got such less marks in BTech??
 Me:  Hey!! Where did I come in here? No one ever thought of explaining it to me like this , now , did they?? JJ