Sri Kshetra Lakshminarasimha Devasthaana -Ratna Giri

A Lakshmi Narasimha Temple, which is almost thousand year old is in completely ruined condition. Few devotees of the locality came forward & formed a committee to re-built age old temple with out compromising the Vastu Shastra and Sculpture norms. The work has already began with the help of few devotees who have extended big hand for this good cause. In the process of re-building , we need the helping hand of all devotees and common man to complete this noble work in time.

We kindly request you all to contribute generous ally. Your contribution can be sent to

Sri Kshetra Lakshminarasimha Devasthaana -Ratna Giri -Account No 107 301 011 000 740 . Vijaya Bank - Haladi Branch , Kundapur Tq , Udupi Distt

If the amount is remitted through DD or Cheque or ECS, please details of your DD/Cheque and address may be sent to this mail address so as to acknowledge the receipt.Hello all. This is a plea before you all - Kindly go through the contents - A Lakshmi Narasimha Temple, which is almost thousand year old is in completely ruined condition. Few devotees of the locality came forward & formed a committee to re-built age old temple with out compromising the Vastu Shastra and Sculpture norms. The work has already began with the help of few devotees who have extended big hand for this good cause. In the process of re-building , we need the helping hand of all devotees and common man to complete this noble work in time.

We kindly request you all to contribute generous ally. Your contribution can be sent to

Sri Kshetra Lakshminarasimha Devasthaana -Ratna Giri -Account No 107 301 011 000 740 . Vijaya Bank - Haladi Branch , Kundapur Tq , Udupi Distt

If the amount is remitted through DD or Cheque or ECS, please details of your DD/Cheque and address may be sent to this mail address so as to acknowledge the receipt.

King Kobra cool pictures

John Abraham cool photos

Learn SQL online simple programs

LAB PROGRAM #1
=====================================================================
CONSIDER THE INSURANCE DATABASE GIVEN BELOW. THE PRIMARY KEYS ARE UNDERLINED AND DATA TYPES ARE SPECIFIED.
PERSON (DRIVER-ID : STRING, NAME : STRING, ADDRESS : STRING)
CAR (REGNO : STRING, MODEL : STRING, YEAR : INT)
ACCIDENT (REPORT-NO : INT, ACCD-DATE : DATE, LOCATION : STRING)
OWNS (DRIVER-ID : STRING, REGNO : STRING)
PARTICIPATED(DRIVER-ID : STRING, REGNO : STRING, REPORT-NO : INT, DAMAGE-AMT : INT)
=====================================================================
Drop table PERSON;
Drop table CAR;
Drop table ACCIDENT;
Drop table OWNS;
Drop table PARTICIPATED;
=====================================================================
1. CREATE THE ABOVE TABLES BY PROPERLY SPECIFYING THE PRIMARY KEYS AND FOREIGN KEYS.
---------------------------------------------------------------------
Create table PERSON
(
driver_id varchar2(10),
name varchar2(10),
address varchar2(10),
primary key(driver_id)
);
---------------------------------------------------------------------
Create table CAR
(
regno varchar2(10),
model varchar2(10),
year number(4),
primary key(regno)
);
---------------------------------------------------------------------
Create table ACCIDENT
(
report_no number(10),
accd_date date,
location varchar2(10),
primary key(report_no)
);
---------------------------------------------------------------------





Create table OWNS
(
driver_id varchar2(10),
regno varchar2(10),
primary key(driver_id,regno),
foreign key(driver_id) references PERSON(driver_id),
foreign key(regno) references CAR(regno)
);
---------------------------------------------------------------------
Create table PARTICIPATED
(
driver_id varchar2(10),
regno varchar2(10),
report_no number(10),
damage_amt number(5);
primary key(driver_id,regno,report_no),
foreign key(driver_id) references PERSON(driver_id),
foreign key(regno) references CAR(regno),
foreign key(report_no) references ACCIDENT(report_no)
);
=====================================================================
Desc PERSON;
Desc CAR;
Desc ACCIDENT;
Desc OWNS;
Desc PARTICIPATED;
=====================================================================
2. ENTER ATLEAST FIVE TUPLES TO EACH RELATION.
---------------------------------------------------------------------
Insert into PERSON values('ydit1','ABC','P1');
Insert into PERSON values('ydit2','BCD','P2');
Insert into PERSON values('ydit3','CDE','P3');
Insert into PERSON values('ydit4','DEF','P4');
Insert into PERSON values('ydit5','EFG','P5');
---------------------------------------------------------------------
Insert into CAR values('ka04','Maruti',2008);
Insert into CAR values('ka05','Maruti',2007);
Insert into CAR values('ka06','Fiat',2008);
Insert into CAR values('ka09','Chevorlet',2009);
Insert into CAR values('ka03','Maruti',2005);
---------------------------------------------------------------------
Insert into ACCIDENT values('1','1-jan-2008','India');
Insert into ACCIDENT values('2','2-jan-2008','India');
Insert into ACCIDENT values('3','3-jan-2008','India');
Insert into ACCIDENT values('4','4-jan-2008','India');
Insert into ACCIDENT values('5','5-jan-2008','India');
---------------------------------------------------------------------


Insert into OWNS values('ydit1','ka04');
Insert into OWNS values('ydit2','ka05');
Insert into OWNS values('ydit3','ka06');
Insert into OWNS values('ydit4','ka09');
Insert into OWNS values('ydit5','ka03');
Insert into PARTICIPATED values('ydit1','ka04',1,10000);
Insert into PARTICIPATED values('ydit2','ka05',2,20000);
Insert into PARTICIPATED values('ydit3','ka06',3,30000);
Insert into PARTICIPATED values('ydit4','ka09',4,40000);
Insert into PARTICIPATED values('ydit5','ka03',5,50000);
=====================================================================
Select * from PERSON;
DRIVER_ID NAME ADDRESS
---------- ---------- ----------
ydit1 ABC P1
ydit2 BCD P2
ydit3 CDE P3
ydit4 DEF P4
ydit5 EFG P5
---------------------------------------------------------------------
Select * from CAR;
REGNO MODEL YEAR
---------- ---------- ---------
ka04 Maruti 2008
ka05 Maruti 2007
ka06 Fiat 2008
ka09 Chevorlet 2009
ka03 Maruti 2005
---------------------------------------------------------------------
Select * from ACCIDENT;
REPORT_NO ACCD_DATE LOCATION
--------- --------- ----------
1 01-JAN-08 India
2 02-JAN-08 India
3 03-JAN-08 India
4 04-JAN-08 India
5 05-JAN-08 India
---------------------------------------------------------------------
Select * from OWNS;
DRIVER_ID REGNO
---------- ----------
ydit1 ka04
ydit2 ka05
ydit3 ka06
ydit4 ka09
ydit5 ka03



Select * from PARTICIPATED;
DRIVER_ID REGNO REPORT_NO DAMAGE_AMT
---------- ---------- --------- ----------
ydit1 ka04 1 10000
ydit2 ka05 2 20000
ydit3 ka06 3 30000
ydit4 ka09 4 40000
ydit5 ka03 5 50000
=====================================================================
3. DEMONSTRATE HOW YOU
a. UPDATE THE DAMAGE AMOUNT TO 25000 FOR THE CAR WITH A SPECIFIC REGNO AND REPORT NUMBER IN THE ACCIDENT TABLE
b. ADD A NEW ACCIDENT TO THE DATABASE.
---------------------------------------------------------------------
Update PARTICIPATED set damage_amt=25000 where regno='ka04' and report_no=1;
Select * from PARTICIPATED;
DRIVER_ID REGNO REPORT_NO DAMAGE_AMT
---------- ---------- --------- ----------
ydit1 ka04 1 25000
ydit2 ka05 2 20000
ydit3 ka06 3 30000
ydit4 ka09 4 40000
ydit5 ka03 5 50000
---------------------------------------------------------------------
Insert into ACCIDENT values(12,'8-jan-2008','USA');
Select * from ACCIDENT;
REPORT_NO ACCD_DATE LOCATION
--------- --------- ----------
1 01-JAN-08 India
2 02-JAN-08 India
3 03-JAN-08 India
4 04-JAN-08 India
5 05-JAN-08 India
12 08-JAN-08 USA
---------------------------------------------------------------------
Insert into PERSON values('ydit8','PQR','P8');
Insert into CAR values('ka01','Maruti',2005);
Insert into PARTICIPATED values('ydit8','ka01',12,55000);
---------------------------------------------------------------------
Select * from PERSON;
DRIVER_ID NAME ADDRESS
---------- ---------- ----------
ydit1 ABC P1
ydit2 BCD P2
ydit3 CDE P3
ydit4 DEF P4
ydit5 EFG P5
ydit8 PQR P8
Select * from CAR;
REGNO MODEL YEAR
---------- ---------- ---------
ka04 Maruti 2008
ka05 Maruti 2007
ka06 Fiat 2008
ka09 Chevorlet 2009
ka03 Maruti 2005
ka01 Maruti 2005
---------------------------------------------------------------------
Select * from PARTICIPATED;
DRIVER_ID REGNO REPORT_NO DAMAGE_AMT
---------- ---------- --------- ----------
ydit1 ka04 1 25000
ydit2 ka05 2 20000
ydit3 ka06 3 30000
ydit4 ka09 4 40000
ydit5 ka03 5 50000
ydit8 ka01 12 55000
=====================================================================
4. FIND THE TOTAL NUMBER OF PEOPLE WHO OWNED CARS THAT WERE INVOLVED IN ACCIDENTS IN 2008.
---------------------------------------------------------------------
Select count(*) from PERSON P, ACCIDENT A, PARTICIPATED PD
where accd_date like '%08'
and P.driver_id=PD.driver_id
and A.report_no=PD.report_no;
COUNT(*)
---------
6
=====================================================================
5. FIND THE TOTAL NUMBER OF ACCIDENTS IN WHICH CARS BELONGING TO A SPECIFIC MODEL WERE INVOLVED.
---------------------------------------------------------------------
Select count(*) from ACCIDENT A, CAR C, PARTICIPATED PD
where C.model='Maruti'
and C.regno=PD.regno
and A.report_no=PD.report_no;
COUNT(*)
---------
4
=====================================================================







