Thought of the day

A person who has good thoughts cannot ever be ugly.  You can have a wonky nose and a crooked mouth and a double chin and stick-out teeth, but if you have good thoughts they will shine out of your face like sunbeams and you will always look lovely.

for more details: http://www.gurukpo.com/

SQL Assignment for BCAIII year

Create the following table

a)Item Table

                                                           

Column name	Datatype	Size
Item_no	Varchar	3
Desc	char	20
Qty_on_Hand	Number	4
Unit_price	Number	6

b)Sales Table

Column name	Datatype	Size
Area	Varchar	20
Item_no	char	4
Smno	Char	4
Name	Char	20
Qty_Sold	number	4

c)Emp Table

Column name	Datatype	Size
Empno	number	4
Ename	char	20
job	Char	10
hiredate	date
sal	number	9,2
deptno	Number	2
Comm	number	7,2

d)Dept Table

Column name	Datatype	Size
Deptno	number	2
Dname	char	20
Loc	VarChar	10

Q.2Describe the structure of the table Item,Sales,Emp,Dept.

Q.3 How you can view the Table name and no of rows in each table present in database.

Q.4 Modify the table sales by adding the column Sales_date of the type date.

Q.5 Modify the table Structure Sales by increasing the columnName from 20 to 25.

DATA RETRIEVAL

1.List only those rows whose salesman name is ‘Raghu’ from table Sales.

2.List only those rows whose unit price value is greater than Rs 2000 from table item.

3.List the distinct salesman rows from  table SALES.

4.List the names of analyst and salesman from EMP table.

5.List the names of employee whose name start with ’S’ and end with ’S’.

6.List the names of employee whose having ’I’ as second character.

7.List the employee name and hiredate in descending order of hiredate.

8.List the Dname where Dname is Clerikal,manager,admin from DEPT table..

9.List the record of employee where ename ram,shayam,raghu  are not there from EMP.

10.List the records whose salary is between 20,000 to 30,000 from EMP.

11.List the records where Loc is either delhi or jaipur from DEPT.

12.Count the number of records in EMP table.

DATA MAINTENANCE

1.Insert the following rows in table Sales:

JawaharNagar,107,S03,Raghu,3

2.Insert the below data in table item

115,Sony,25,10

3.Insert the following row in table EMP:

7311,Anthony,Clerk,18 july2007,3000,null,20

4.Insert a row into EMP by Parameter Substitution.

5.Using Update command, increase everybody salary by 10% in EMP table.

6.Give a commission of rs500 to everyone in table EMP.

7.Update the salary 25000 where ename is shyam.

Thought for the day

"Each one has to find his peace from within.

And peace to be real must be unaffected by outside circumstances."

"A smile of encouragement at the right moment may act like sunlight on a closed-up flower; it may be the turning point for a struggling life."

For more details log on http://www.gurukpo.com/

Thought of the day

Every tomorrow has two handles.
We can take hold of it with the handle of anxiety
or the handle of faith.

Thought for the day

Never thinks that you are looser in the things which you do.Always have right attitude.Face the situations with a smile in your heart.

Why Testing...

Testing is required to Build a Quality Product.
Testing is required to Deliver a quality product.
Testing will give confidence for the software development
company that the software will work satisfactorily in
client environmant.
Testing will improve the software quality.
Testing will also reduces the maintanance cost also.
Even the client of the software will get confidence on the
software.for more details log on. http://www.gurukpo.com/

e-governance

e-Government (short for electronic government, also known as e-gov, digital government, online government, or connected government) is digital interaction between a government and citizens (G2C), government and businesses/commerce/eCommerce (G2B), and between government agencies (G2G), Government-to-Religious Movements/Church (G2R), Government-to-Households (G2H). This digital interaction consists of governance, information and communication technology (ICT), business process re-engineering (BPR), and e-citizen at all levels of government (city, state/provence, national, and international).
For more details log on.  http://www.gurukpo.com/

White Box Testing

What is a White Box Testing Strategy?


White box testing strategy deals with the internal logic and structure of the code. White box testing is also called as glass, structural, open box or clear box testing. The tests written based on the white box testing strategy incorporate coverage of the code written, branches, paths, statements and internal logic of the code etc.
In order to implement white box testing, the tester has to deal with the code and hence is needed to possess knowledge of coding and logic i.e. internal working of the code. White box test also needs the tester to look into the code and find out which unit/statement/chunk of the code is malfunctioning.

