Sunday, March 23, 2008

Order Management System - Assignment

OBJECT: To develop a small system that will help the company to track orders as they are picked up by the sales force.

Specifications: We are a FMCG company with pan-India presence. We have products in six categories which are soaps, shampoos, detergents, surface cleaners, deodorants and hair gel. We are launching a new pilot project in delhi with the objective of making our order management more effective. The project entails empowering sales managers with PDA, which will enable them to transmit the requirements of distributors in real time. This PDA will be backed by an application with following specifications-

  • Since it is going to be used by sales persons who are usually not tech savvy, the application should be user friendly.
  • It should be an online application.
  • The database should get updated as and when a distributer places an order with the sales person.
  • If the required quantity is not available then the sales person should get a message " out of stock ".
  • The front end of the application should have the following fields-
  1. Product
  2. quantity
  3. unit price


Inventory View




Order Form

Order specification

OBJECT: To develop a small system that will help the company to track orders as they are picked up by the sales force.

Specifications: We are a FMCG company with pan-India presence. We have products in six categories which are soaps, shampoos, detergents, surface cleaners, deodorants and hair gel. We are launching a new pilot project in delhi with the objective of making our order management more effective. The project entails empowering sales managers with PDA, which will enable them to transmit the requirements of distributors in real time. This PDA will be backed by an application with following specifications-

  • Since it is going to be used by sales persons who are usually not tech savvy, the application should be user friendly.
  • It should be an online application.
  • The database should get updated as and when a distributer places an order with the sales person.
  • If the required quantity is not available then the sales person should get a message " out of stock ".
  • The front end of the application should have the following fields-
  1. Product
  2. quantity
  3. unit price

Monday, March 3, 2008

First compiler

Compiler

A compiler is a computer program (or set of programs) that translates text written in a computer language (the source language) into another computer language. The original sequence is usually called the source code and the output called object code.

The most common reason for wanting to translate source code is to create an executable program. The name "compiler" is primarily used for programs that translate source code from a high-level programming language to a lower level language (e.g., assembly language or machine language).

A compiler is likely to perform many or all of the following operations: lexical analysis, preprocessing, parsing, semantic analysis, code generation, and code optimization.

Software for early computers was exclusively written in assembly language for many years. Towards the end of the 1950s, machine-independent programming languages were first proposed. Subsequently, several experimental compilers were developed. The first compiler was written by Grace Hopper, in 1952, for the A-0 programming language. She is also well known for her important role in the development of the COBOL programming language (which is still in widespread use for business applications), including the development of the first COBOL compiler. COBOL was an early language to be compiled on multiple architectures, in 1960. The FORTRAN team led by John Backus at IBM is generally credited as having introduced the first complete compiler, in 1957.

Tuesday, February 19, 2008

SE assignment three- Creating a online database

Creating an Online Database Management System.

You can make use of the shared online RDBMS provided by Zoho. (Link:http://db.zoho.com).

Zoho gives various options to create Databases. we can directly import tables from excel or we can create a database directly on zoho. To make things easy i have imported two tables from excel spreadsheet.

When creating from excel spreadsheet, we can directly copy and paste it from the spreadsheet, and name our table and database. Once our table is ready, we can edit the table to customize it to suit our purpose.

Once we have completed the above mentioned steps, we can generate reports or extract the information we want from our database.


Click here to see the example database

Monday, February 11, 2008

SE assignment-2, part-2

http://wikimapia.org/#lat=28.557414&lon=77.176723&z=18&l=0&m=a&v=2

Un-normalised form

1

Roll No.

2

Name

3

E-mail Address

4

Phone No

5

Late fine outstanding

6

Book title

7

Book author

8

Book ISBN

9

Book price

10

Library catalogue no

11

Quality of copy

12

Date issued

13

Date to be returned

Student

Roll No PK

Name

E-mail id

Phone_no

Late fine outstanding

Book

Book ISBN PK

Library Catlogue no FK

Book title

Book author

Book Price

Book List

Library_catalog_no PK

No of qualities

Quality of the book

Issue details

Issue id PK

Roll no Fk

Library catalogue no FK

Issue date

Return date

Sunday, February 3, 2008

System Architecture

One day when I was sitting at home in my room, my cousin keshav studying in class xth came running to me and tole me that they had a special lecture on system engineering in school delivered by a guest lecturer working in one of the top three IT firms in India. He said that he felt as bit confused a most of the things the guest lecturer said sounded like Latin to him and assuming that I had the wherewithal to make it easy for him to understand system engineering, asked me to explain it to him. So to keep my image intact I tried explaining it to him and the conversation goes like this:

Keshav: you know today we had a guest lecture on system engineering but the sad part is I could understand only half of it. Can you please tell me what it means and why do we need it?

Me: Systems engineering is concerned with the design, production, and maintenance of reliable systems within cost and time constraints.

Systems engineering activities vary from requirements definition or specification to the conceptual and functional development of systems

In context of information system engineering you can say that it is designing of information system which would perform different tasks ranging from simple word processing to preparing your examination result.

It will basically have two components without which it is meaningless.

1) Database

2) Application

A database will have the data to be processed. In the example I gave you it would be your marks you scored in all the terms.

The data to be processed will require an application which will specify how that data is to be processed and typically this application will have a name to make it distinct from others ex- Marks processing application.

Keshav: Does that mean I can engineer my own system and use it to do whatever I want?

Me: Sure, you can build your own information system provided you have the necessary skills which you will acquire with education and follow the basic principles like- data and application should not be merged, they should be distinct. This principle need to be followed because if you merge the database like you term marks with the application then you have to again get that database if you want to use it for any other application. You don’t hard code it.

Keshav: He was also talking about different type of architecture. Can you tell me how many type of architecture there are?

Me: There are mainly single tire, two tire, three tire and multi tire architecture. In a single tire the data and the business logic resides on the same nodes.

A two tier architecture employs two types of nodes: client and server. It will have data on one server and the application on the client system and these two will be connected through a lan or wan. In the example I am using your term marks will be stored in one machine and the application to process it will be stored it on the user’s system which will also have a GUI.

This sort of a system does not place processing burden on server machine when you have a number of users but it require high bandwidth.

In three tier architecture the business logic is kept centrally so that whenever any changes are to be made they can be made at one location. The presentation logic is kept locally with the users in form of GUI. It minimises data transfer over the network.

A multi tier architecture will have different modules at different nodes. It will have a centrally located web server which eliminates the need to have specialist software at each client location. The users will be connected through a corporate network or internet which is a public network. But the disadvantage is that the business application has to be web enabled. Here you can have all three servers on same or different physical machines.

In case you have multiple applications then you cane use one single corporate database which eradicates the problem of inconsistency and duplication. Also one single database is easier to manage. One example of this database could be RDMS.

Different applications on different machines also increase the complexity of a system. For example your school might have one result processing application, one fee processing application etc. This can be dealt by introducing one integrated application like an ERP system which integrates different modules or applications. It is easier to implement and manage.

Keshav: But what if I have an application which is different from other applications. Let us for a moment take the example of an organisation which apart from usual HR, FIN applications has a application which is used by the analysis department.

Me: In that case you can have a different data warehouse server and a different business intelligence application on a separate machine.

Keshav: But when we use a web server to web enable our users through internet, don’t we face the risk of security breach as in external users can access our system and interfere in its functioning.

Me: yes, that possibility is always there and that’s why system engineers use firewall which is a combination of hardware and software to prevent unwanted users from committing security breach.

Keshav: Thanks a lot, now I believe I have adequate knowledge not to feel inadequately equipped with knowledge of system engineering.