LAB PROGRAM #2
=====================================================================
CONSIDER THE FOLLOWING RELATIONS FOR AN ORDER PROCESSING DATABASE APPLICATION IN A COMPANY
CUSTOMER (CUST-NO : INT, CNAME : STRING, CITY : STRING)
ORDER (ORDER-NO : INT, ODATE : DATE, CUST-NO : INT, ORD-AMT : INT)
ORDER-ITEM(ORDER-NO : INT, ITEMNO : INT, QTY : INT)
ITEM (ITEMNO : INT, UNIT-PRICE : INT)
SHIPMENT (ORDER-NO : INT, WAREHOUSE-NO : INT, SHIP-DATE : DATE)
WAREHOUSE (WAREHOUSE-NO : INT, CITY : STRING)
=====================================================================
Drop table CUST;
Drop table ORD;
Drop table ITEM;
Drop table ORDER_ITEM;
Drop table WAREHOUSE;
Drop table SHIPMENT;
=====================================================================
1. CREATE THE ABOVE TABLES BY PROPERLY SPECIFYING THE PRIMARY KEYS AND FOREIGN KEYS.
---------------------------------------------------------------------
Create table CUST(
cust_no number(10),
cname varchar2(10),
city varchar2(10),
primary key(cust_no)
);
---------------------------------------------------------------------
Create table ORD(
order_no number(10),
odate date,
cust_no number(10),
ord_amt number(10),
primary key(order_no)
);
---------------------------------------------------------------------
Create table ITEM(
itemno number(10),
unit_price number(10),
primary key(itemno)
);
---------------------------------------------------------------------






Create table ORDER_ITEM(
order_no number(10),
itemno number(10),
qty number(10),
primary key(order_no,itemno),
foreign key(order_no) references ORD(order_no),
foreign key(itemno) references ITEM(itemno)
on delete cascade
);
---------------------------------------------------------------------
Create table WAREHOUSE(
warehouse_no number(10),
city varchar2(10),
primary key(warehouse_no)
);
---------------------------------------------------------------------
Create table SHIPMENT(
order_no number(10),
warehouse_no number(10),
ship_date date,
primary key(order_no,warehouse_no),
foreign key(order_no) references ORD(order_no),
foreign key(warehouse_no) references WAREHOUSE(warehouse_no)
);
=====================================================================
2. ENTER ATLEAST FIVE TUPLES TO EACH RELATION.
---------------------------------------------------------------------
Insert into CUST values(111,'ABC','BANGALORE');
Insert into CUST values(222,'BCD','MYSORE');
Insert into CUST values(333,'CDE','GULBARGA');
Insert into CUST values(444,'DEF','HASSAN');
Insert into CUST values(555,'EFG','SHIMOGA');
---------------------------------------------------------------------
Insert into ORD values(1,'1-JAN-2009',111,10000);
Insert into ORD values(2,'1-FEB-2009',222,20000);
Insert into ORD values(3,'1-MAR-2009',333,30000);
Insert into ORD values(4,'1-APR-2009',444,40000);
Insert into ORD values(5,'1-MAY-2009',555,50000);
---------------------------------------------------------------------
Insert into ITEM values(11,100);
Insert into ITEM values(12,200);
Insert into ITEM values(13,300);
Insert into ITEM values(14,400);
Insert into ITEM values(15,500);
---------------------------------------------------------------------



Insert into ORDER_ITEM values(1,11,1000);
Insert into ORDER_ITEM values(2,12,2000);
Insert into ORDER_ITEM values(3,13,3000);
Insert into ORDER_ITEM values(4,14,4000);
Insert into ORDER_ITEM values(5,15,5000);
---------------------------------------------------------------------
Insert into WAREHOUSE values(101,'BANGALORE');
Insert into WAREHOUSE values(102,'MYSORE');
Insert into WAREHOUSE values(103,'GULBARGA');
Insert into WAREHOUSE values(104,'BELGAUM');
Insert into WAREHOUSE values(105,'HASSAN');
---------------------------------------------------------------------
Insert into SHIPMENT values(1,101,'15-JAN-2009');
Insert into SHIPMENT values(2,102,'15-FEB-2009');
Insert into SHIPMENT values(3,103,'15-MAR-2009');
Insert into SHIPMENT values(4,104,'15-APR-2009');
Insert into SHIPMENT values(5,105,'15-MAY-2009');
=====================================================================
Select * from CUST;
CUST_NO CNAME CITY
--------- ---------- ----------
111 ABC BANGALORE
222 BCD MYSORE
333 CDE GULBARGA
444 DEF HASSAN
555 EFG SHIMOGA
---------------------------------------------------------------------
Select * from ORD;
ORDER_NO ODATE CUST_NO ORD_AMT
--------- --------- --------- ---------
1 01-JAN-09 111 10000
2 01-FEB-09 222 20000
3 01-MAR-09 333 30000
4 01-APR-09 444 40000
5 01-MAY-09 555 50000
---------------------------------------------------------------------
Select * from ITEM;
ITEMNO UNIT_PRICE
--------- ----------
11 100
12 200
13 300
14 400
15 500
---------------------------------------------------------------------




Select * from ORDER_ITEM;
ORDER_NO ITEMNO QTY
--------- --------- ---------
1 11 1000
2 12 2000
3 13 3000
4 14 4000
5 15 5000
---------------------------------------------------------------------

Select * from WAREHOUSE;
WAREHOUSE_NO CITY
------------ ----------
101 BANGALORE
102 MYSORE
103 GULBARGA
104 BELGAUM
105 HASSAN
---------------------------------------------------------------------
Select * from SHIPMENT;
ORDER_NO WAREHOUSE_NO SHIP_DATE
--------- ------------ ---------
1 101 15-JAN-09
2 102 15-FEB-09
3 103 15-MAR-09
4 104 15-APR-09
5 105 15-MAY-09
=====================================================================
3. PRODUCE A LISTING: CUSTNAME, NO-OF-ORDERS, AVG-ORD-AMT, WHERE THE MIDDLE COLUMN IS THE TOTAL NUMBER OF ORDERS BY THE CUSTOMER AND THE LAST COLUMN IS THE AVERAGE ORDER AMOUNT FOR THAT CUSTOMER
---------------------------------------------------------------------
Select C.cname,COUNT(O.order_no) AS No_Of_Orders,AVG(O.ord_amt) AS Avg_Ord_Amt
from CUST C,ORD O
where C.cust_no=O.cust_no group by C.cname;
CNAME NO_OF_ORDERS AVG_ORD_AMT
---------- ------------ -----------
ABC 1 10000
BCD 1 20000
CDE 1 30000
DEF 1 40000
EFG 1 50000
=====================================================================




4. LIST THE ORDER-NO FOR ORDERS THAT WERE SHIPPED FROM ALL THE WAREHOUSES THAT THE COMPANY HAS IN A SPECIFIC CITY
---------------------------------------------------------------------
Select S.ORDER_NO,S.WAREHOUSE_NO,W.CITY from SHIPMENT S,WAREHOUSE W
where W.WAREHOUSE_NO = S.WAREHOUSE_NO
and W.CITY='BANGALORE';
ORDER_NO WAREHOUSE_NO CITY
--------- ------------ ----------
1 101 BANGALORE
=====================================================================
5. DEMONSTRATE THE DELETION OF AN ITEM FROM THE ITEM TABLE AND DEMONSTRATE A METHOD OF HANDLING THE ROWS IN THE ORDER-ITEM TABLE THAT CONTAIN THIS PARTICULAR ITEM.
---------------------------------------------------------------------
Delete from ITEM where itemno=11;
---------------------------------------------------------------------
Select * from ITEM;
ITEMNO UNIT_PRICE
--------- ----------
12 200
13 300
14 400
15 500
---------------------------------------------------------------------
Select * from ORDER_ITEM;
ORDER_NO ITEMNO QTY
--------- --------- ---------
2 12 2000
3 13 3000
4 14 4000
5 15 5000
=====================================================================

















LAB PROGRAM #3
=====================================================================
CONSIDER THE FOLLOWING DATABASE OF A STUDENT ENROLLMENT IN COURSES AND BOOKS ADOPTED FOR EACH COURSE
STUDENT (REGNO : STRING, NAME : STRING, MAJOR : STRING, BDATE : DATE)
COURSE (COURSENO : INT, CNAME : STRING, DEPT : STRING)
ENROLL (REGNO : STRING, COURSENO : INT, SEM : INT, MARKS : INT)
BOOK_ADOPTION(COURSENO : INT, SEM : INT, BOOK-ISBN : INT)
TEXT (BOOK-ISBN : INT, BOOK-TITLE : STRING, PUBLISHER : STRING, AUTHOR : STRING)
=====================================================================
Drop table STD;
Drop table COURSE_CHOSEN;
Drop table ENROLLED;
Drop table BOOK_ADPT;
Drop table TXT;
=====================================================================
1. CREATE THE ABOVE TABLES BY PROPERLY SPECIFYING THE PRIMARY KEYS AND FOREIGN KEYS.
---------------------------------------------------------------------
Create table STD(
RegNo varchar2(10),
Name varchar2(10),
Major varchar2(10),
BDate date,
primary key(RegNo)
);
---------------------------------------------------------------------
Create table COURSE_CHOSEN(
CourseNo number(10),
CName varchar2(10),
Dept varchar2(10),
primary key(CourseNo)
);
---------------------------------------------------------------------
Create table ENROLLED(
RegNo varchar2(10),
CourseNo number(10),
Sem number(2),
Marks number(3),
primary key(RegNo,CourseNo,Sem),
foreign key(RegNo) references STD(RegNo),
foreign key(CourseNo) references COURSE_CHOSEN(CourseNo)
);
---------------------------------------------------------------------


