HTML-1
1. Write an HTML program to incorporate the following:
Headline tags, <P>, Style tags, <HR> with its attributes, <IMG> and insert a background colour.
SOURCE CODE:
<HTML>
<HEAD>
<TITLE>SUPER COMPUTER</TITLE>
</HEAD>
<BODY>
<H1> <center> SUPER COMPUTER </center></H1>
<HR ALIGN=“center” WIDTH=“75%” SIZE=“4” COLOR=“blue”>
<P><B> Super Computer </B> A supercomputer is a type of computer with a high level of
performance as compared to a general-purpose computer. Supercomputers play an important role
in the field of computational science, and are used for a wide range of computationally intensive
tasks in various fields including quantum mechanics, weather forecasting, climate research, oil
and gas exploration, molecular modeling (computing the structures and properties of chemical
compounds, biological macromolecules, polymers, and crystals), and physical simulations (such
as simulations of aerodynamics, of the early moments of the universe, and of nuclear weapons).
They have been essential in the field of cryptanalysis.[3]
<BR><BR>
The <I> SUPER COMPUTER </I> The performance of a supercomputer is commonly
measured in floating-point operations per second (FLOPS) instead of million instructions per
second (MIPS). Since 2022, exascale supercomputers have existed which can perform over 1018
FLOPS.[4] For comparison, a desktop computer has performance in the range of hundreds of
gigaFLOPS (1011) to tens of teraFLOPS (1013).[5][6] Since November 2017, all of the world's
fastest 500 supercomputers run on Linux-based operating systems.[7] Additional research is
being conducted in the United States, the European Union, Taiwan, Japan, and China to build
faster, more powerful and technologically superior exascale supercomputers.[8]
1
<HR ALIGN=“center” WIDTH=“50%” SIZE=“3” COLOR=“green”>
<HR ALIGN=“center” WIDTH=“75%” SIZE=“3” COLOR=“red”>
<IMG SRC="C:\Users\User\Documents\super_computer.jpg" width =“50” HEIGHT=“50”>
</BODY>
</HTML>
OUTPUT:
2
HTML-2
Write an HTML code to get the following output:
Nested Listing
RADIO FREQUENCY IDENTIFICATION TECHNOLOGY
_______________________________________________
_____________________________________________________________
A. WHAT IS IT MADE OF:
• A scanning antenna
• A transceiver with decoder
B. WHAT DOES IT ACHIEVE:
Provides means of communicating with transponder
Provides RFID tag with the energy to communicate
SOURCE CODE:
<HTML>
<HEAD>
<TITLE> Nested Listing</TITLE>
</HEAD>
<BODY BGCOLOR=“Blue” TEXT=“white”>
<H1 ALIGN=“center”> RADIO FREQUENCY IDENTIFICATION TECHNOLOGY
</H1>
<BR>
<HR ALIGN=“center” width=“50%”>
<HR ALIGN=“center” WIDTH=“75”>
<OL TYPE=A”>
3
<LI> WHAT IS IT MADE OF:
</OL>
<UL TYPE=“disc”>
<LI> A scanning antenna
<LI> A transceiver with decoder
</UL>
<OL TYPE=“A” START=“2”>
<LI> WHAT DOES IT ACHIEVE:
</OL>
<UL TYPE=“square”>
<LI> Provides means of communicating with transponder
<LI> Provides RFID tag with the energy to communicate
</UL>
</BODY>
</HTML>
OUTPUT:
4
MS ACCESS – 1
Create the following table called “SCIENCE” using Datasheet View and answer the questions
given below:
S_NO NAME PHY CHEM BIO
S101 CHRISTINA 75 72 73
S102 DAVID 52 60 59
S103 MICHELLE 81 82 78
S104 ISAAC 45 47 49
S105 JACOB 52 60 48
PROCEDURE TO CREATE TABLE:
To create a table using Datasheet View, we can do the following:
1. In the opening screen of MS Access, click on “Blank Access Database” and enter the file
name.
2. In the Access dialog box that appears, select “Table” from the “Objects” menu and click on
“New”.
3. Choose “Datasheet View” and click “OK”.
4. The fields in the table appear by default as Field1, Field2 etc. Rename these fields by
double-clicking on them and enter the desired field names.
5. Once all the desired field names are entered, users are given the option of entering data
directly.
6. Rename the table as “SCIENCE” and save the file once again.
5
1. Display all information about the student called “ISAAC”
SQL:
SELECT *
FROM SCIENCE
WHERE NAME = “ISAAC”;
OUTPUT:
S_NO NAME PHY CHEM BIO
S104 ISAAC 45 47 49
-----------------------------------------------------
2. Calculate the total marks obtained by the students and call it “TOT_SCIENCE”
SQL:
SELECT *, PHY+CHEM+BIO AS TOT_SCIENCE
FROM SCIENCE;
OUTPUT:
S_NO NAME PHY CHEM BIO TOT_SCIENCE
S101 CHRISTINA 75 72 73 220
S102 DAVID 52 60 59 171
S103 MICHELLE 81 82 78 241
S104 ISAAC 45 47 49 141
S105 JACOB 52 60 48 160
-----------------------------------------------------
6
3. List out the names of students securing more than 60 in Physics
SQL:
SELECT NAME
FROM SCIENCE
WHERE PHY>60;
OUTPUT:
NAME
CHRISTINA
MICHELLE
-----------------------------------------------------
4. Display all information about the student who scored the highest mark in Chemistry
SQL:
SELECT *
FROM SCIENCE
WHERE CHEM= (SELECT MAX(CHEM) FROM SCIENCE);
OUTPUT:
S_NO NAME PHY CHEM BIO
S103 MICHELLE 81 82 78
-----------------------------------------------------
7
MS ACCESS – 2
Create the following table called “EMPLOYEE” using Design View and answer the questions
given below:
S_NO EMPLOYEE BASIC DEDUCT NET_PAY
EMP1 FRANCIS 45000 5000 40000
EMP2 GEORGE 52000 4000 48000
EMP3 MARGARET 43000 3000 40000
EMP4 IRENE 64000 5000 59000
EMP5 PAMELA 60000 2500 57500
PROCEDURE TO CREATE TABLE:
To create a table using Design View, we can do the following:
1. In the opening screen of MS Access, click on “Blank Access Database” and enter the file
name.
2. In the Access dialog box that appears, select “Table” from the “Objects” menu and click on
“New”.
3. Choose “Design View” and click “OK”.
4. In the table “Design View” shown on the screen, two options are given – Field Grid Pane
and Field Properties Pane.
5. Enter the field name with appropriate data types.
6. Close the view after naming the table.
7. Open the table once again to start entry of records for the table.
8
1. Display all information about the student called “MARGARET”
SQL:
SELECT *
FROM EMPLOYEE
WHERE EMPLOYEE = “MARGARET”;
OUTPUT:
S_NO EMPLOYEE BASIC DEDUCT NET_PAY
EMP3 MARGARET 43000 3000 40000
-----------------------------------------------------
2. Calculate the total basic pay of all employees and call it TOT_BASIC
SQL:
SELECT SUM(BASIC) AS TOT_BASIC
FROM EMPLOYEE;
TOT_BASIC
264000
-----------------------------------------------------
3. Display all information about the highest paid employee.
SQL:
SELECT *
FROM EMPLOYEE
WHERE NET_PAY= (SELECT MAX(NET_PAY) FROM EMPLOYEE);
OUTPUT:
S_NO EMPLOYEE BASIC DEDUCT NET_PAY
EMP4 IRENE 64000 5000 59000
9
4. Display the names of all employees whose names begin with the letter “F”
SQL:
SELECT EMP_NAME
FROM EMPLOYEE
WHERE NAME LIKE “F*”;
OUTPUT:
EMP_NAME
FRANCIS
-----------------------------------------------------
5. Display all information about the employees whose Basic Pay is greater than 50000 and
deductions less than 6000
SQL:
SELECT *
FROM EMPLOYEE
WHERE BASIC>50000 AND DEDUCT<6000;
OUTPUT:
S_NO EMPLOYEE BASIC DEDUCT NET_PAY
EMP2 GEORGE 52000 4000 48000
EMP4 IRENE 64000 5000 59000
EMP5 PAMELA 60000 2500 57500
-----------------------------------------------------
10