DEPARTMENT OF COMPUTER SCIENCE
WEB DESIGNING PROGRAMS – II PUC
Program 1: Write a HTML program to create a study time table.
<html>
<body text="blue" bgcolor="white">
<h1><center>MY STUDY TIME TABLE FOR THE WEEK</center></h1>
<center>
<table border="10" border color="red">
<tr>
<th>DAYS</th>
<th>SUBJECTS</th>
<th>MORNING STUDY TIME</th>
<th>COLLEGE STUDY TIME</th>
<th>EVENING STUDY TIME</th>
</tr>
<tr>
<td>MONDAY/TUESDAY</td>
<td>KANNADA/ENGLISH</td>
<td>5.30-6.30AM</td>
<td>8.30-4.00PM</td>
<td>7.00-9PM</td>
</tr>
<tr>
<td>WEDNESDAY/THURSDAY</td>
<td>PHYSICS/CHEMISTRY</td>
<td>5.30-6.30AM</td>
<td>8.30-4.00PM</td>
<td>7.00-9PM</td>
</tr>
<tr>
<td>FRIDAY/SATURDAY</td>
<td>MATHS/CS</td>
<td>5.30-6.30AM</td>
<td>8.30-4.00PM</td>
<td>7.00-9PM</td>
</tr>
</table>
</center>
</body>
</html>
Program 2: Write a HTML to create a form with table.
<html>
<body>
<form>
<h1 align="center">APPLICATION FORM</center></h1>
<table BORDER="10" BORDERCOLOR="BLUE" CELLSPACING="3" CELLPADING="25" ALIGN="CENTER">
<tr>
<td>STUDENT NAME</td>
<td><input type="text"></td>
</tr>
<tr>
<td>STUDENT DATE OF BIRTH</td>
<td><input type="text"name="dob"></td>
</tr>
<tr>
<td>STUDENT ADDRESS</td>
<td><textarea rows="2" cols="15" name="description"></textarea>
<p><center>Enter the Contact Address with Pin Code</center></p>
</td>
</tr>
<tr>
<td>SUBJECTS SELECTED</td>
<td>
<input type="checkbox" name="subject" value="PCMC">PCMC
<input type="checkbox" name="subject" value="PCME">PCME
<input type="checkbox" name="subject " value="PCMB">PCMB
</td>
</tr>
<tr>
<td>CATEGORY</td>
<td><select name="dropdown" size="1">
<option value="GM">GM</option>
<option value="3A">3A</option>
<option value="Others">Others</option>
</td>
</tr>
</table>
<center>
<td><input type="button"
value="SUBMIT"></td>
<td><input type="button"
value="RESET"></td>
</center>
</form>
</body>
</html>
DEPARTMENT OF COMPUTER SCEINCE
SQL PROGRAMS – II PUC
EXPERIMENT - I
1) Generate Electricity Bill for customer
Creating table
SQL > create table ebill (rrno varchar2(6), name varchar2(25), units number (4));
Command to check the structure
SQL> desc ebill;
Inserting records
SQL > insert into ebill values (‘A0001’, ‘Rama’,100);
SQL > insert into ebill values (‘A0002’, ‘Lakshamana’,85);
SQL > insert into ebill values (‘A0003’, ‘Bharatha’,120);
Command to view the data of the table
SQL> select * from ebill;
Command to add new field
SQL> alter table ebill add (amount number (6,2));
Command to compute ebill amount
SQL> update ebill set amount = 50;
SQL> update ebill set amount = 50 where name= ‘Rama’;
SQL> update ebill set amount = amount + 100*4.50 + (units – 100) * 5.50 where units > 100;
Command to delete the data
SQL> delete from ebill where name=’Rama’;
SQL> delete from ebill where units=85;
Command to save the data
SQL> commit;
Command to drop the table
SQL> drop table ebill;
...................................................................................................................................................
EXPERIMENT - II
Create a Student Database and Compute the result.
Create table:
SQL>create table student (s_id number (4), name varchar2(25), S1 number(2),
S2 Number(2), S3 number(2), S4 number(2), S5 number (2), S6 number(2);
Command to check the structure
SQL> desc ebill;
Add records:
SQL>Insert into student values (1001, ‘Amar’, 66,78,56,48,99,96);
Command to view the data of the table
SQL> select * from ebill;
Command to add fields total, per, result;
SQL> Alter table student Add (Total number(3), per number(6,2);
Command to calculate total and percentage
SQL>update student set total = (s1 + s2 + s3 + s4 + s5 + s6);
SQL>update student per = total /6;
Command to delete the data
SQL> delete from student where name=’Amar’;
Command to save the data
SQL> commit;
Command to drop the table
SQL> drop table student;
(())