Create table TXT(
Book_ISBN number(5),
Book_Title varchar2(10),
Publisher varchar2(10),
Author varchar2(10),
primary key(Book_ISBN)
);
---------------------------------------------------------------------
Create table BOOK_ADPT(
CourseNo number(10),
Sem number(2),
Book_ISBN number(5),
primary key(CourseNo,Sem),
foreign key(CourseNo) references COURSE_CHOSEN(CourseNo),
foreign key(SEM) references ENROLLED(SEM),
foreign key(Book_ISBN) references TXT(Book_ISBN)
);
=====================================================================
2. ENTER ATLEAST FIVE TUPLES TO EACH RELATION.
---------------------------------------------------------------------
Insert into STD values('1yd07cs050','Sudhanshu','DBMS','17-Nov-1989');
Insert into STD values('1yd07cs052','Suhas','Maths','4-Mar-1990');
Insert into STD values('1yd07cs057','Vikram','Chemistry','28-Aug-1989');
Insert into STD values('1yd07cs058','Vishwas','Maths','24-May-1990');
Insert into STD values('1yd07cs017','Lohith','Maths','15-May-1988');
---------------------------------------------------------------------
Insert into COURSE_CHOSEN values(1,'DB2','CSE');
Insert into COURSE_CHOSEN values(2,'Calculus','Maths');
Insert into COURSE_CHOSEN values(3,'Organic','Chemistry');
Insert into COURSE_CHOSEN values(4,'Trig','Maths');
Insert into COURSE_CHOSEN values(5,'Statistics','Maths');
---------------------------------------------------------------------
Insert into ENROLLED values('1yd07cs050',1,5,95);
Insert into ENROLLED values('1yd07cs052',2,4,85);
Insert into ENROLLED values('1yd07cs057',3,2,80);
Insert into ENROLLED values('1yd07cs058',4,1,99);
Insert into ENROLLED values('1yd07cs017',5,3,86);
---------------------------------------------------------------------
Insert into TXT values(111,'DBMS_study','ABC','SN');
Insert into TXT values(222,'MATHS4','BCD','DSC');
Insert into TXT values(333,'ENG_CHEM','CDE','GADAG');
Insert into TXT values(444,'MATHS1','BCD','DSC');
Insert into TXT values(555,'MATHS3','BCD','DSC');
---------------------------------------------------------------------



Insert into BOOK_ADPT values(1,5,111);
Insert into BOOK_ADPT values(2,4,222);
Insert into BOOK_ADPT values(3,2,333);
Insert into BOOK_ADPT values(4,1,444);
Insert into BOOK_ADPT values(5,3,555);
=====================================================================
Select * from STD;
REGNO NAME MAJOR BDATE
---------- ---------- ---------- ---------
1yd07cs050 Sudhanshu DBMS 17-NOV-89
1yd07cs052 Suhas Maths 04-MAR-90
1yd07cs057 Vikram Chemistry 28-AUG-89
1yd07cs058 Vishwas Maths 24-MAY-90
1yd07cs017 Lohith Maths 15-MAY-88
---------------------------------------------------------------------
Select * from COURSE_CHOSEN;
COURSENO CNAME DEPT
--------- ---------- ----------
1 DB2 CSE
2 Calculus Maths
3 Organic Chemistry
4 Trig Maths
5 Statistics Maths
---------------------------------------------------------------------
Select * from ENROLLED;
REGNO COURSENO SEM MARKS
---------- --------- --------- ---------
1yd07cs050 1 5 95
1yd07cs052 2 4 85
1yd07cs057 3 2 80
1yd07cs058 4 1 99
1yd07cs017 5 3 86
---------------------------------------------------------------------
Select * from TXT;
BOOK_ISBN BOOK_TITLE PUBLISHER AUTHOR
--------- ---------- ---------- ----------
111 DBMS_study ABC SN
222 MATHS4 BCD DSC
333 ENG_CHEM CDE GADAG
444 MATHS1 BCD DSC
555 MATHS3 BCD DSC
---------------------------------------------------------------------







Select * from BOOK_ADPT;
COURSENO SEM BOOK_ISBN
--------- --------- ---------
1 5 111
2 4 222
3 2 333
4 1 444
5 3 555
=====================================================================
3. DEMONSTRATE HOW YOU ADD A NEW BOOK TO THE DATABASE AND MAKE THIS BOOK BE ADOPTED BY SOME DEPARTMENT.
---------------------------------------------------------------------
Insert into COURSE_CHOSEN values(6,'JAVA','CSE');
Select * from COURSE_CHOSEN;
COURSENO CNAME DEPT
--------- ---------- ----------
1 DB2 CSE
2 Calculus Maths
3 Organic Chemistry
4 Trig Maths
5 Statistics Maths
6 JAVA CSE
---------------------------------------------------------------------
Insert into TXT values(666,'CR_JAVA','TMH','HS');
Select * from TXT;
BOOK_ISBN BOOK_TITLE PUBLISHER AUTHOR
--------- ---------- ---------- ----------
111 DBMS_study ABC SN
222 MATHS4 BCD DSC
333 ENG_CHEM CDE GADAG
444 MATHS1 BCD DSC
555 MATHS3 BCD DSC
666 CR_JAVA TMH HS
---------------------------------------------------------------------
Insert into BOOK_ADPT values(6,6,111);
Select * from BOOK_ADPT;
COURSENO SEM BOOK_ISBN
--------- --------- ---------
1 5 111
2 4 222
3 2 333
4 1 444
5 3 555
6 6 666
=====================================================================




4. PRODUCE A LIST OF TEXT BOOKS (INCLUDE COURSENO,BOOK_ISBN,BOOK_TITLE) IN ALPHABETICAL ORDER FOR COURSES OFFERED BY THE 'CS' DEPARTMENT THAT USE MORE THAN TWO BOOKS.
---------------------------------------------------------------------
Select C.CourseNo, C.CName, B.Book_ISBN, T.Book_Title
from COURSE_CHOSEN C, BOOK_ADPT B, TXT T
Where C.CourseNo=B.CourseNo
AND B.Book_ISBN=T.Book_ISBN
AND C.CourseNo IN(
Select C1.CourseNo from COURSE_CHOSEN C1,BOOK_ADPT B1
Where C1.CourseNo=B1.CourseNo AND Dept='CSE'
GROUP BY C1.CourseNo
)
ORDER BY Book_Title;
COURSENO CNAME BOOK_ISBN BOOK_TITLE
--------- ---------- --------- ----------
6 JAVA 666 CR_JAVA
1 DB2 111 DBMS_study
=====================================================================
5. LIST ANY DEPARTMENT THAT HAS ALL ITS ADOPTED BOOKS PUBLISHED BY A SPECIFIC NUMBER.
---------------------------------------------------------------------
Select DISTINCT C.Dept,T.Publisher
from COURSE_CHOSEN C, TXT T, BOOK_ADPT B
Where C.CourseNo=B.CourseNo
and T.Book_ISBN=B.Book_ISBN
and T.Publisher='BCD';
DEPT PUBLISHER
---------- ----------
Maths BCD
=====================================================================
















LAB PROGRAM #4
=====================================================================
THE FOLLOWING DETAILS ARE MAINTAINED BY A BOOK DEALER.
AUTHOR(AUTHOR-ID:INT, NAME:STRING, CITY:STRING, COUNTRY:STRING)
PUBLISHER(PUBLISHER-ID:INT, NAME:STRING, CITY:STRING, COUNTRY:STRING)
CATALOG(BOOK-ID:INT, TITLE:STRING, AUTHOR-ID:INT, PUBLISHER-ID:INT, CATEGORY-ID:INT, YEAR:INT, PRICE:INT)
CATEGORY(CATEGORY-ID:INT, DESCRIPTION:STRING)
ORDER-DETAILS(ORDER-NO:INT, BOOK-ID:INT, QUANTITY:INT)
=====================================================================
Drop table AUTHOR;
Drop table PUBLISHER;
Drop table CATALOG;
Drop table CATEGORY;
Drop table ORD_DET;
=====================================================================
1. CREATE THE ABOVE TABLES BY PROPERLY SPECIFYING THE PRIMARY KEYS AND FOREIGN KEYS.
---------------------------------------------------------------------
Create table AUTHOR (
Author_ID Number(10),
Name Varchar2(10),
City Varchar2(10),
Country Varchar2(10),
Primary Key (Author_ID)
);
---------------------------------------------------------------------
Create table PUBLISHER (
Publisher_ID Number(10),
Name Varchar2(10),
City Varchar2(10),
Country Varchar2(10),
Primary Key (Publisher_ID)
);
---------------------------------------------------------------------
Create table CATEGORY (
Category_ID Number(10),
Description Varchar2(10),
Primary Key (Category_ID)
);
---------------------------------------------------------------------








