Saturday, March 22, 2008

Order Specification

Business Unit: RK Ltd.

Position Held: Office Manager

Objective: Developing a system that will help track orders as when they are picked up by the sales team

Specification to the software company:

We (RK Ltd.) are a company dealing in chocolates of six different types namely Bottle Chocolates, Kuddimar, Pen Poppins, Popaye Jelly Choclate, Lollypop and Bada Bar One. We have a sales team of 20 people spread across the state who collect orders from the distributors. And we have a central warehouse where we keep the inventories.

I want you to develop a system such that whenever a particular sale takes place; my sales person should be able to record the same in the system. This should also synchronize with my inventory in the warehouse wherein changes are made accordingly so that the stock available at a particular point of sale is known to all. If there is a sale entry by two sales persons at the same time, the system should accept the
larger amount order first.

Hope you are clear with the requirements.

Part 1- Rk Order Management System

Monday, February 25, 2008

Why did compiler did compiling?

How was the first compiler ever compiled???

What is a compiler (interpreter)?

A program that translates source code into object code. The compiler derives its name from the way it works, looking at the entire piece of source code and collecting and reorganizing the instructions. Thus, a compiler differs from an interpreter, which analyzes and executes each line of source code in succession, without looking at the entire program. The advantage of interpreters is that they can execute a program immediately. Compilers require some time before an executable program emerges. However, programs produced by compilers run much faster than the same programs executed by an interpreter.

Every high-level programming language (except strictly interpretive languages) comes with a compiler. In effect, the compiler is the language, because it defines which instructions are acceptable.

Evolution of Compiler

First was machine code: First programs written directly in the hardware's machine code

Then was assembler: A program written in machine code to interpret asm into machine code.

Then was a compiler: a set of programs (lexical analyser, parser linker etc) which could convert source code to assembler/machine code.


The first compiler was the A-0, created by Real Admiral Dr. Grace Murphy Hopper in 1949. It was made from assembly.

The A-O series of compilers translated symbolic mathematical code into machine code, and allowed the specification of call numbers assigned to the collected programming routines stored on magnetic tape. One could then simply specify the call numbers of the desired routines and the computer would "find them on the tape, bring them over and do the additions

http://forums.devshed.com/dev-shed-lounge-26/the-first-compiler-370155.html

http://www.linuxquestions.org/questions/programming-9/compiler-conundrum-which-came-first-a-compiler-or-its-source-code-132911/

http://www.webopedia.com/TERM/C/compiler.html

Sunday, February 17, 2008

Part B of Assignment 3(SQL)

Steps to publish the report in Part A-

  • Create 2 tables in the excel sheet with 2 different entities
  • Go to www.db.zoho.com
  • Choose import.xls or any of the remaining 3 options available
  • Name the database
  • Select data from each tables created in the excel sheet
  • Press the create button(run it for each table)
  • Now select new query table and type in the first query and save the same(do it for the remaining querries as well)
  • Click on the view mode
  • Run the publish tab and embed the same on the website for each querry
  • A url will be generated
  • Copied and posted at my blogg
  • Publish the report
The queries that i have used are

  • Table 1
SELECT "Last Name", "First Name" FROM "Student" where "Mess ID" like 'zaw'

  • Table 2
SELECT "Last Name","First Name" From "Student" where "Fees/mth">=1500

  • Table 3
SELECT "ID","Join Date","Fees/mth","Mess ID" from "Student", "Mess" where "Student"."Mess ID" = "Mess"."Mess ID"












SQL Assignment 3 table 3

SQL Assignment 3 table 2