HTML 1: Study Time Table
<html>
<head><title>My Study Time Table</title>
</head>
<body>
<center>
<h1><U>My Study Time Table</U></h1>
<table border=2>
<tr>
<th>Day</th>
<th>5.30AM - 7.30AM</th>
<th>8.00AM - 4.00PM</th>
<th>5.30PM - 7.00PM</th>
<th>7.30PM - 9.00PM</th>
</tr>
<tr>
<th>Monday</th>
<th>English TB</th>
<th>College</th>
<th>English NB</th>
<th>Previous QP</th>
</tr>
<tr>
<th>Tuesday</th>
<th>Kannada TB</th>
<th>College</th>
<th>Kannada NB</th>
<th>Previous QP</th>
</tr>
<tr>
<th>Wednesday</th>
<th>Economics TB</th>
<th>College</th>
<th>Economics NB</th>
<th>Previous QP</th>
</tr>
<tr>
<th>Thursday</th>
<th>Business Studies TB</th>
<th>College</th>
<th>Business Studies NB</th>
<th>Previous QP</th>
</tr>
<tr>
<th>Friday</th>
<th>Computer Science TB</th>
<th>College</th>
<th>Computer Science NB</th>
<th>Previous QP</th>
</tr>
<tr>
<th>Saturday</th>
<th>Statistics TB</th>
<th>College</th>
<th>Statistics NB</th>
<th>Previous QP</th>
</tr>
</table>
</center>
</body>
</html>
HTML 2: Forms and Tables
<html>
<head>
<title>My Online Application</title>
</head>
<body>
<form>
<center>
<h1>My Online Application</h1>
<table>
<tr>
<td>STUDENT'S NAME:</td>
<td><input type=text></td>
</tr>
<tr>
<td>FATHER'S NAME:</td>
<td><input type=text></td>
</tr>
<tr>
<td>UPLOAD FILE:</td>
<td><input type=file></td>
</tr>
<tr>
<td>GENDER:</td>
<td><input type=radio>Male
<input type =radio>Female
<input type=radio>Others
</td>
</tr>
<tr>
<td>ADDRESS:</td>
<td><textarea rows=4 cols=20>Enter the address</textarea></td>
</tr>
<tr>
<td>Category:</td>
<td><select>
<option>GM</option>
<option>SC</option>
<option>ST</option>
<option>2A</option>
<option>2B</option>
</select>
</td>
</tr>
<tr>
<td>Board Passed:</td>
<td><select>
<option>CBSE</option>
<option>ICSE</option>
<option>IGCSE</option>
<option>State</option>
<option>IB</option>
</select>
</td>
</tr>
<tr>
<td>Subjects:</td>
<td><input type=checkbox>Kannada
<input type=checkbox>English
<input type=checkbox>Maths
<input type=checkbox>Science
<input type=checkbox>CS
<input type=checkbox>Hindi
</td>
</tr>
<tr>
<td><input type=submit></td>
<td><input type=reset></td>
</tr>
</table>
</form>
</center>
</body>
</html>
SQL 1: Electricity Bill
To create the table bill:
create table bill(rrno varchar(10), name varchar(20), bdate date, units numeric(4));
To insert the records in the table bill:
insert into bill values('BAHO001','Ramesh Kumar','2025/01/01',120);
insert into bill values('BAHO002','Mahesh Kumar','2025/01/02',220);
To display the structure of the table:
desc bill;
To alter the table bill:
alter table bill add(bamt numeric(6,2),ddate date);
To Compute the bill amount :
For customers consuming less than 100 units
update bill set bamt = 50 + units * 4.50 where units <= 100;
For customers consuming more than 100 units
Update bill set bamt = 50 + (100 * 4.50) + (units – 100)* 5.50 where units >100;
To Compute the Due date:
Update bill set ddate = bdate + 15;
To display the list of customers:
Select * from bill;
SQL 2: Student Database
To create the table class:
create table class(idno numeric(4), sname varchar(15), sub1 numeric(3), sub2
numeric(3), sub3 numeric(3), sub4 numeric(3),sub5 numeric(3), sub6 numeric(3));
To insert the records in the table class:
insert into class values(1401,'Ramesh Kumar',56,36,56,78,44,67);
insert into class values(1402,'Mahesh Kumar',100,100,96,97,88,99);
insert into class values(1403,’Ranjith Raj’,34,56,76,45,78,88);
To display the structure of the table:
desc class;
To alter the table class:
alter table class add(total numeric(3),percentage numeric(6,2),result varchar(10));
To Compute the total and percentage :
update class set total = sub1 + sub2 + sub3 +sub4 + sub5 + sub6;
update class set percentage = total/6;
To Compute the result:
Update class set result = ‘PASS’ where (sub1>=35 and sub2>=35 and sub3>=35 and
sub4>=35 and sub5>=35 and sub6>=35);
Update class set result = ‘FAIL’ where (sub1<35 or sub2<35 or sub3<35 or sub4<35
or sub5<35 or sub6<35);
Retrieve all the contents of the table:
Select * from class;
Retrieve only idno and sname:
Select idno, sname from class;
List the students who have result as ‘PASS’:
Select * from class where result=’PASS’;
List the students who have result as ‘FAIL’:
Select * from class where result=’FAIL’;
Count the number of students who have passed:
Select count(*) from class where result=’PASS’;
Count the number of students who have failed:
Select count(*) from class where result=’FAIL’;
List the students who have percentage greater than 60:
Select * from class where percentage>60;
Sort the table according to the order of idno:
Select * from class order by idno;