Create table CATALOG (
Book_ID Number(10),
Title Varchar2(10),
Author_ID Number(10),
Publisher_ID Number(10),
Category_ID Number(10),
Year Number(4),
Price Number(5),
Primary Key (Book_ID),
Foreign Key(Category_ID) references CATEGORY(Category_ID),
Foreign Key(Author_ID) references AUTHOR(Author_ID),
Foreign Key(Publisher_ID) references PUBLISHER (Publisher_ID)
);
---------------------------------------------------------------------Create table ORD_DET (
Order_No Number(10),
Book_ID Number(10),
Qty Number(10),
Primary Key (Order_No,Book_ID),
Foreign Key(Book_ID) references CATALOG(Book_ID)
ON DELETE CASCADE
);
=====================================================================
2. ENTER ATLEAST FIVE TUPLES TO EACH RELATION.
---------------------------------------------------------------------
Insert into AUTHOR values(1,'DSC','BANGALORE','INDIA');
Insert into AUTHOR values(2,'kSC','BANGALORE','INDIA');
Insert into AUTHOR values(3,'HERBERT','CALIF','USA');
Insert into AUTHOR values(4,'BGS','BANGALORE','INDIA');
Insert into AUTHOR values(5,'LLB','LONDON','ENGLAND');
---------------------------------------------------------------------
Insert into PUBLISHER values(1,'SUBASH','BANGALORE','INDIA');
Insert into PUBLISHER values(2,'SUBASH','BANGALORE','INDIA');
Insert into PUBLISHER values(3,'TMH','CALIF','USA');
Insert into PUBLISHER values(4,'PRINCETON','BANGALORE','INDIA');
Insert into PUBLISHER values(5,'PRINCETON','LONDON','ENGLAND');
---------------------------------------------------------------------
Insert into CATEGORY values(1,'MATHS');
Insert into CATEGORY values(2,'MATHS');
Insert into CATEGORY values(3,'CPP');
Insert into CATEGORY values(4,'JAVA');
Insert into CATEGORY values(5,'SS');
---------------------------------------------------------------------
Insert into CATALOG values(1,'MATHS1',1,1,1,2006,250);
Insert into CATALOG values(2,'MATHS2',2,2,2,2007,250);
Insert into CATALOG values(3,'CRCPP',3,3,3,2006,450);
Insert into CATALOG values(4,'JAP',4,4,4,2008,300);
Insert into CATALOG values(5,'SSHB',5,5,5,2007,350);
Insert into ORD_DET values(1,1,100);
Insert into ORD_DET values(2,2,200);
Insert into ORD_DET values(3,3,300);
Insert into ORD_DET values(4,4,400);
Insert into ORD_DET values(5,5,500);
=====================================================================
Select * from AUTHOR;
AUTHOR_ID NAME CITY COUNTRY
--------- ---------- ---------- ----------
1 DSC BANGALORE INDIA
2 kSC BANGALORE INDIA
3 HERBERT CALIF USA
4 BGS BANGALORE INDIA
5 LLB LONDON ENGLAND
---------------------------------------------------------------------
Select * from PUBLISHER;
PUBLISHER_ID NAME CITY COUNTRY
------------ ---------- ---------- ----------
1 SUBASH BANGALORE INDIA
2 SUBASH BANGALORE INDIA
3 TMH CALIF USA
4 PRINCETON BANGALORE INDIA
5 PRINCETON LONDON ENGLAND
---------------------------------------------------------------------
Select * from CATEGORY;
CATEGORY_ID DESCRIPTIO
----------- ----------
1 MATHS
2 MATHS
3 CPP
4 JAVA
5 SS
---------------------------------------------------------------------
Select * from CATALOG;
BOOK_ID TITLE AUTHOR_ID PUBLISHER_ID CATEGORY_ID YEAR PRICE
------- ----- --------- ------------ ----------- ----- -----
1 MATHS1 1 1 1 2006 250
2 MATHS2 2 2 2 2007 250
3 CRCPP 3 3 3 2006 450
4 JAP 4 4 4 2008 300
5 SSHB 5 5 5 2007 350
---------------------------------------------------------------------







Select * from ORD_DET;
ORDER_NO BOOK_ID QTY
--------- --------- ---------
1 1 100
2 2 200
3 3 300
4 4 400
5 5 500
=====================================================================
3. Give the details of the author who have 2 or more books in the catalog and the price of the book is greater than the average price of the books in the catalog and the year of publication is after 2000.
---------------------------------------------------------------------
Select Author_ID,NAME,CITY,COUNTRY from AUTHOR
WHERE
Author_ID IN
( Select Author_ID from CATALOG
WHERE
YEAR>2000 AND Price>(Select AVG(Price) from CATALOG)
GROUP BY Author_ID HAVING COUNT(*)>=1
);
AUTHOR_ID NAME CITY COUNTRY
--------- ---------- ---------- ----------
3 HERBERT CALIF USA
5 LLB LONDON ENGLAND
=====================================================================
4. Find the author of the book which has maximum sales.
---------------------------------------------------------------------
Select A.Name from AUTHOR A, CATALOG C, ORD_DET O WHERE
A.Author_ID=C.Author_ID AND C.Book_ID=O.Book_ID
AND O.Qty=(Select MAX(Qty) from ORD_DET);
NAME
----------
LLB
=====================================================================
5. Demonstrate how you increase the price of the books published by a specific publisher by 10%.
---------------------------------------------------------------------
Update CATALOG set Price=Price*1.10 WHERE Publisher_ID=1;
Select * from CATALOG;
BOOK_ID TITLE AUTHOR_ID PUBLISHER_ID CATEGORY_ID YEAR PRICE
------- ----- --------- ------------ ----------- ---- ------
1 MATHS1 1 1 1 2006 275
2 MATHS2 2 2 2 2007 250
3 CRCPP 3 3 3 2006 450
4 JAP 4 4 4 2008 300
5 SSHB 5 5 5 2007 350
=====================================================================
LAB PROGRAM #5
=====================================================================
CONSIDER THE FOLLOWING DATABASE FOR THE BANKING ENTERPRISE:
BRANCH(BRANCH-NAME:STRING, BRANCH-CITY:STRING, ASSETS:REAL)
ACCOUNT(ACCNO:INT, BRANCH-NAME:STRING, BALANCE:REAL)
DEPOSITOR(CUSTOMER-NAME:STRING, ACCNO-INT)
CUSTOMER(CUSTOMER-NAME:STRING, CUSTOMER-STREET:STRING,CUSTOMER-CITY:STRING)
LOAN(LOAN-NUMBER:INT, BRANCH:STRING, AMOUNT:REAL)
BORROWER(CUSTOMER-NAME:STRING, LOAN-NUMBER:INT)
=====================================================================
Drop table BRANCH;
Drop table ACCOUNT;
Drop table DEPOSITOR;
Drop table CUSTMER;
Drop table LOAN;
Drop table BORROWER;
=====================================================================
1. CREATE THE ABOVE TABLES BY PROPERLY SPECIFYING THE PRIMARY KEYS AND FOREIGN KEYS.
---------------------------------------------------------------------
Create table BRANCH (
Branch_Name Varchar2(10),
Branch_City Varchar2(10),
Assets Number(10,3),
Primary Key(Branch_Name),
Check(Assets>0)
);
---------------------------------------------------------------------
Create table CUSTMER (
Cust_Name Varchar2(10),
Cust_Addr Varchar2(10),
Cust_City Varchar2(10),
Primary Key(Cust_Name)
);
---------------------------------------------------------------------
Create table ACCOUNT (
Acc_No Varchar2(10),
Branch_Name Varchar2(10),
Bal_No Varchar2(10),
Primary Key(Acc_No),
Foreign Key(Branch_Name) References BRANCH(Branch_Name) ON DELETE CASCADE
);
---------------------------------------------------------------------




Create table DEPOSITOR (
Cust_Name Varchar2(10),
Acc_No Varchar2(10),
Primary Key(Cust_Name,Acc_No),
Foreign Key(Cust_Name) References CUSTMER(Cust_Name) ON DELETE CASCADE,
Foreign Key(Acc_No) References ACCOUNT(Acc_No)
ON DELETE CASCADE
);
---------------------------------------------------------------------
Create table LOAN (
Loan_No Varchar2(10),
Branch_Name Varchar2(10),
Amt Number(10,4),
Primary Key(Loan_No),
Foreign Key(Branch_Name) References BRANCH(Branch_Name) ON DELETE CASCADE
);
---------------------------------------------------------------------
Create table BORROWER (
Cust_Name Varchar2(10),
Loan_No Varchar2(10),
Primary Key(Cust_Name,Loan_No),
Foreign Key(Cust_Name) References CUSTMER(Cust_Name)
Foreign Key(Loan_No) References LOAN(Loan_No)
ON DELETE CASCADE
);
=====================================================================
2. ENTER ATLEAST FIVE TUPLES TO EACH RELATION.
---------------------------------------------------------------------
Insert into BRANCH values('JAYANAGAR','BANGALORE',2000000);
Insert into BRANCH values('J.P.NAGAR','HASSAN',2000000);
Insert into BRANCH values('VIJAYNAGAR','BANGALORE',2000000);
Insert into BRANCH values('R.T.NAGAR','MYSORE',2000000);
Insert into BRANCH values('VIVEKNAGAR','MYSORE',2000000);
---------------------------------------------------------------------
Insert into CUSTMER values('VISHWAS','JAYANAGAR','BANGALORE');
Insert into CUSTMER values('SUHAS','J.P.NAGAR','HASSAN');
Insert into CUSTMER values('VIKRAM','VIJAYNAGAR','BANGALORE');
Insert into CUSTMER values('LOHITH','R.T.NAGAR','MYSORE');
Insert into CUSTMER values('ASHWATH','VIVEKNAGAR','MYSORE');
---------------------------------------------------------------------
Insert into ACCOUNT values('1YD07CS058','JAYANAGAR','10000');
Insert into ACCOUNT values('1YD07CS052','J.P.NAGAR','20000');
Insert into ACCOUNT values('1YD07CS057','VIJAYNAGAR','30000');
Insert into ACCOUNT values('1YD07CS017','R.T.NAGAR','40000');
Insert into ACCOUNT values('1YD07CS005','VIVEKNAGAR','50000');
---------------------------------------------------------------------
Insert into DEPOSITOR values('VISHWAS','1YD07CS058');
Insert into DEPOSITOR values('SUHAS','1YD07CS052');
Insert into DEPOSITOR values('VIKRAM','1YD07CS057');
Insert into DEPOSITOR values('LOHITH','1YD07CS017');
Insert into DEPOSITOR values('ASHWATH','1YD07CS005');
---------------------------------------------------------------------
Insert into LOAN values('LNJ58','JAYANAGAR',50000);
Insert into LOAN values('LNJP52','J.P.NAGAR',25000);
Insert into LOAN values('LNV57','VIJAYNAGAR',5000);
Insert into LOAN values('LNR17','R.T.NAGAR',55000);
Insert into LOAN values('LNVI05','VIVEKNAGAR',30000);
---------------------------------------------------------------------
Insert into BORROWER values('VISHWAS','LNJ58');
Insert into BORROWER values('SUHAS','LNJP52');
Insert into BORROWER values('VIKRAM','LNV57');
Insert into BORROWER values('LOHITH','LNR17');
Insert into BORROWER values('ASHWATH','LNVI05');
=====================================================================
Select * from BRANCH;
BRANCH_NAM BRANCH_CIT ASSETS
---------- ---------- ---------
JAYANAGAR BANGALORE 2000000
J.P.NAGAR HASSAN 2000000
VIJAYNAGAR BANGALORE 2000000
R.T.NAGAR MYSORE 2000000
VIVEKNAGAR MYSORE 2000000
---------------------------------------------------------------------
Select * from CUSTMER;
CUST_NAME CUST_ADDR CUST_CITY
---------- ---------- ----------
VISHWAS JAYANAGAR BANGALORE
SUHAS J.P.NAGAR HASSAN
VIKRAM VIJAYNAGAR BANGALORE
LOHITH R.T.NAGAR MYSORE
ASHWATH VIVEKNAGAR MYSORE
---------------------------------------------------------------------
Select * from ACCOUNT;
ACC_NO BRANCH_NAM BAL_NO
---------- ---------- ----------
1YD07CS058 JAYANAGAR 10000
1YD07CS052 J.P.NAGAR 20000
1YD07CS057 VIJAYNAGAR 30000
1YD07CS017 R.T.NAGAR 40000
1YD07CS005 VIVEKNAGAR 50000
---------------------------------------------------------------------