Thought for Day

Wherever you go, no matter what the weather, always bring your own sunshine.
for more deatils log on:  http://www.gurukpo.com/

Value Chain Analysis

The value chain, also known as value chain analysis, is a concept from business management that was first described and popularized by Michael Porter in his 1985 .
A value chain is a chain of activities for a firm operating in a specific industry.  Products pass through all activities of the chain in order, and at each activity the product gains some value. The chain of activities gives the products more added value than the sum of added values of all activities. It is important not to mix the concept of the value chain with the costs occurring throughout the activities.

For more details log on: http://www.gurukpo.com/

Supply Chain Management

Supply chain management:-
-supply chain is a process umberella under which products are created and delivered to customers


For more details log on: http://www.gurukpo.com/

Thought For The Day

Our happiness or misery depends on our dispositions and not on our circumstances.

For More Deatils log on:http://www.gurukpo.com

Thought for The Day

If you are patient in one moment of anger, you will escape a hundred days of sorrow.

For more details log on http://www.gurukpo.com/

Performance testing

Performance testing is designed to test the run-time performance of software within the context of an integrated system.
It occurs throughout all steps in the testing process.
It coupled with stress testing & coupled with both hardware and software testing.
It is conducted prior to implementation to determine how long it takes to receive a response to a inquiry, make a backup copy of file, or send a transmission& receive a response.
For details log on http://www.gurukpo.com/

Servers

File servers. -With a file server, the client passes requests for files or file records over a network to the file server. This form of data service requires large bandwidth and can slow a network with many

----
For more details log on http://www.gurukpo.com/

EDI Implementation

The following is a generalized list of major points for consideration when undertaking an EDI project:
1. Obtain commitment from all areas of management.
Involvement from all impacted departments is essential. Each department should be included in the analysis, testing and implementation to validate the testing and to ensure that the resulting system meets the objectives.
For more Details log on http://www.gurukpo.com/

Advantages of Black Box testing

 Advantages of black box testing -   
  Following are the different advantages of black box testing -
•    more effective on larger units of code than glass box testing.
•    tester needs no knowledge of implementation, including specific programming languages.
•    tester and programmer are independent of each other.
•    tests are done from a user's point of view.
•    will help to expose any ambiguities or inconsistencies in the specifications.
•    test cases can be designed as soon as the specifications are complete.
     Disadvantages of Black Box Testing -
•    only a small number of possible inputs can actually be tested, to test every possible input stream would take nearly forever.
•    without clear and concise specifications, test cases are hard to design.
•    there may be unnecessary repetition of test inputs if the tester is not informed of test cases the programmer has  already    tried.
•    may leave many program paths untested.
•    cannot be directed toward specific segments of code which may be very complex (and therefore more error prone).
•    most testing related research has been directed toward glass box testing.

For more details log on http://www.gurukpo.com/

Client server architecture

Client/server architecture  The client/server architecture significantly decreased network traffic by providing a query response rather than total file transfer. It allows multi-user updating through a GUI front end to a shared database. Remote Procedure Calls (RPCs) or standard query language (SQL) statements are typically used to communicate between the client and server. 
for more details log on http://www.gurukpo.com/

EDI

EDI architechture specifies 4 layers:-

1)Semantic (application layer)
2)Standard transaction layer
3)Packing (transport) layer
4)Physical n/w infrastructure layer.
For more details log on http://www.gurukpo.com/

Black Box Testing

Black Box Testing is testing without knowledge of the internal working of the item being tested. 
For more details log on  http://www.gurukpo.com/

competitive advantage

It is a competiton between companies to upgrade that company which is more powerful...
for more details log on http://www.gurukpo.com/

Data Modeling

 It gives answers to questions regarding the data that is to be used in the application. We come to know the data objects, where they are stored, what is the relationship between objects, etc. Data modeling uses an Entity Relationship diagram to solve these questions. An Entity Relationship diagram will focus on all data that are entered, stored, transformed and produced within an application. The data model consists of three interrelated information – data objects, attributes that describe the data objects and relationships that connect data objects to one another.

for more details visit http://www.gurukpo.com/