Order Management System Requirement for Health Conscious Pvt Ltd.

Our company, Health Conscious Pvt Ltd. is foraying into a new business of providing quality Fruits to consumers at a reasonable price. For this the company would be employing a team of 20 sales persons in the first phase of its operation. Each of these sales person will be deployed in a certain area of the city and will move in the assigned area on their specially designed easy to ride carts, carrying various fruits to sell. Each of these sales person will be given a mobile handset which can also be used as a PDA. The mobile number of the the sales person for that area will be advertised in that area so that the customers can call him up and ask him to deliver the fresh fruits at the customers’ home itself. The sales persons will use their PDA to order to the central warehouse of the company every night their requirements for various fruits and the company vehicle will deliver fresh fruits to each of these sales person the next morning.

The company thus requires an Order Management System to handle its daily order and inventory requirements based on the inputs from its field force. For this purpose, the company has decided to place the order for this order management system with your company, Praxis Batch 2007-2009 Pvt Ltd.

Various requirements for the above mentioned order management system are:

• The application should be linked with the company’s database regarding the various fruits and the sales force.
• The sales person has to enter his sales person ID and place an order for the various fruits available specifying the quantity of each kind of fruit.
• If the stock is available the transaction should proceed and using the unit-price and quantity, the order value should be calculated and visible to the person at the warehouse and not to the salesperson else the sales person should receive an appropriate message about the insufficient stock
• As the orders get placed, the inventory should get decreased from the main database.

————xxxx————

Thank you Health Conscious Pvt Ltd for this opportunity, as we are a new firm, we appreciate the trust you have shown in us.

Here is the order management system we have developed as per your requirements.

 

Inventory Form

Inventory View

Order Form

Order View

As we are going through a financial crunch, we expect you to deposit $100,000 as the price for this Order Management System in our account immediately.

Thankyou

 

Are you aware enough…?

Do you think you are aware of what all is happening around you in the world of technology? To find out fill up this questionnaire:

http://creator.zoho.com/avneet_singh_bhatia/a/form/6#

Genesis of a Compiler

What is a Compiler?

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

Because compilers translate source code into object code, which is unique for each type of computer, many compilers are available for the same language. For example, there is a FORTRAN compiler for PCs and another for Apple Macintosh computers. In addition, the compiler industry is quite competitive, so there are actually many compilers for each language on each type of computer. More than a dozen companies develop and sell C compilers for the PC.

How was the first ever Compiler compiled and who compiled it?

Grace Murray Hopper, an American computer scientist and a pioneer in the field, was one of the first programmers of the Harvard Mark I calculator, and she developed the first ever compiler for a computer programming language

In the early 1950s the Eckert-Mauchly Computer Corporation, for which she worked was taken over by the Remington Rand Corporation and it was while she was working for them on UNIVAC I that her original compiler work was done. The compiler was known as the A compiler and its first version was A-0. The A-0 functioned more as a loader or linker than the modern notion of a compiler. A program was specified as a sequence of subroutines and arguments. The subroutines were identified by a numeric code and the arguments to the subroutines were written directly after each subroutine code. The A-0 system converted the specification into machine code that could be fed into the computer a second time to execute the program.

As almost all the early compilers were written in assembly language. The first self-hosting compiler — capable of compiling its own source code in a high-level language — was created for Lisp by Hart and Levin at MIT in 1962. Since the 1970s it has become common practice to implement a compiler in the language it compiles. Building a self-hosting compiler is a bootstrapping problem — the first such compiler for a language must be compiled either by a compiler written in a different language, or (as in Hart and Levin’s Lisp compiler) compiled by running the compiler in an interpreter.

Online DBMS for ‘Summer placement in Praxis’

For creating an online DBMS, one can make use of few shared online RDBMS available on the net.

One of the sites which provide this feature is ZOHO.

(Link:http://db.zoho.com).

Once you log in to ZOHO, you will get various options for creating database for your DBMS, like Import already created database in your computer in .xls, .csv format, create database in ZOHO from various templates, entering the data right away and creating a blank database.

I have used the import database option to create my DBMS. I have used my database created in MS Excel.

You can paste the data from your file to the ZOHO window and assign a name to your database and to the tables you have imported. (You can import a database having multiple tables).

Once you have saved the tables, to retrieve any information from your database, you need to create a ‘new query table’. In this new query table window, to extract the required information in the tabular form you need to write a SQL Query in the space provided (ZOHO uses SQL platform for performing its RDBMS functions).

Save the retrieved tabular information and assign a name for it. You can repeat the process for retrieving and saving some other information.

Once you are done with this, you can decide to publish your work on the net, like I have done. You can decide to keep your database and the retrieved information a private affair, viewable only through authorization or you can keep it open for everyone using the net and is interested in viewing your database (thank you for your interest ). For this you can use the ‘Publish’ option given on your database window.

To see my database on the summer placement scenario for Praxis Business School created using ZOHO kindly click this link:

http://db.zoho.com/ZDBDataSheetView.cc?DBID=18035000000003242&OBJID=18035000000003536

NORMALIZATION

UnNormalized Form

Roll No.

Name

Email_Id

Phone Number

Address

Book Title

Book Author

Book ISBN

Publisher Name

Book Price

Number of Copies

Late Fine Outstanding

Category Name

Library Book Catalogue No.

Quality of the Copy

Issue Date

Return Date

  Normalized Form (3NF)

STUDENT

Roll No. (PK)

Name

Email_Id

Phone Number

Address

Late Fine Outstanding

 CATEGORY

Category No. (PK)

Library Book Catalogue No. (FK)

Category Name

 BOOK DETAILS

Book ISBN (PK)

Library Book Catalogue No. (FK)

Category No. (FK)

Book Title

No. of Copies

 PARTICULAR BOOK DETAILS

Library Book Catalogue No. (PK)

Quality of Book

Issue Id (FK)

 ISSUE DETAILS

Issue Id (PK)

Roll No. (FK)

Library Book Catalogue No. (FK)

Issue Date

Return Date