Saturday, 16 November 2013

CREATE TABLE HOSPITAL
(PNo    Int(4)    Primary key,
Name    Varchar(20)    NOT NULL,
Age    Int(2),
Department    Varchar(18),
Dateofadm    Date,
Charges    Double(7,2),
Sex    Char(1));

INSERT INTO HOSPITAL VALUES(1, 'Arprit', 62, 'Surgery', '2008-01-12', 300, 'M');
INSERT INTO HOSPITAL VALUES(2, 'Zarina', 22, 'ENT', '2007-12-12', 250, 'F');
INSERT INTO HOSPITAL VALUES(3, 'Kareem', 32, 'Orthopaedic', '2008-02-19', 200, 'M');
INSERT INTO HOSPITAL VALUES(4, 'Arun', 12, 'Surgery', '2008-01-11', 300, 'M');
INSERT INTO HOSPITAL VALUES(5, 'Zubin', 30, 'ENT', '2008-01-12', 250, 'M');
INSERT INTO HOSPITAL VALUES(6, 'Ketaki', 16, 'ENT', '2008-02-24', 250, 'F');
INSERT INTO HOSPITAL VALUES(7, 'Ankita', 29, 'Cardiology', '2008-02-20', 800, 'F');
INSERT INTO HOSPITAL VALUES(8, 'Zareen', 45, 'Gynaecology', '2008-02-22', 300, 'F');
INSERT INTO HOSPITAL VALUES(9, 'Kush', 19, 'Cardiology', '2008-01-13', 800, 'M');
INSERT INTO HOSPITAL VALUES(10, 'Shilpa', 23, 'Nuclear Medicine', '2008-01-20', 400, 'F');

CREATE TABLE Loan_Account
(AccNo     INT(3) PRIMARY KEY,
Cust_Name     VARCHAR(20) NOT NULL,
Loan_Amount DOUBLE(10,2),
Instalments INT(3),
Int_Rate FLOAT(5,2),
Start_Date DATE,
Interest DOUBLE(8,2));

INSERT INTO LOAN_ACCOUNT (AccNo, Cust_Name, Loan_Amount, Instalments, Int_Rate, Start_Date)
VALUES(1, 'R.K. Gupta', 300000, 36, 12.00, '2009-07-19');
INSERT INTO LOAN_ACCOUNT (AccNo, Cust_Name, Loan_Amount, Instalments, Int_Rate, Start_Date)
VALUES(2, 'S.P. Sharma', 500000, 48, 10.00, '2008-03-22');
INSERT INTO LOAN_ACCOUNT (AccNo, Cust_Name, Loan_Amount, Instalments, Int_Rate, Start_Date)
VALUES(3, 'K.P. Jain', 300000, 36, NULL, '2007-03-08');
INSERT INTO LOAN_ACCOUNT (AccNo, Cust_Name, Loan_Amount, Instalments, Int_Rate, Start_Date)
VALUES(4, 'M.P. Yadav', 800000, 60, 10.00, '2008-06-12');
INSERT INTO LOAN_ACCOUNT (AccNo, Cust_Name, Loan_Amount, Instalments, Int_Rate, Start_Date)
VALUES(5, 'S.P. Sinha', 200000, 36, 12.50, '2010-01-03');
INSERT INTO LOAN_ACCOUNT (AccNo, Cust_Name, Loan_Amount, Instalments, Int_Rate, Start_Date)
VALUES(6, 'P. Sharma', 700000, 60, 12.50, '2008-06-05');
INSERT INTO LOAN_ACCOUNT (AccNo, Cust_Name, Loan_Amount, Instalments, Int_Rate, Start_Date)
VALUES(7, 'K.S. Dhall', 500000, 48, NULL, '2008-03-05');