Select * from DEPOSITOR;
CUST_NAME ACC_NO
---------- ----------
VISHWAS 1YD07CS058
SUHAS 1YD07CS052
VIKRAM 1YD07CS057
LOHITH 1YD07CS017
ASHWATH 1YD07CS005
---------------------------------------------------------------------
Select * from LOAN;
LOAN_NO BRANCH_NAM AMT
---------- ---------- ---------
LNJ58 JAYANAGAR 50000
LNJP52 J.P.NAGAR 25000
LNV57 VIJAYNAGAR 5000
LNR17 R.T.NAGAR 55000
LNVI05 VIVEKNAGAR 30000
---------------------------------------------------------------------
Select * from BORROWER;
CUST_NAME LOAN_NO
---------- ----------
VISHWAS LNJ58
SUHAS LNJP52
VIKRAM LNV57
LOHITH LNR17
ASHWATH LNVI05
=====================================================================
3. Find all the customers who have atleast two accounts at the main branch.
---------------------------------------------------------------------
Select Cust_Name from ACCOUNT A, DEPOSITOR D
where A.Acc_No=D.Acc_No AND Branch_Name='JAYANAGAR'
GROUP BY Cust_Name HAVING Count(*)>1;
---------------------------------------------------------------------
CUST_NAME
----------
VISHWAS
=====================================================================











4. Find all the customers who have an account at all the branches located in a specific city.
---------------------------------------------------------------------
Select * from CUSTMER c WHERE NOT EXISTS
( Select Branch_Name from BRANCH
WHERE Branch_City='BANGALORE'
MINUS
Select A.Branch_Name from ACCOUNT A,DEPOSITOR D
WHERE D.Acc_No=A.Acc_No
AND
C.Cust_Name=D.Cust_Name
);
---------------------------------------------------------------------
NO ROWS SELECTED.
=====================================================================
5. Demonstrate how you delete tuples in ACCOUNT relation at every branch located in a specific city.
---------------------------------------------------------------------
Delete from ACCOUNT WHERE Branch_Name IN
( Select Branch_Name from BRANCH WHERE Branch_City='Bangalore'
);
---------------------------------------------------------------------
select * from ACCOUNT;
ACC_NO BRANCH_NAM BAL_NO
---------- ---------- ----------
1YD07CS052 J.P.NAGAR 20000
1YD07CS017 R.T.NAGAR 40000
1YD07CS005 VIVEKNAGAR 50000
=====================================================================

Error Handling store procedure

CREATE PROCEDURE usp_Example_ErrorHandler

/* Example stored procedure to illustrate error handling
* Example:
DECLARE @RC int
EXEC @RC = usp_Example_ErrorHandler
PRINT 'Return value = ' + CONVERT(varchar(10), @RC)
****************************************************************/
AS

DECLARE @myERROR int -- Local @@ERROR
, @myRowCount int -- Local @@ROWCOUNT

SET NOCOUNT ON

BEGIN TRAN
INSERT INTO Authors (au_id, au_fname, au_lname, contract)
VALUES ('222-22-2222'
, 'Andrew'
, 'Novick'
, 1
)

SELECT @myERROR = @@ERROR, @myRowCount = @@ROWCOUNT
IF @myERROR != 0 GOTO HANDLE_ERROR

INSERT INTO titles(title_id, title, type, price,notes, pubdate)
VALUES('WW0790'
, 'Transact-SQL User-Defined Functions'
, 'popular_comp', 49.95
, 'Great book.', '2003-11-04')
SELECT @myERROR = @@ERROR, @myRowCount = @@ROWCOUNT
IF @myERROR != 0 GOTO HANDLE_ERROR

INSERT INTO titleauthor (au_id, title_id)
VALUES('222-22-2222', 'WW0790')
SELECT @myERROR = @@ERROR, @myRowCount = @@ROWCOUNT
IF @myERROR != 0 GOTO HANDLE_ERROR

COMMIT TRAN -- No Errors, so go ahead

RETURN 0

HANDLE_ERROR:
ROLLBACK TRAN
RETURN @myERROR

GO

Pavamana Lyrics

Kadalekai Parishe in Namma Basavanagudi will this time (21-11-2011 and 22-11-2011)

Kadalekai Parishe Groundnut festival every year held at Bangalore basavanagudi dodda ganesha temple.Here vendors selling their groundnuts on carts or on the sidewalk of basavanagudi.Guttahalli, Mavalli, Dasarahalli are places where groundnut was cultivated.

Kadlekai Parishe will this time (21-11-2011 and 22-11-2011)

KPC Written test Date and time Announced

Karnataka Power Corporation
KPC Written test Date and time Announced !!!

For AE 10.30 to 12.30 27 th Sunday 2011
For JE 2.30 to 4.30 27 th Sunday 2011

Contents of Test Report

Software test report are in a document that describes out put of tested actions, or events, and the version/label, in order to determine if all features of an application are working correctly.

Test report templates contain all particulars like:
FRS version / unique reference
Functionality / Feature
Test case ID
Test Inputs
Test Steps
Expected Outputs
Test Result
Remarks / Observed outputs / comments
Developers Response on obtained output Also
Rounds of testing mentioning Label / Version no with Date, Tester Name & Effort taken

Contents of Test Plan / Test cases / Test Design

Software test cases are in a document that describes inputs, actions, or events, and their expected results, in order to determine if all features of an application are working correctly.

Test case templates contain all particulars of every test case:

Test case No
Test Case ID
Test Description
Test Precondition
Test Procedures/Steps
Test Case code
Expected Result
Remarks/Notes

All documents should be written to a standard and template. Standards and templates maintain document uniformity.

What is the ratio of developers and testers?

This ratio is not a fixed one, but depends on what phase of the software development life cycle the project is in.
When a product is first conceived, organized, and developed, this ratio tends to be 10:1, 5:1, or 3:1, i.e. heavily in favor of developers.
In sharp contrast, when the product is near the end of the software development life cycle, this ratio tends to be 1:1, or even 1:2, in favor of testers.

What is acceptance testing?

Acceptance testing is black box testing that gives the client/customer/project manager the opportunity to verify the system functionality and usability prior to the system being released to production. The acceptance test is the responsibility of the client/customer or project manager, however, it is conducted with the full support of the project team. The test team also works with the client/customer/project manager to develop the acceptance criteria.

What is boundary value analysis?

Boundary value analysis is a technique for test data selection. A test engineer chooses values that lie along data extremes. Boundary values include maximum, minimum, just inside boundaries, just outside boundaries, typical values, and error values. The expectation is that, if a systems works correctly for these extreme or special values, then it will work correctly for all values in between. An effective way to test code, is to exercise it at its natural boundaries

What is smoke testing?

A quick-and-dirty test that the major functions of a piece of software work without bothering with finer details. Originated in the hardware testing practice of turning on a new piece of hardware for the first time and considering it a success if it does not catch on fire.

What is sanity testing?

Sanity testing is performed whenever cursory testing is sufficient to prove the application is functioning according to specifications. This level of testing is a subset of regression testing. It normally includes a set of core tests of basic functionality to demonstrate proper implementation

What is load testing?

Load testing is testing an application under heavy loads, such as the testing of a web site under a range of loads to determine at what point the system response time will degrade or fail
Load testing simulates the expected usage of a software program, by simulating multiple users that access the program's services concurrently. Load testing is most useful and most relevant for multi-user systems, client/server models, including web servers. For example, the load placed on the system is increased above normal usage patterns, in order to test the system's response at peak loads

What is performance testing?

Although performance testing is described as a part of system testing, it can be regarded as a distinct level of testing. Performance testing verifies loads, volumes and response times, as defined by requirements.

What is stress testing?

Stress testing is testing that investigates the behavior of software (and hardware) under extraordinary operating conditions. For example, when a web server is stress tested, testing aims to find out how many users can be on-line, at the same time, without crashing the server. Stress testing tests the stability of a given system or entity. It tests something beyond its normal operational capacity, in order to observe any negative results. For example, a web server is stress tested, using scripts, bots, and various denial of service tools

What is gamma testing?

Gamma testing is testing of software that has all the required features, but it did not go through all the in-house quality checks. Cynics tend to refer to software releases as "gamma testing".

