Order Management System - Order Form

Order Management System - Specifications

I am the office manager of a small Business Unit. I want to create a small system that will help the company to track the orders as they are picked up by the sales force. We deal with FMCG products which has three application areas as follows.

• Personal health care

o Shampoo

o Soap

o Conditioner

• Chocolates

o Choco Pie

o Five Star

o Bar One

• Biscuits

o Marie Gold

o Maska Chaska

o Cream Treat

We have 20 salespersons that go around the state collecting orders from a set of distributors. And we have a central warehouse where we have inventories of goods.

I want you people to develop software which will enable my salespersons to record the orders online. The program should have the following features

Data Entry Functions

Manage Customers and orders

• Add orders
• Show all orders
• Customers Name
• Company Name
• Contact details for the shipment – Address, Contact Number, Email Id, Fax No
• Product Details – Product application area, product Name, Quantity Ordered
• Date and Time when order is placed

Inventory Management

• Product Application Area
• Product name
• Unit-Price for each product
• Product ID
• Current Stock.

The program should be such that as soon as the salesperson adds the order the inventory should change accordingly and should show the current stock.

Hope you have got an idea of our requirements.

Survey for Pulsar

SE Assignment 4: 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 target language). The original sequence is usually called the source code and the output called object code. Commonly the output has a form suitable for processing by other programs (e.g., a linker), but it may be a human-readable text file.

History of compiler

Software for early computers was exclusively written in assembly language for many years. Higher level programming languages were not invented until the benefits of being able to reuse software on different kinds of CPUs started to become significantly greater than the cost of writing a compiler. The very limited memory capacity of early computers also created many technical problems when implementing a compiler.

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. The FORTRAN team led by John Backus at IBM is generally credited as having introduced the first complete compiler, in 1957. COBOL was an early language to be compiled on multiple architectures, in 1960.

In many application domains the idea of using a higher level language quickly caught on. Because of the expanding functionality supported by newer programming languages and the increasing complexity of computer architectures, compilers have become more and more complex.

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, although both Pascal and C have been popular choices for implementation language. 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.

A-0 Language

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.

The A-0 system was followed by the A-1, A-2, A-3 (released as ARITH-MATIC), AT-3 (released as MATH-MATIC) and B-0 (released as FLOW-MATIC).

Source: Wikipedia

SE Assignment Part B : steps for Part A reports

A) Go to http://db.zoho.com/

B) Create two database table

• go to http://db.zoho.com/
• create an account
• sign In
• go to create database, there will be four options select any one of them for example - click on Import.XLS,.CSV...
• Then window will pop up write database name, description and select the database location i.e pasted data or local drive then copy the data from excel already present in the system and paste in the space available in the window
• then click on next and then create
• database will be created
• repeat the procedure to create other databases

C) Creating the three select queries

• Click on the drop down menu of New and select New Query
• Enter the query in the space provided and click on the option execute.
• Query table will be created
• Repeat the procedure for the different queries
  
• Then save the query tables
• Click on the view mode
• then click on publish, and select the option of embedding on the website.
• Then select the URL from the window that appears
• Paste the URL in the post in your blog
  
• publish the post.

D) The three queries run to generate the three reports are

• Report 1:

SELECT DISTINCT "SellerID", "OwnerLastName","OwnerFirstName"From "Antiques","Antique owners"
where "SellerID"="OwnerID" ORDER BY "OwnerLastName","OwnerFirstName";

• Report 2
  

Select "Antique owners"."OwnerLastName","Antiques".Item From "Antique owners", "Antiques" where "Antique owners"."OwnerID"="Antiques"."SellerID"

• Report 3

SELECT DISTINCT "SellerID", "OwnerLastName","OwnerFirstName","ItemDesired" From "Antiques","Antique owners"Where "SellerID" = "OwnerID" ORDER BY "OwnerLastName","OwnerFirstName";

Assignment 3 part A report 3

Assignment 3 part A report 2

Assignment 3 part A report 1