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/