What is beta testing ?

Beta testing is testing an application when development and testing are essentially completed and final bugs and problems need to be found before the final release. Beta testing is typically performed by end-users or others, not programmers, software engineers, or test engineers.

What is alpha testing ?

Alpha testing is testing of an application/project when development is nearing completion. Minor design changes can still be made as a result of alpha testing. Alpha testing is typically performed by a group that is independent of the design team, but still within the company, e.g. in-house software test engineers, or software QA engineers

What is regression testing?

The objective of regression testing is to ensure the software remains intact. A baseline set of data and scripts is maintained and executed to verify changes introduced during the release have not "undone" any previous code. Expected results from the baseline are compared to results of the software under test. All discrepancies are highlighted and accounted for, before testing proceeds to the next level

What is system testing?

System testing is black box testing, performed by the Test Team, and at the start of the system testing the complete system is configured in a controlled environment. The purpose of system testing is to validate an application's accuracy and completeness in performing the functions as designed. System testing simulates real life scenarios that occur in a "simulated real life" test environment and test all functions of the system that are required in real life. System testing is deemed complete when actual results and expected results are either in line or differences are explainable or acceptable, based on client input. Upon completion of integration testing, system testing is started. Before system testing, all unit and integration test results are reviewed by Software QA to ensure all problems have been resolved. For a higher level of testing it is important to understand unresolved problems that originate at unit and integration test levels.

What is black box / closed box testing?

Black box testing a type of testing that considers only externally visible behavior. Black box testing considers neither the code itself, nor the "inner workings" of the software

What is white box / clear box testing?

White box / Clear box testing is a testing approach that examines the application's program structure, and derives test cases from the application's program logic.

What is integration testing?

Integration testing is kind of black box testing done after Unit testing.
The purpose of integration testing is to ensure distinct components of the application still work in accordance to customer requirements after integrating the units.
Test cases are developed with the express purpose of exercising the interfaces between the components. Integration testing is considered complete, when actual results and expected results are either in line or differences are explainable/acceptable based on client input.

What is unit testing?

Unit Testing is a method of testing that verifies the individual
units of source code are working properly

Different testing approaches

Performance testing,
Install/uninstall testing,
Usability testing,
Recovery testing,
Security testing,
Compatibility testing,
Exploratory, ad-hoc testing,
User acceptance testing,
Comparison testing,
Alpha testing,
Beta testing, and
Mutation testing.
Black box testing,
White box testing,
Unit testing,
Incremental testing,
Integration testing,
Functional testing,
System testing,
End-to-end testing,
Sanity testing,
Regression testing,
Acceptance testing,
Load testing,

Test Goal and Estimation

Eight rules for estimating the testing are:

Rule 1: Estimation shall be always based on the software requirements
Rule 2: Estimation shall be based on the expert judgment
Rule 3: Estimation shall be based on the previous projects
Rule 4: Estimation shall be based on metrics
Rule 5: Estimation shall never forget the past
Rule 6: Estimation shall be recorded
Rule 7: Estimation shall be supported by tools.
Rule 8: Estimation shall always be verified

GOALS OF TESTING
Find cases where the program does not do what it is supposed to do.
Find cases where the program does things it is not supposed to do.

Responsibilities of Test Engineer

Assure the successful launch of product by discovering bugs and design flaws, before users get discouraged, before shareholders loose their cool and before employees get bogged down;
Help the work of development staff, so the development team can devote its time to build up product;
Promote continual improvement;
Provide documentation required by ISO, CMM, FDA, FAA, other regulatory agencies and requested by customers;
Save money by discovering defects 'early' in the design process, before failures occur in production, or in the field; Save the reputation of company by discovering bugs and design flaws;
Before bugs and design flaws damage the reputation of company.

What are responsibilities of Test Engineer?

The Test Engineer's function is to use the system much like real users would, find all the bugs, find ways to replicate the bugs, submit bug reports to the developers, and to provide feedback to the developers, i.e. tell them if they've achieved the desired level of quality

Enhancing this Test engineer should -
Create test cases, procedures, scripts and generate data.
Execute test procedures and scripts, analyze standards of measurements, evaluate results of system / integration / regression testing.
Also...
Speed up the work of the development staff;
Reduce organization's risk of legal liability;
Give you the evidence that software is correct and operates properly;
Improve problem tracking and reporting;
Maximize the value of software;
Maximize the value of the devices that use it;

What is a Testing / QA Team?

Depending on the organization, the following roles are more or less standard on most testing projects: Testers, Test Engineers, Test/QA Team Lead, Test/QA Manager, System / Database Administrator, Technical Analyst & Test Build / Configuration Manager

Mainly Testing Team comprised of

Test Engineer: Test Engineers are engineers who specialize in testing.

Test/QA Team Lead: The Test/QA Team Lead coordinates the testing activity, communicates testing status to management and manages the test team.
Test/QA Manager: QA Manager manages the testing activity, takes decisions by communicating with higher management and manages the Quality & Testing team.

What is software testing methodology?

Software testing methodology is the use a three step process of...

Creating a test strategy;
Creating a Test Plan / Test Cases / Test Design; and
Executing tests.
Defect Tracking
Test Audits


This methodology can be used and molded to organization's needs.

What is testing ?

Testing is a process that identifies the correctness, completeness, and quality of software.
It -
Proves the program is error free • Establish that the software performs its functions correctly • Establish with confidence that the software does its job fully

Sehwag The graet, Gavaskar, Kapil, Tendulkar are selected for All time word test team.

All Time XI(world):

Virender Sehwag
Sunil Gavaskar
Donald Bradman
Sachin Tendulkar
Brian Lara
Kapil Dev
Adam Gilchrist (wk)
Shane Warne
Wasim Akram
Curtly Ambrose
Glenn McGrath.

Gelupu thalupulee theese aakasame Lyrics

Gelupu thalupulee theese aakasame
nedu naa kosamee
adugu merupulaa maare aanandame
veedadi ee bandhame
etuvaipu velutunna
velugulne chustunna
merisave rangullonaa
kala tire samayana
ala nenai lestunnaa
anukunde chesestunna
daarullani nathoo patugaa
ooyaloogi paate paadagaa
nanu veedi kadaladu
kalamoka kshanamainaa

Gelupu talupulee theese aakasame
nedu naa kosamee

Yedalo asalannii
edige kalla mundare
egiree oohalannii
nijamai nannu cherele
sandeehmedi ledugaa
santoshmantha naadigaa
chukallo cheri chupagaa
uppongutunna horugaa
chindesi paadam aadagaa
dikkulni meeti veena ga
chelaregi kadilenu
gaali taragale painaa

Gelupu talupulee theese aakasame
nedu naa kosamee

Alupe raadu antuu
kolicha ningi anchulanee
jagame elukuntuu
paricha koti kaanthule
ivvala gunde loo ila
chalariponi swaasala
kammesukunde nee kalaa
innalu leni lotu laa
tellariponi reyila
nannallukunte nuvvilaa
nanu nenu gelichina
ontariga nilichaane

Gelupu talupulee theese aakasame
nedu naa kosamee

Usability Testing

This testing is also called as ‘Testing for User-Friendliness’. This testing is done if User Interface of the application stands an important consideration and needs to be specific for the specific type of user.

Exploratory Testing

This testing is similar to the ad-hoc testing and is done in order to learn/explore the application.

Ad-hoc Testing

This type of testing is done without any formal Test Plan or Test Case creation. Ad-hoc testing helps in deciding the scope and duration of the various other testing and it also helps testers in learning the application prior starting with any other testing.

Load Testing

The application is tested against heavy loads or inputs such as testing of web sites in order to find out at what point the web-site/application fails or at what point its performance degrades.

Stress Testing

The application is tested against heavy load such as complex numerical values, large number of inputs, large number of queries etc. which checks for the stress/load the applications can withstand.

Functional Testing

In this type of testing, the software is tested for the functional requirements. The tests are written in order to check if the application behaves as expected.

Software Testing - Black Box Testing Strategy

Black Box Testing is not a type of testing; it instead is a testing strategy, which does not need any knowledge of internal design or code etc. As the name "black box" suggests, no knowledge of internal logic or code structure is required. The types of testing under this strategy are totally based/focused on the testing for requirements and functionality of the work product/software application. Black box testing is sometimes also called as "Opaque Testing", "Functional/Behavioral Testing" and "Closed Box Testing".

The base of the Black box testing strategy lies in the selection of appropriate data as per functionality and testing it against the functional specifications in order to check for normal and abnormal behavior of the system. Now a days, it is becoming common to route the Testing work to a third party as the developer of the system knows too much of the internal logic and coding of the system, which makes it unfit to test the application by the developer.

In order to implement Black Box Testing Strategy, the tester is needed to be thorough with the requirement specifications of the system and as a user, should know, how the system should behave in response to the particular action.

Various testing types that fall under the Black Box Testing strategy are: functional testing, stress testing, recovery testing, volume testing, User Acceptance Testing (also known as UAT), system testing, Sanity or Smoke testing, load testing, Usability testing, Exploratory testing, ad-hoc testing, alpha testing, beta testing etc.

These testing types are again divided in two groups: a) Testing in which user plays a role of tester and b) User is not required

Wine & wisdom

Drunk Taster

In an alcohol factory the regular taster died and the director was in urgent need of looking for a replacement.

A drunkard with ragged, dirty look came to apply for the position..

The director of the factory wondered how to send him away.

They tested him.

They gave him a glass with a drink. He tried it and said, "It's red wine, a muscat, three years old, grown on a north slope, matured in steel containers."
"That's correct", said the boss.

Another glass.
"It's red wine, cabernet, eight years old, a south-western slope, oak barrels."
"Correct."

A third glass.
''It's champagne, high grade and exclusive'' calmly said the drunk.

The director was astonished.
He winked at his secretary to suggest something.

She brought in a glass of urine. The alcoholic tried it.

