Our company ICT deals in cigarettes. The power brands of the company are Classic Insignia, Golk Flake, Marlbaro, Benson & Hedges, Classic Regular and Mild Seven. To tackle the increasing competition we need to reduce our order processing time.
Requirements:
• A user friendly online application
• The application to be linked with the company’s database
• The sales person has to select his id and enter data such as product and quantity
•If the stock is available the transaction should proceed and using the unit-price and quantity, the order value should be calculated 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
Tuesday, March 25, 2008
Tuesday, March 4, 2008
Monday, February 25, 2008
SE Assignment # 4
Origin 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.
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.
Sunday, February 17, 2008
SE Assignment - Part B -Steps required to accomplish Part A
Steps required to accomplish Part A:
Go to http://db.zoho.com/
Creating two database tables-
1) Sign in to http://db.zoho.com/
2) On the create database page select one of the four options indicated. For example- select import .XLS, .CSV option.
3) In the create database (import) window that appears (step 1 of 2), enter the database name and description. Select the data location option i.e. pasted data or local drive. For example- select pasted data option and copy the prepared excelsheet database in the blank space provided.
4) Select Next.
5) Enter the table name in the window that appears next(step 2 of 3), click create. In the Import Data Details window that appears next, click close. The database table would get created.Repeat the procedure for the second database table.
Creating three select queries:
1.) Locate the New option in the top left corner of the page and in the drop down box click the New Query Table option.
2.) A new query table creation option would appear next. Enter the select command that you require, in the space provided and click execute. The query table would get created.
3) Repeat the procedure for the other two query tables.
4) In each of the query table select the embedding option frpm the Publish option on the top of the page. Select the URL from the window that appears.
5) Paste the URL in the post in your blog after making the necessary changes to the size of the table.
6) Publish the post.
Go to http://db.zoho.com/
Creating two database tables-
1) Sign in to http://db.zoho.com/
2) On the create database page select one of the four options indicated. For example- select import .XLS, .CSV option.
3) In the create database (import) window that appears (step 1 of 2), enter the database name and description. Select the data location option i.e. pasted data or local drive. For example- select pasted data option and copy the prepared excelsheet database in the blank space provided.
4) Select Next.
5) Enter the table name in the window that appears next(step 2 of 3), click create. In the Import Data Details window that appears next, click close. The database table would get created.Repeat the procedure for the second database table.
Creating three select queries:
1.) Locate the New option in the top left corner of the page and in the drop down box click the New Query Table option.
2.) A new query table creation option would appear next. Enter the select command that you require, in the space provided and click execute. The query table would get created.
3) Repeat the procedure for the other two query tables.
4) In each of the query table select the embedding option frpm the Publish option on the top of the page. Select the URL from the window that appears.
5) Paste the URL in the post in your blog after making the necessary changes to the size of the table.
6) Publish the post.
SE Assignment 3- Part A
Hi,Check out my database and 3 queries in the link below:http://db.zoho.com/ZDBDataSheetView.cc?DBID=18235000000003018 Thank you and Have a Nice Day,rahul21
Subscribe to:
Posts (Atom)