Specifications for Order Management

I am the managing officer of a cold drink manufacturing company. I have a team of 20 salespersons who go around the state collecting orders from a set of distributors. There is a central warehouse where we have inventories of goods. A application is created to help us track orders as they are picked up your sales force. The detailed specification for the software application has to have some customization like the orders placed should be an amount available in the warehouse or else it should show a default message.
For that I need to have two most important forms
1. Inventory Management
2. Order Management
These will help in updating the inventories available in the warehouse. One will only be the form for the order with the customers name, address and product details, this form will also tell the customer the availability of the product according to the order placed. The other form would store the inventory details and update them time to time. After the order is placed the applications should update itself automatically.

Cold Drink Order Management

Data Veiw of Surf for Market Research

title

COMPILER

What is a compiler?

A compiler is a program that translates a source program written in some high-level programming language (such as Java) into machine code for some computer architecture (such as the Intel Pentium architecture). The generated machine code can be later executed many times against different data each time. 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. 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.

The first compiler.

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.
The A-0 system, written by her in 1951 and 1952 for the UNIVAC I, was the first compiler ever developed for an electronic computer. 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.

Query 3

Query 2

Assingnment 3 , Query 1

Assignment 3 part A& B

Steps to create Online Database:
1. The first step would be to create a Zoho Id. If you are an existing gmail id holder then you only have to login with the id.
2. The home page of zoho will give four options.
* Import excel file, create database, create database templets and enter data right away.
3. Data is imported from an Excel file in this case. You can take the table from the excel file and paste it in the window and name it.
4. You can paste the data into the Zoho page and click create.
5. If you have to get the required output from the tables you need to ask queries. For that click on the link ‘NEW’ and select ‘New Query Table’ option. Write the required query in the appeared window and ask to execute.
6. Now the query asked in the given case was to get employee id, full name, salary and rank whose first name starts with the letter ‘A’ or whose Department Is In ‘Kolkata’.
SELECT “Employee_id”, “Last name”,”First name”,”Salary”,”Rank” from “EMPLOYEES DATABASE” where “First name” like ‘A%’ or “Department”=’Kolkata’
7. For the next query would be to click on the link new and the query would be to get Employee id, full name, rank, and salary, of EMPLOYEES who are from ‘Kolkata’. In this query data of 2 tables is joined by asking for the percentages as well.
SELECT “EMPLOYEES_id”, “Last name”, “First name”,”Address”,”Percentage” FROM “EMPLOYEES DETAILS”,” EMPLOYEES RANK” where “Salary”=’Kolkata’ and “EMPLOYEES DETAILS”.”EMPLOYEES_id”=” EMPLOYEES RANK”.” Employees _id”
8.To get employee id, full name, rank, salary and department in which city, where employees have salary more than 2000
SELECT “Employees_id”, “First name”,”Last name”,”RANK” FROM “EMPLOYEES DATABASE”,”SALARY” where “Salary”> ‘2000′ and “EMPLOYEES DATABASE”.”Employees_id”=”Employees Salary”.”Employees_id”
9.If you would want to publish this into your won blog, then you have to go to the extreme left option ‘publish’ in that click on “embed in blog” click on that option and copy- paste the provided url onto your new blog post and publish your post. Your database has been published onto the net.In case you have to update you can update your database, it will be automatically updated online.

Sir, I am posting the link to the worksheet here.

http://sheet.zoho.com/home.do

NORMALIZATION

Conversation about Systems Architecture

DIALOGUE WRITTING

I am explaining System Architecture to a friend of mine who is a singer by profession. She has joined a computer short term course and so she wants to know more about this. She has come to meet me and out of some discussion about computers, we get into some depth and so her interest grows to know more about the topic.
Poonam: What do want to mean by systems architecture?
Me: System is - A group of independent but interrelated elements comprising a unified whole and architecture is – Design, construction and ornamentation. These are the two main factors involved which you need to understand.
So, Systems architecture can best be described as a representation of an existing system, and the process and discipline for effectively implementing the design for such a system. The set of relations (that is, embedded information) which architecture describes may be expressed in hardware, software, or something else.

Poonam: Ok, So that sounds interesting can you tell me something more about it?
Me: Yes, I have learnt about them in class, so can help you to some extent
Poonam: So what are the different types of architecture?
Me: There architecture is basically structured as 3 main tiers. Its single tier, two tiers, three tiers and a combination of these is multi- tier.
Poonam: Isn’t that very complicated. Can you please simplify? Or else its seems Latin to me
Me: Ok, wait. I will explain you step by step with example. Then it will be easier for you to understand.
Poonam: Yes please do that,
Me: The first is the single tier in which data is separated from the application even if they reside in the same physical hardware. Like for example in an Excel sheet with the data. The applications and the data are present in the same hardware. The data and the application are separate but the storage place is same. It can be the laptop, desktop or even the server.
Poonam: Ok fine. This is a simpler and better way of explaining.
Me: Yes, now let’s move to the next tier.
Poonam: Yes, sure
Me: Now the next type is the two-tier architecture. The data base is located in the main server and other applications are located in individual machines. The data base is connected to applications located in individual machines through internet, L.A.N or W.A.N. Like an institute buys any database which is stored in the main server. The application or the GUI of that software is stored in the individual machines. The access of that database is by using applications through internet or L.A.N. This will help in reducing the burden of the server, when many people will be using.
Poonam: I understood the first two tires; know explain me the other tire.
Me: Yes sure, the three-tier architecture is nearly same as two-tier architecture accept that in three-tier; the application is separated in two parts. The first part has all the critical applications and second part has the general applications. Like any big company. There all the business critical applications are separate. The general applications are available easily and business critical applications are available centrally.
Poonam: Oh wao now I know so much about architecture, and now you will tell me more about the multi- tier structure.
Me: the Multi-tier architecture is for banks which have branches in different locations. They use internet for connection as they cannot use WAN or LAN. So, the database & applications are stored in different servers. The client server is attached to the database & the application servers. The web server acts like an interphase between, the client server and the internet. Clients can access web server via internet.
Poonam: So, I know a lot about the different types of architecture.
Me: To add on let me tell you that we also have consolidations in these tiers were we have both web based as well as LAN or WAN based servers in one architecture.
Poonam: Fine. I know now a lot about the basic architecture, but what is the utility?
Me: Yes, in the integrated database system is based on the relational mode land we have few advantages. This architecture helps in less duplication of data and reduces inconsistency. It becomes easier to manage as the there is proper backup and security.
Poonam: ok. So most of the companies must be having this if I am not wrong
Me: Yes they do. To reduce the complexity the companies introduce ERP system. Which give a better integration across all functional areas and its faster to implement as we only need to purchase the right package from the vendor. We have specialist ERP solutions like Oracle, SQL Server and MySQL. A separate data ware house is also used for Business Intelligence.
Poonam: Is there any kind of risk involved in using this.
Me: When they use the web based enterprise system they have the risk of data getting stolen by the hackers. So to protect data from hacking companies always have a firewall server. This is the security which has to be provided for protecting form data getting transferred to the wrong person.
Poonam: Hope that’s all you have to say. Because this we be a lot of learning for the day.
Me: yes I guess I have told you all that I knew about systems architecture.
Poonam: Thanks a lot for teaching me.