CREATE TABLE employee (
EMPNO int(11) NOT NULL,
ENAME varchar(20) DEFAULT NULL,
JOB varchar(9) DEFAULT NULL,
MGR int(4) DEFAULT NULL,
HIREDATE date DEFAULT NULL,
SAL float(7,2) DEFAULT NULL,
COMM float(7,2) DEFAULT NULL,
DEPTNO int(2) DEFAULT NULL,
PRIMARY KEY (`EMPNO`),
KEY DEPTNO (`DEPTNO`),
CONSTRAINT employee_ibfk_1 FOREIGN KEY (DEPTNO) REFERENCES deptm (DEPTNO) ON DELETE CASCADE;

CREATE TABLE department (
dept_no char(4) NOT NULL,
deptname varchar(15) DEFAULT NULL,
PRIMARY KEY (dept_no));

CREATE TABLE BANK_AC
    (Acc_no            INT(5) PRIMARY KEY,
    CName        VARCHAR(20) NOT NULL,
    Bname        VARCHAR(30) NOT NULL DEFAULT '' ,
    Amount        DOUBLE(10,2) CHECK (AMOUNT > 5000),
    Dateofopen         DATE,
    T_ID    ENUM('Saving', 'Current'),
    T_Transactions    DOUBLE(7,1));

CREATE TABLE STMARK
(NAME    VARCHAR(25) NOT NULL DEFAULT '' ,
ROLL    INT(3) PRIMARY KEY,
AGE        INT(3) ,
MARKS    DOUBLE(5,2),
Check (Age > 12 and Age < 16));

create table salesperson
(SNum INT(6) PRIMARY KEY,
SFName VARCHAR(25) NOT NULL,
SLName VARCHAR(25) NOT NULL DEFAULT '',
City SET('Delhi', 'Mumbai', 'Kolkata', 'Chennai'),
Sales DOUBLE(9,2),
Comm DOUBLE(8,2));

CREATE TABLE Shops(Id INTEGER, Name VARCHAR(55),
Quality ENUM('High', 'Average', 'Low'));

INSERT INTO Shops VALUES(1, 'Boneys', 'High');
INSERT INTO Shops VALUES(2, 'AC River', 'Average');
INSERT INTO Shops VALUES(3, 'AT 34', 'Low');

CREATE TABLE EMPNEW
(Emp_ID INT(8) PRIMARY KEY,
First_Name VARCHAR(25) NOT NULL,
Last_Name VARCHAR(25) NOT NULL DEFAULT '',
Date_Join DATE,
Basic_Sal DOUBLE(8, 2) CHECK (BASIC_SAL > 5000),
Dept_ID SET('10', '20', '30', '40', '50', '60'));

CREATE TABLE DEPTM
(DEPTNO    IntEGER NOT NULL PRIMARY KEY,
DNAME     Varchar(14),
LOC        Varchar(13));

Create table customers(CustomerID Integer Primary key, Name VARCHAR(25) not null);
Insert into customers values(1, 'Ravi Nayak');
Insert into customers values(2, 'Sudhir Rana');
Insert into customers values(3, 'Amit Kulkarni');
Insert into customers values(4, 'Seema Rout');

CREATE TABLE Book(Book_Id INTEGER, Title TEXT NOT NULL,
Author VARCHAR(25) NOT NULL, Price Float);

Sunday, 1 September 2013

Earn money online

click this link.
register your id.
earn money/recharge minimum amount is 10 Rs.
http://www.amulyam.in/signup.do?id=2859eca9-e28d-484f-ae95-adc5a13d0979

Thursday, 25 July 2013

5 ways to speed up your PC

1. Free up disk space

The Disk Cleanup tool helps you free up space on your hard disk to improve the performance of your computer. The tool identifies files that you can safely delete, and then enables you to choose whether you want to delete some or all of the identified files.

2. Uninstall the programs and games not in use

Uninstall all the softwares and games that are no longer in use, remove the extra startup items from the startup except the sound and antivirus

3. Detect and repair disk errors

In addition to running Disk Cleanup and Disk Defragmenter to optimize the performance of your computer, you can check the integrity of the files stored on your hard disk by running the Error Checking utility.

4. Protect your computer against spyware

Spyware collects personal information without letting you know and without asking for permission. From the Web sites you visit to usernames and passwords, spyware can put you and your confidential information at risk. In addition to privacy concerns, spyware can hamper your computer's performance. To combat spyware, you might want to consider using the PC safety scan from Windows Live OneCare. This scan is a free service and will help check for and remove viruses.

5. Learn all about Ready Boost

If you're using Windows 7 or Windows Vista, you can use ReadyBoost to speed up your system. A new concept in adding memory to a system, it allows you to use non-volatile flash memory—like a USB flash drive or a memory card—to improve performance without having to add additional memory.

By: Vijay Sharma

For more information ask your system administrator

Networking terms and their usage

· Bandwidth - the rated throughput capacity of a given network media or protocol. The amount of data that can be transmitted in a fixed amount of time.

· Backbone - A high-speed link joining together several networks.

· Bit – A unit of information having just two possible values, as either of the binary digits 0 or 1.

· Byte - a series of consecutive binary digits that are operated upon as a unit. There are 8 bits in a byte.

· Category 5 (cat 5) cable -A type of twisted pair network wiring in which there is a certain number of twists per foot. It is the most commonly used network cabling.

· Coaxial Cable - A type of cable consisting of two insulating layers and two conductors most commonly used in older networks.

· Collision - An attempt by two devices to transmit over the network at the same time usually resulting in the data being lost.

· DNS (Domain Name System) – an internet service that translates domain names into IP addresses. For example www.google.com translates to 66.102.7.99.

Dynamic DNS - A method of keeping a domain name linked to a changing IP address using a pool of available IP addresses so you can use applications that require a static IP address.

· Domain - A group of computers and devices on a network that are administered as a unit.

· DHCP ( Dynamic Host Configuration Protocol )– A TCP/IP protocol that dynamically assigns an IP address to a computer. Dynamic addressing simplifies network administration because the software keeps track of IP addresses rather than requiring a network administrator to do so.

Ethernet - Ethernet is the most widely installed local area network technology. It was developed during the late 1970s through a partnership of DEC, Intel, and Xerox.

· Fiber Optic –A cable technology that uses glass (or plastic) threads (fibers) to transmit data. It is a very fast technology

· Gateway - A device on a network that serves as an entrance to another network and routes traffic

· Hardware (MAC) address – A unique address associated with a particular network device

· Hub - A common connection point for computers and devices in a network that takes an incoming signal and repeats it on all other ports

· Internet - Term used to refer to the world's largest internetwork, connecting thousands of networks worldwide. Also known as the world wide web (www)

· IP address - a 32-bit address assigned to hosts using the TCP/IP protocol. Each computer/device on the public internet has a unique IP address. An example of an IP address is 192.168.1.

· LAN (Local Area Network) – computer/data network which is confined in a limited geographical area.

· MAC Address (Media Access Control) - A unique identifier attached to most forms of networking equipment. It is burned into the device and cannot be changed

· Megabit - A measure of data transmission speed – 1 million bits per second or approximately 125,000 characters per second

Megabyte - A unit of measure for memory or hard disk storage capacity. 1024 megabytes = 1 ==++gigabyte.

Network - A group of computers and devices that can communicate with each other and share resources.

Network Interface Card (NIC) – A hardware device inside a computer or other network device that enables communication with a network.

· Packet - The unit of data sent across a network. Data is broken up into packets for sending over a packet switching network.

· PING (Packet Internet Groper) – A command used to test connectivity to a device over a TCP/IP network.

Protocol – Rules determining the format and transmission of data over a network

· RJ-45 - Standard connectors used for unshielded twisted-pair cable. Most commonly used with Cat5 network cabling.

· Route – A path through an internetwork.

· Router – A device that routes/forwards data across a networks.

Server - A computer that handles requests for data, email, files, and other network services from other computers (clients)

· Subnet - A portion of a network that shares a common address component but is on a different segment than the rest of the network.

· TI Line – A high speed dedicated data line that supports a transmission rate of 1.544 Mbps

· TCP/IP - Transmission Control Protocol/Internet Protocol. A suite of protocols used as the basis of the nation's internetwork (Internet). It can also be used on internal networks.

UNC (Universal Naming Convention) Path - A UNC provides a naming convention for identifying network resources. UNC names consist of three parts, a server name, a share name, and an optional file path.

WAN (wide area network) - A network linking together networks located in other geographic areas.

Thursday, 27 June 2013

important USSD codes and SMS commands for idea cellular

(1) Balance inquiry :- *123#, *212#, *130#
(2) Idea service :- *147#
(3) To know your idea number :- *100#
(4) for SMS balance :- *451#
(5) check mobile number :- *789# or *100# ( For Karnataka )
(6) idea menu :- *100#
(7) Activated service for idea 3G :- ACT 3G To 12345
(8) Activated service for idea Live tv :- 3GTV To 54777
(9) Activated service for idea GPRS :- FRESH To 4666
(10) deactivated service for idea Cricket :- UNSUB ONDCKTPOR To 55456

Tuesday, 25 June 2013

important USSD codes and SMS commands for Airtel operators

Dial *555# : Daily and monthly sms packs
Dial *222# : Special five offers
Dial *141# : Airtel Gift services
Dial *325# : Facebook fontwish service
Dial *121# : My Airtel My offer
Dial *123*7# : To check Airtel-to-Airtel special balance
Dial *123*10#: To check Airtel 2G data balance
Dial *123*11#: To check Airtel 3G data balance
Dial *125*5# : To check daily SMS count
Dial *123# : To check Main Balance and Validity
Dial *567# : For Mobile Office Activation and De-Activation
Dial 121 : For Customer Care
Dial 198 : For Complaints
Dial 123 : To Recharge your account
Dial *566# : Musstbuy service
Dial 1909 : To Activate or De-Activate DND service
Dial *515# : Twitter services

Airtel SMS Commands

SMS MRP FULLTT to 51619 : For full talk-time offers.
SMS MRP TRF to 51619 : For all available tariff offers
SMS MRP SMS to 51619 : For available SMS Pack offers
SMS MRP GPRS to 51619 : For available GPRS Packs
SMS 3G to 121 : For Activating 3G or Change 3G Data plan
SMS START to 121/1210 : To start any service
SMS STOP to 121/1210 : To stop any service
SMS FUN to 54321 : To activate Airtel live
SMS LIVE to 52567: To receive Airtel Live Settings

Monday, 24 June 2013

important USSD codes of vodafone

1. *141# – Check main balance

2. *141*9# [M.H.] / *111*6# to check gprs bal.

3. *141*1# to check sms

4. *444*3# for activating internet plan

5. VL TO 144 for configuration

6. WWW to 52586 for advanced gprs config.

7. *555# – To activate GPRS /SMS plan(Not sure about this plz verify )

8. *142# – To know free sms balance

9. *145# – To know calling balance

10. Vodafone gprs data balance send GPRS to 144.

11. *555# and then press call to know your mobile number [Other state Users ]

12. *111*2# Check ur Mob. No. [For Maharashtra state] or *777*0# [For Other state]

13. *111*5*2# or *111*6# Check 3G data plan and remaining data balance.

For Activation of 3G on Prepaid and postpaid sim :
FOR PREPAID USERS : sms ACT 3G to 144
FOR POSTPAID USERS : sms ACT 3G to 111

Information Technology

Saturday, 16 November 2013

ISC Exam 2014 Date sheet

Friday, 15 November 2013

CBSE SAMPLE PAPERS FOR CLASS 12

CBSE EXAM DATES 2014

CBSE 12th Date Sheet 2014

Check CBSE Board 10+2 Time Table 2014 – cbse.nic.in

CBSE 12th Date Sheet 2014 /Check CBSE Board +2 Time Table / Exam Schedule 2014 Download at cbse.nic.in

Wednesday, 6 November 2013

Sample Paper Foundation in Information Technology IX

Sample Paper Foundation in Information Technology: by Vijay Sharma

Thursday, 31 October 2013

How to write a post in hindi on Facebook and Twitter

Request for Game cheat code here for free

Tuesday, 22 October 2013

BlueJ Programs

Thursday, 5 September 2013

SQL commands for Class 12 CBSE Computer Science 083