"It's a blonde, 26 years old, pregnant in the third month.
And if you don't give me the job, I'll name the father!"

THIS WISDOM IS VALUABLE !


To my friends who enjoy a glass of wine...
And those who don't.

As Ben Franklin said:
In wine there is wisdom,
In beer there is freedom,
In water there is bacteria.

In a number of carefully controlled trials,
Scientists have demonstrated that if we drink
1 litre of water each day,
At the end of the year we would have absorbed
More than 1 kilo of Escherichia coli, (E. Coli) - bacteria
Found in faeces.
In other words, we are consuming 1 kilo of poop..

However,
We do NOT run that risk when drinking wine & beer
(or tequila, rum, whiskey or other liquor)
Because alcohol has to go through a purification process
Of boiling, filtering and/or fermenting.

Remember:
Water = Poop,
Wine = Health.
Therefore, it's better to drink wine and talk stupid (shit!!!!),
Than to drink water and be full of shit.

There is no need to thank me for this valuable information:
I'm doing it as a public service!

Bangalore Local bus routes

This website lets you search the BMTC bus routes in Bangalore .
You can either get information on the bus routes between any two locations or look up a specific bus route number.
http://www.narasimhadatta.info/bmtc_query.html
It’s very useful for people how are new to Bengaluru city.

Solution on Petrol Hike

"KAVALEDURGA", a monumental fort built by Keladi Nayaks near Thirthahalli.

"KAVALEDURGA", a monumental fort built by Keladi Nayaks near Thirthahalli. A beautiful place, but being neglected by the local people and department of tourism. But now ASI (Govt. of INDIA) has initiated restructuring of the ruins of palace and three walled fort.
It is at an elevation of nearly 3000 ft. above sea level and within the fort one can see thick forest with sky touching trees. A 18kms. journey from T'halli and 22kms. from Mastikatte in Kondlur road. It is hardly been visited by the tourists earlier. But these days many go there to enjoy the beauty of 400 years old royal palace.

SQL Scalar functions

Diffending on input value this function will returns the single value.

•UCASE() - Converts a field to upper case
•LCASE() - Converts a field to lower case
•MID() - Extract characters from a text field
•LEN() - Returns the length of a text field
•ROUND() - Rounds a numeric field to the number of decimals specified
•NOW() - Returns the current system date and time
•FORMAT() - Formats how a field is to be displayed

SQL Aggregate Functions

Diffending on value in column this function will return a single value.


•SUM() - Returns the sum
•COUNT() - Returns the number of rows
•FIRST() - Returns the first value
•LAST() - Returns the last value
•MAX() - Returns the largest value
•AVG() - Returns the average value

See Before and after disaster pic of Japan

Move the slider to compare satellite images from before and after the disaster.



http://www.nytimes.com/interactive/2011/03/13/world/asia/satellite-photos-japan-before-and-after-tsunami.html?hp

Opening for Service Engineer-B​angalore

Department: UPS and Power Products

Position: Service Engineer

Location: Bangalore

Profile:
He is responsible for Resolving customer issues
Installing,repairing ,testing the equipment
Maintaining the performance of the products

CTC:upto-1.2 P.A.
B.E. freshers can also apply

If interested in the opening kindly revert with your updated CV with current CTC and Expected Mentioned.

NOT TRUE: BBC News Flash Report: Japan government confirms radiation leak at Fukushima nuke plants

Since the news spread out about the possible meltdown of Japan's nuclear reactor in Fukushima due to the strong earthquake last Friday, there has been fictitious text/SMS messages circulating around the Philippines. The text message warns that the radiation from the problematic nuclear plant will reach the Philippines and other Asian countries today and everybody is advised to stay indoors for their safety especially when it rains. Here's one variation of that text message:



BBC FLASHNEWS: Japan government confirms radiation leak at Fukushima nuclear plants. Asia countries should take necessary precautions. If rain comes, remain indoors first 24hrs. Close doors & windows. Swab neclskin with betadine where thyroid area is, radiation hits thyroid first. Take extra precautions. Radiation may hit Phil at starting 4pm today. Pls send to your loved ones.


If you received a similar text message: DO NOT BELIEVE IT! DO NOT FORWARD IT! It's a false warning designed to spread unnecessary anxiety and confusion.

What is your salary per Minute

Shah Rukh Khan

What: Actor
How much: Rs 247 per minute


The King Khan, who started off modestly as a 'Fauji', made about Rs 13
crore last year. This included his endorsement deals for Pepsi, Hyundai
Santro - and of course, wetting himself in a bathtub, surrounded by women
for HLL's Lux. How much per minute?


Brij Mohan Lall Munjal

What: Chief of Hero Group
How much: Rs 255 per minute




The patriarch of the Hero Group received the Life-time achievement award
for 'Excellence in Corporate Governance' by the Institute of Company
Secretary of India this year. Brij Mohan Lall Munjal earned about Rs 13.4
crore last
year. He continues to be the world's largest motorcycle manufacturer and
fuels his bank balance with Rs 255 per minute.


Sachin Tendulkar

What: Cricketer
How much: Rs 1,163 per minute




India's most loved sportsman makes a lot more than most CEOs of Indian
companies; going by his annual remuneration for 2004-2005. Breaking it
down, his three-year contract for endorsements is worth Rs 180 crores. He
is also paid Rs 2,35,000 for a five-day test match and Rs 2,50,000 for one
dayers.

A little bit of elementary math: This highest paid cricketer in the world
makes around Rs 61.15 crore a year, or Rs 1,163 per minute


Dr A P J ABDUL Kalam

What: President of India
How much: Rs 1.14 per minute




Before taking on the reins of this country, Dr A P J Kalam played a leading
role in the development of India's missile and nuclear weapons programmes -
so much so - that he's fondly referred to as the 'Missile Man'. In the
early
1990s, he served as scientific adviser to the government, and his prominent
role in India 's 1998 nuclear weapons tests established Kalam as a national
hero. For all his work in his present capacity as President of the world's
largest de mocracy, Kalam draws an annual remuneration of Rs 6,00,000 or Rs
1.14 per minute.


Mukesh Ambani




What: CMD of Reliance Industries Ltd
How much: Rs 413 per minute

Head honcho of the $16.5 billion Reliance Industries Limited, Mukesh Ambani
was ranked the world's 56th richest man in Forbe's list. But since this is
only about salaries (and the like), we'll completely ignore his other
earnings. Last year, Mr Ambani earned Rs 21.72 crore; a neat growth of 87
per cent over his previous year's earnings. He makes not less than Rs 413
per minute.


Amitabh Bachchan

What: Actor
How much: Rs 361 per minute



Kaun Banega Crorepati? Apparently, Mr Bachchan! With more endorsements and
film releases per year than successful actors half his age, Bachchan's
take-home last year was around Rs 19 crore - that's Rs 361 per minute.


Dr Manmohan Singh

What: Prime Minister of India
How much: Rs 0.57 per m inute



An economist by profession, Dr Singh has formerly served in the
International Monetary Fund. His economics education included an
undergraduate and a master's degree from Punjab University ; an
undergraduate
degree from Cambridge ; and a doctorate from Oxford University . One of the
most educated Indian prime ministers in history, Singh also served as the
finance minister under prime minister Narasimha Rao. In his present
capacity, Singh is paid Rs 3,60,000 annually, i.e. Rs 0.57 per minute.


Indra Nooyi

What: New Pepsi Chief
How much: Rs 2,911 per minute (from October 11)




Chennai-born 50-year-old Indra Nooyi was the Chief Financial Officer (CFO)
of PepsiCo, the US-based soft drink major. In that capacity, her
remuneration stood at $5 million (over Rs 23 crore). With her promotion
this
year, Nooyi becomes one of the highest paid CEOs in the world, with an
announced remuneration of $33 million (approximately Rs 153 crores). This
means Nooyi makes a whopping Rs 2,911 per minute.

*All figures based on media reports

Don’t put your cell number on Facebook

On Tuesday 18 January 2011, 12:01 AM

Sydney, Jan 17 (ANI): A security expert has warned that users should remove their home addresses and phone numbers from their Facebook accounts

Graham Cluley said the website now gives third parties access to that information.

The website said in a blog post at the weekend that it would give developers of applications access to the contact information of users who install their apps.

"These permissions must be explicitly granted to your application by the user via our standard permissions dialogs. Please note that these permissions only provide access to a user's address and mobile phone number, not their friend's addresses or mobile phone numbers," the Sydney Morning Herald quoted Facebook's Jeff Bowen as saying.

However, Sophos security expert Cluley, has raised doubts over the move.

"You have to ask yourself - is Facebook putting the safety of its 500+ million users as a top priority with this move?" he said.

"It won't take long for scammers to take advantage of this new facility, to use for their own criminal ends."

Cluley advised that users should take personal info such as home addresses and mobile numbers off their pages.

"You can imagine, for instance, that bad guys could set up a rogue app that collects mobile phone numbers and then uses that information for the purposes of SMS spamming or sells on the data to cold-calling companies," he said. (ANI)

Reserve Bank of India launched 150 Rupee Coin

India celebrating the Rabindranath Tagore's 150th birth anniversary. On this celebration Reserve Bank of India launched the 150 Rupee coin in the memory of Nobel Winner Sir Rabindranath Tagore. Newly launched 150 Rupee coin is about 40 mm in diameter and It's weighs is about 35 grams. The coin of 150 Rupee contain Rabindranath Tagore image on one side and on another side it will contain the image of Ashok Stambha.

Bangalore univercity made mandatory that a student clears at least 50% of the subjects to become eligible for promotion to the next semester

Currently, Bangalore University students, under the complete carryover system, can get into the next semester without clearing even a single subject in the previous semester.
“Under the existing system a student will be promoted to the next semester even if he doesn’t attend the exam. Now it is mandatory that a student clears at least 50% of the subjects to become eligible for promotion to the next semester.”

The Excel BIN2HEX Function

Basic Description
Hexadecimal (base 16), decimal (base 10), octal (base 8), and binary (base 2) are the most commonly used numeral systems in engineering and computing. Therefore, Excel has provided functions to convert numeric values to and from each of these systems.

The Excel Bin2Hex function converts a Binary (Base 2) number into a Hexadecimal (Base 16) number.

The format of the function is :

BIN2HEX( Number, [Places] )
Where :

- The Number argument is the binary number that is to be converted to hexadecimal
and - The [Places] argument is an optional argument, which specifies the number of characters that you want the returned hexadecimal number to have. If this is greater than the minimum, the hexadecimal number will be padded out using leading zeros.
If omitted, the returned hexadecimal uses the minimum number of places.

Note that the Number argument must be no more than 10 characters (40 bits) long. The most significant bit of this value denotes the sign of the number and the remaining 39 bits denote the magnitude. Negative numbers are represented using two's complement notation.





Common Errors
If you get an error from your Excel Bin2Hex function this is likely to be one of the following :

#VALUE! - Occurs if the supplied Places argument is not recognised as a number
#NUM! - Occurs if either: - the supplied Number argument is not recognised as a binary number or contains more than 10 characters
or
- the resulting hexadecimal number requires more places than is specified by the supplied Places argument
or
- the supplied Places argument ≤ 0

#NAME? - Occurs when Analysis ToolPak add-in is not enabled in your Excel.
You will need to enable the add-in if you want to use the Excel engineering functions.

To do this in Excel 2003 :

•From the Tools drop-down menu, select the option Add-Ins ...
•An 'Add-Ins' window will pop up. From this, select the option Analysis ToolPak and click OK
To do this in Excel 2007 :

•Click the Microsoft button on the top left of your spreadsheet and select the Excel Options button
•From the menu on the left hand side, select Add-Ins
•In the 'Manage:' box, select Excel Add-ins and click Go...
•An 'Add-Ins' window will pop up. From this, select the option Analysis ToolPak and click OK

IPTV is future TV technology

What is IPTV?
Internet Protocol Television (IPTV) is a technology based on delivering programs to your home through the Internet rather than traditional methods such as Cable, Satellite or Antenna. This is made possible by connecting your TV set to a set top box. This box also connects to your high speed internet connection and receives an encoded signal from the IPTV service.

280 lac cror of Indian money is deposited in swiss banks.

"Indians are poor but India is not a poor country".
Say one of the swiss bank directors.
He says that "280 lac crore" of Indian money is deposited in swiss banks.
It can be used for 'taxless' budget for 30 years.
It can give 60 crore jobs to all Indians.
From any village to Delhi 4 lane roads.
Forever free power suply to more than 500 social projects.
Every citizen can get monthly 2000/- for 60 yrs.
No need of World Bank & IMF loan.

Think how our money is blocked by rich politicians.
We have full right against corrupt politicians.

Free Education and Free hostel for Handicapped/Physically Challenged children

Free Education and Free hostel for Handicapped/Physically Challenged children.
Contact:- 9842062501 & 9894067506.

Campus for engineering students

Engineering Students can register in www.campuscouncil.com to attend Off Campus for 40 Companies.

Need Blood and donor adress?

Where you can search for any BLOOD GROUP, you will get thousand's of donor address. www.friendstosupport.org

RED SOCIETY for begging children

If you see children Begging anywhere in INDIA , please contact:
"RED SOCIETY" at 9940217816. They will help the children for their studies.

Heights of Coincidenc​e

Lincoln's name has 7 letters
- Kennedy's name has 7 letters

- In Lincoln's & Kennedy's names the vowels & consonants fall in exactly the same place;***
in the order c, v, c, c, v, c, c

- Lincoln was elected to Congress in 1846
- Kennedy was elected to Congress in 1946

- Lincoln was elected president in 1860
- Kennedy was elected president in 1960

- Kennedy had a secretary named Lincoln

- War was thrust upon Lincoln almost immediately after inauguration
- War was thrust upon Kennedy almost immediately after inauguration

- Lincoln ordered the Treasury to print its own money
- Kennedy ordered the Treasury to print its own money

- International bankers may have arranged the assassinations of Lincoln and Kennedy

- Lincoln gave negroes freedom and legalized equality
- Kennedy enforced equality for negroes

- Lincoln delivered the Gettysburg Address on November 19, 1863
- Kennedy was assassinated on November 22, 1963

- Lincoln was loved by the common people and hated by the establishment
- Kennedy was loved by the common people and hated by the establishment

- Lincoln was succeeded, after assassination, by vice-president Johnson
- Kennedy was succeeded, after assassination, by vice-president Johnson

- Andrew Johnson was born in 1808
- Lyndon Johnson was born in 1908

- Andrew Johnson's name has 13 letters
- Lyndon Johnson's name has 13 letters

- Andrew Johnson had a pug nose and slicked-back hair
- Lyndon Johnson had a pug nose and slicked-back hair

- Lincoln was sitting beside his wife when he was shot
- Kennedy was sitting beside his wife when he was shot

- Rathbone, who was with Lincoln when he was shot, was injured (by being stabbed)
- Connally, who was with Kennedy when he was shot, was injured (by being shot)
- Rathbone's name has 8 letters
- Connally's name has 8 letters

- Lincoln's wife held his head in her lap after he was shot
- Kennedy's wife held his head in her lap after he was shot

- Lincoln was shot on a Friday
- Kennedy was shot on a Friday

- Lincoln was shot in a theatre named Ford
- Kennedy was shot in a car made by Ford

- Kennedy was shot in a car named Lincoln

- Lincoln's bodyguard was away from his post at the door of the President's box at the theatre
- Kennedy's bodyguards were away from their posts on the running-boards of the President's car

- Lincoln was shot in a theatre and his assassin ran to a warehouse
- JFK was shot from a warehouse and his alleged assassin ran to a theatre

- Lincoln's assassin had a three-worded name, John Wilkes Booth
- Kennedy's alleged assassin had a three-worded name, Lee Harvey Oswald

- John Wilkes Booth has 15 letters
- Lee Harvey Oswald has 15 letters

- John Wilkes Boothe was born in 1839
- Lee Harvey Oswald was born in 1939

- Lincoln didn't die immediately after being shot
- Kennedy didn't die immediately after being shot

- Lincoln and Kennedy died in places beginning with the initials P and H
- Lincoln died in Petersen's house
- Kennedy died in Parkland Hospital

- Booth was shot and killed* in police custody before going to trial
- Oswald was shot and killed in police custody before going to trial

- Kennedy's funeral was modelled on Lincoln's funeral

- Andrew Johnson was a heavy drinker with crude behaviour
- Lyndon Johnson was a heavy drinker with crude behaviour

- There were conspiracy theories that Johnson was knowledgeable about Lincoln's assassination
- There were conspiracy theories that Johnson was knowledgeable about Kennedy's assassination**

- Days before it happened Lincoln told his wife and friends about a dream he'd had of being shot by an assassin
- Hours before it happened Kennedy told his wife and friends it would be easy for an assassin to shoot him from a crowd

- Shortly after Lincoln was shot the telegraph system went down
- Shortly after Kennedy was shot the telephone system went down

- Kennedy's father had been the Ambassador to England at the Court of St James
- Lincoln's son became the Ambassador to England at the Court of St James
- Lincoln and Kennedy were 2 of the greatest presidents of the nation
- Lincoln's wife tastefully and expensively re-decorated the White House
- Kennedy's wife tastefully and expensively re-decorated the White House
- Lincoln loved great literature and could recite poetry by heart
- Kennedy loved great literature and could recite poetry by heart
- Lincoln had young children while living at the White House
- Kennedy had young children while living at the White House
- Lincoln's sons had ponies they rode on the White House grounds
- Kennedy's daughter had a pony she rode on the White House grounds
- Lincoln lost a child (12 year old son) to death while President
- Kennedy lost a child (newly born son) to death while President
- Lincoln had 2 sons named Robert and Edward. Edward died young and Robert lived on.
- Kennedy had 2 brothers named Robert and Edward. Robert died young and Edward lived on
- Lincoln let his children run and play in his office
- Kennedy let his children run and play in his office
- After Lincoln's assassination the nation experienced an emotional convulsion
- After Kennedy's assassination the nation experienced an emotional convulsion
- the whole world cried when Lincoln died
- the whole world cried when Kennedy died
- Lincoln's funeral train travelled from Washington-DC to New York
- Kennedy's brother's funeral train travelled from New York to Washington-DC
- Lincoln Assassination conspiracy theories are believed these 140 141 years later
- Kennedy Assassination conspiracy theories are believed these 42 43 years later
- Abraham was the first name of the man who filmed Kennedy's murder in the Lincoln
- The man running alongside Kennedy's car snapping pictures with his 35mm camera was a salesman of Lincoln cars
- Kennedy bought a Virginia home that was the 1861 Civil War headquarters of Lincoln's first general-in-chief, McClellan
- Jefferson Davis was the name of the president of the Confederate states while Lincoln was president of the Union states
- Jefferson Davis Tippit was the name of the police officer killed allegedly by Kennedy's alleged assassin
- Lincoln was famous for his wit and for telling hilarious stories and anecdotes
- Kennedy was famous for his wit and for telling hilarious stories and anecdotes
- Lincoln was sitting in a rocking chair at Ford's Theater when he was shot
- Kennedy had a special rocking chair he sat in at the White House
- Henry Ford bought the rocking chair Lincoln died in and put it in his museum in Dearborn
- Kennedy's seat in the Lincoln he was sitting in when he was shot is in Ford's museum
- Lincoln's seat in the Ford he was sitting in when he was shot is in Ford's museum
- John Kennedy is the name of a character in a 1951 movie about a detective travelling by train to thwart the assassination of President Lincoln ----NEW
- John Kennedy is the name of the real-life detective who travelled in the train with President Lincoln in 1860 to thwart his assassination