BHANUBHAKTA MEMORIAL COLLEGE
PROJECT WORK
(COMPUTER SCIENCE)
SUBMITTED BY: SUBMITTED TO:
Name: Riyaz Shrestha Ms. Sneha Ghimire
Grade: XII MGT Department of computer
PANIPOKHARI, KATHMANDU
2026
A PROJECT WORK ON,
DBMS / PHP / JAVASCRIPT / HTML / C Programming
Submitted as a partial fulfillment of requirement of the curriculum of GRADE-
XII (Computer Science) under National Education Board, Nepal.
SUBMITTED BY:
Riyaz Shrestha
UNDER THE SUPERVISION OF,
Ms. Sneha Ghimire
SUBMISSION DATE:
March 19, 2026
BHANUBHAKTA MEMORIAL COLLEGE
Panipokhari, Kathmandu
CERTIFICATE
This is to certify that Mr/Ms. Riyaz Shrestha has successfully completed his/her project work as per the
requirement of the curriculum of GRADE-XI (Computer Science) under National Education Board, Nepal.
He/She has completed her project work within the prescribed period.
NEB SYMBOL no. / REGISTRATION no. : ______________________
__________________ __________________
Internal Examiner External Examiner
Date:
ACKNOWLEDGEMENT
I would like to express my gratitude to my computer teacher for providing
me with the opportunity to complete this project. This project includes
programs of DBMS, HTML, JavaScript, and PHP, which helped me improve
my practical knowledge of web development.
TABLE OF CONTENT
SECTION TOPIC PROGRAMS
A DBMS
Creating a database and modifying 2
it / storing information using SQL
B C-programming
Series of programs using 15
simple c code, array, pointer,
sting, file handling
C HTML
Basic structure, creating forms, 15
tables
D JAVASCRIPT
Conditional statement, 15
operators, loops, functions,
form handling( GET and
POST)
E PHP
Form handling, 5
conditional statements
A. DBMS
1. Create a database table using SQL commands and modify it.
Creating table,
CREATE TABLE students (
student_id INTEGER PRIMARY KEY,
name TEXT,
email TEXT,
age INTEGER,
course TEXT
);
Inserting records,
INSERT INTO students (student_id, name, email, age, course) VALUES
(1, 'Robert', 'robert@[Link] ', 10, 'Computer Science'),
(2, 'Sam', 'Sam@[Link]', 11, 'Mathematics'),
(3, 'Henry', 'henry@[Link]', 13, 'Physics'),
(4, 'Shyam', 'shyam@[Link]', 13, 'Chemistry'),
(5, 'Nowa', ‘nowa@[Link]', 14, 'Economics');
Altering table,
ALTER TABLE students ADD COLUMN grade TEXT;
SELECT * FROM students;
UPDATE students SET grade = 'A' WHERE student_id = 1;
UPDATE students SET grade = 'B' WHERE student_id = 2;
UPDATE students SET grade = 'B' WHERE student_id = 3;
UPDATE students SET grade = 'C' WHERE student_id = 4;
UPDATE students SET grade = 'A' WHERE student_id = 5;
SELECT * FROM students;
Table with values:
Table with updated values (Grade):
2. Create a database table and display student grades along with their pass/fail status.
Creating table,
CREATE TABLE results (
result_id INTEGER PRIMARY KEY AUTOINCREMENT,
student_id INTEGER,
subject TEXT,
grade TEXT,
marks INTEGER,
status TEXT GENERATED ALWAYS AS (
CASE
WHEN marks >= 40 THEN 'PASS'
ELSE 'FAIL'
END
) STORED,
FOREIGN KEY (student_id) REFERENCES students(student_id)
);
Inserting values,
CREATE TABLE results (
result_id INTEGER PRIMARY KEY AUTOINCREMENT,
student_id INTEGER,
subject TEXT,
grade TEXT,
marks INTEGER,
status TEXT GENERATED ALWAYS AS (
CASE
WHEN marks >= 40 THEN 'PASS'
ELSE 'FAIL'
END
) STORED,
FOREIGN KEY (student_id) REFERENCES students(student_id)
);
SELECT * FROM results;
B. C- PROGRAMMING
1. Write a program to display the largest among 3 numbers.
#include<stdio.h>
int main(){
int a,b,c;
scanf("%d%d%d",&a,&b,&c);
if (a>b&&a>c){
printf("largest=%d",a);
else if (b>a&&b>c){
printf("largest=%d",b);
else if (c>a&&c>b){
printf("largest=%d",c);
else{
printf("numbers are equal");
2. Write a program to check if a number is prime or not.
#include <stdio.h>
int main() {
int num, i, prime = 1;
printf("Enter a positive number: ");
scanf("%d", &num);
if (num <= 1) {
prime = 0;
for (i = 2; i <= num/2; i++) {
if (num % i == 0) {
prime = 0;
if (prime == 0)
printf("%d is a prime number\n", num);
else
printf("%d is not a prime number\n", num);
3. Write a program to print fibonacci series using recursion.
#include <stdio.h>
int fibonacci(int n) {
if (n <= 1)
return n;
else
return fibonacci(n - 1) + fibonacci(n - 2);
int main() {
int n, i;
printf("Enter number of terms: ");
scanf("%d", &n);
printf("Fibonacci Series: ");
for (i = 0; i < n; i++) {
printf("%d ", fibonacci(i));
printf("\n");
4. Write a program to generate fibonacci series.
#include <stdio.h>
int main() {
int n,i,a=0,b=1,c;
printf("Enter number of terms: ");
scanf("%d", &n);
printf("Fibonacci Series: ");
for (i = 0; i < n; i++) {
if(i<=1)
c=i;
else{
c=a+b;
a=b;
b=c;
printf("%d",c);
5. Write a program to check whether a number is palindrome or not.
#include <stdio.h>
int main() {
int num, reversed = 0, remainder, original;
printf("Enter an integer: ");
scanf("%d", &num);
original = num;
while (num != 0) {
remainder = num % 10;
reversed = reversed * 10 + remainder;
num /= 10;
if (original == reversed)
printf("%d is a palindrome\n", original);
else
printf("%d is not a palindrome\n", original);
6. Write a program to find factorial using a loop.
#include <stdio.h>
int main() {
int num, i,factorial = 1;
printf("Enter a positive integer: ");
scanf("%d", &num);
for (i = 1; i <= num; i++) {
factorial *= i;
printf("Factorial = %d", num, factorial);
7. Write a program to print the multiplication table of a number.
#include <stdio.h>
int main() {
int num, i;
printf("Enter a number: ");
scanf("%d", &num);
printf("Multiplication table of %d:\n", num);
for (i = 1; i <= 10; i++) {
printf("%d x %d = %d\n", num, i, num * i);
8. Write a program to reverse any numbers.
#include <stdio.h>
int main() {
int n, rev = 0;
scanf("%d", &n);
while(n > 0) {
rev = rev * 10 + n % 10;
n /= 10;
}
printf("Reverse = %d", rev);
}
output:
9. Write a program to find the sum, product and difference of two numbers using switch case.
#include <stdio.h>
int main()
{
int a, b, s, d, p;
char c;
printf("Enter two numbers: ");
scanf("%d%d", &a, &b);
s = a + b;
p = a * b;
d = a - b;
printf("Enter case (1-add, 2-multiply, 3-subtract): ");
scanf(" %c", &c);
switch(c)
{
case '1':
printf("%d is the sum", s);
break;
case '2':
printf("%d is the product", p);
break;
case '3':
printf("%d is the difference", d);
break;
default:
printf("Invalid choice");
}
}
Output:
10. WAP to swap two integers using pointer.
#include <stdio.h>
void swap(int *x, int *y)
{
int temp;
temp = *x;
*x = *y;
*y = temp;
}
int main()
{
int a, b;
printf("Enter two integers: ");
scanf("%d%d", &a, &b);
printf("Before swapping: a = %d, b = %d\n", a, b);
swap(&a, &b);
printf("After swapping: a = %d, b = %d", a, b);
}
Output:
11. Write a program to find the sum of digits.
#include <stdio.h>
int main() {
int num, sum = 0, digit;
printf("Enter a number: ");
scanf("%d", &num);
while (num > 0) {
digit = num % 10;
sum += digit;
num /= 10;
}
printf("Sum of digits: %d\n", sum);
}
12. Write a program to check leap year.
#include <stdio.h>
int main() {
int year;
printf("Enter a year: ");
scanf("%d", &year);
if ((year % 400 == 0) || (year % 4 == 0 && year % 100 != 0))
printf("%d is a leap year\n", year);
else
printf("%d is not a leap year\n", year);
}
13. Write a program to print the sum of array elements.
#include <stdio.h>
int main() {
int arr[100], n, i, sum = 0;
printf("Enter number of elements: ");
scanf("%d", &n);
printf("Enter %d elements: ", n);
for (i = 0; i < n; i++) {
scanf("%d", &arr[i]);
sum += arr[i];
}
printf("Sum of array elements = %d\n", sum);
}
14. Write a program to count vowels in a string.
#include <stdio.h>
#include <string.h>
int main() {
char str[100];
int i, vowels = 0;
printf("Enter a string: ");
gets(str);
for (i = 0; str[i] != '\0'; i++) {
if (str[i] == 'a' || str[i] == 'e' || str[i] == 'i' ||
str[i] == 'o' || str[i] == 'u' || str[i] == 'A' ||
str[i] == 'E' || str[i] == 'I' || str[i] == 'O' ||
str[i] == 'U') {
vowels++;
}
}
printf("Number of vowels: %d\n", vowels);
}
15. Write a program to display student records using structure.
#include <stdio.h>
struct student {
int roll;
char name[50];
float marks;
};
int main() {
struct student s;
printf("Enter Roll Number: ");
scanf("%d", &[Link]);
printf("Enter Name: ");
scanf("%s", [Link]);
printf("Enter Marks: ");
scanf("%f", &[Link]);
printf("\n--- Student Record ---\n");
printf("Roll Number: %d\n", [Link]);
printf("Name: %s\n", [Link]);
printf("Marks: %.2f\n", [Link]);
}
C. HTML
1. Write a program to display ‘Hello World’.
<!DOCTYPE html>
<html>
<head>
<title>My First HTML Page</title>
</head>
<body>
<h1>Hello World!</h1>
<p>This is my first webpage.</p>
</body>
</html>
2. Write a program to display different types of headings.
<!DOCTYPE html>
<html>
<head>
<title>Headings Example</title>
</head>
<body>
<h1>Heading 1</h1>
<h2>Heading 2</h2>
<h3>Heading 3</h3>
<h4>Heading 4</h4>
<h5>Heading 5</h5>
<h6>Heading 6</h6>
</body>
</html>
3. Write a program to display paragraphs and line breaks.
<!DOCTYPE html>
<html>
<head>
<title>Paragraph Example</title>
</head>
<body>
<p>This is the first paragraph.</p>
<p>This is the second paragraph.</p>
<p>This is a paragraph<br>with a line break.</p>
</body>
</html>
4. Write a program that display bold, italic and underline function (Text Formatting).
<!DOCTYPE html>
<html>
<head>
<title>Text Formatting</title>
</head>
<body>
<b>Bold Text</b><br>
<i>Italic Text</i><br>
<u>Underline Text</u><br>
<b><i>Bold & Italic</i></b>
</body>
</html>
5. Write a program to display different types of lists.
<!DOCTYPE html>
<html>
<head>
<title>Lists Example</title>
</head>
<body>
<h3>Ordered List</h3>
<ol>
<li>Apple</li>
<li>Mango</li>
<li>Banana</li>
</ol>
<h3>Unordered List</h3>
<ul>
<li>Football</li>
<li>Basketball</li>
<li>Cricket</li>
</ul>
</body>
</html>
6. Write a program to display marquee tag.
<!DOCTYPE html>
<html>
<head>
<title>Marquee</title>
</head>
<body>
<marquee>Welcome to My Webpage</marquee>
</body>
</html>
7. Write a program to highlight text with mark tag.
<!DOCTYPE html>
<html>
<head>
<title>Highlight Example</title>
</head>
<body>
<p>This is a <mark>highlighted</mark> word in a sentence.</p>
</body>
</html>
8. Write a program to color the background of webpage.
<!DOCTYPE html>
<html>
<head>
<title>Background Color</title>
</head>
<body style="background-color:lightblue;">
<h1>Colored Background</h1>
<p>This page has a light blue background.</p>
</body>
</html>
9. Write a program to add hyperlink to html file.
<!DOCTYPE html>
<html>
<head>
<title>Link Example</title>
</head>
<body>
<p>Click this link to go to Wikipedia:</p>
<a href="[Link] to Wikipedia</a>
</body>
</html>
10. Write a program to insert images in html.
<!DOCTYPE html>
<html>
<head>
<title>Image Example</title>
</head>
<body>
<h2>Image</h2>
<img src="[Link]" width="300" alt="Sample Image">
</body>
</html>
11. Write a program to make a table in html.
<!DOCTYPE html>
<html>
<head>
<title>Table Example</title>
</head>
<body>
<h2>Student Marks</h2>
<table border="1">
<tr>
<th>Subject</th>
<th>Marks</th>
</tr>
<tr>
<td>Math</td>
<td>67</td>
</tr>
<tr>
<td>English</td>
<td>21</td>
</tr>
</table>
</body>
</html>
12. Write a program to make table using rowspan and colonspan.
<!DOCTYPE html>
<html>
<head>
<title>Table Span Example</title>
</head>
<body>
<h2>Schedule</h2>
<table border="1">
<tr>
<th>Time</th>
<th>Monday</th>
<th>Tuesday</th>
<th>Wednesday</th>
</tr>
<tr>
<td>9:00-10:00</td>
<td rowspan="2">Math</td>
<td colspan="2">English</td>
</tr>
<tr>
<td>10:00-11:00</td>
<td>Science</td>
<td>Nepali</td>
</tr>
</table>
</body>
</html>
13. Write a program to create a simple form.
<!DOCTYPE html>
<html>
<head>
<title>Simple Form</title>
</head>
<body>
<h2>Form</h2>
<form>
Name: <input type="text"><br><br>
Email: <input type="email"><br><br>
<input type="submit" value="Submit">
</form>
</body>
</html>
14. Write a program to use nested list.
<!DOCTYPE html>
<html>
<head>
<title>Nested List</title>
</head>
<body>
<h2>Fruits</h2>
<ul>
<li>Citrus
<ul>
<li>Orange</li>
<li>Lemon</li>
</ul></li>
<li>Berries
<ul>
<li>Strawberry</li>
<li>Blueberry</li>
</ul> </li>
</ul>
</body>
</html>
15. Write a program to divide sections.
<!DOCTYPE html>
<html>
<head>
<title>Div Example</title>
</head>
<body>
<div style="background-color:gold;">
<h2>Section Title</h2>
<p>This is inside a div.</p>
</div>
</body>
</html>
D. JAVASCRIPT
1. Write a program to check whether the entered age is adult or minor.
<!DOCTYPE html>
<html>
<body style="background-color: grey;">
<h2>If Statement</h2>
<script>
let age = parseInt(prompt("Enter your age:"));
if(age >= 18) {
[Link]("You are an adult");
} else {
[Link]("You are not an adult");
}
</script>
</body>
</html>
2. Write a program to check whether a number is even or odd.
<!DOCTYPE html>
<html>
<body style="background-color: grey;">
<h2>If-Else Statement</h2>
<script>
let num = parseInt(prompt("Enter a number:"));
if(num % 2 == 0) {
[Link](num + " is Even");
} else {
[Link](num + " is Odd");
}
</script>
</body>
</html>
3. Write a program to check whether a number is positive, negative or zero.
<!DOCTYPE html>
<html>
<body style="background-color: grey;">
<h2>if else if statement</h2>
<script>
let num = parseInt(prompt("Enter a number:"));
if(num > 0) {
[Link](num + " is Positive");
}
else if(num < 0) {
[Link](num + " is Negative");
}
else {
[Link]("The number is Zero");
}
</script>
</body>
</html>
4. Write a program to print any day of the week.
<!DOCTYPE html>
<html>
<body style="background-color: grey;">
<h2>Switch Statement</h2>
<script>
let day = parseInt(prompt("Enter day:"));
let dayName;
switch(day) {
case 1: dayName = "Sunday"; break;
case 2: dayName = "Monday"; break;
case 3: dayName = "Tuesday"; break;
case 4: dayName = "Wednesday"; break;
case 5: dayName = "Thursday"; break;
case 6: dayName = "Friday"; break;
case 7: dayName = "Saturday"; break;
default: dayName = "Invalid day";
}
[Link]("Day is:" + dayName);
</script>
</body>
</html>
5. Write a program to print from 1 to 10.
<!DOCTYPE html>
<html>
<body style="background-color: grey;">
<h2>for loop</h2>
<script>
[Link]("Numbers from 1 to 5: ");
for(let i = 1; i <= 5; i++) {
[Link](i + " ");
}
</script>
</body>
</html>
6. Write a program to print the sum of the first 5 numbers.
<!DOCTYPE html>
<html>
<body style="background-color: grey;">
<h2>While Loop</h2>
<script>
let sum = 0;
let i = 1;
while(i <= 5) {
sum = sum + i;
i++;
}
[Link]("Sum of first 5 numbers = " + sum);
</script>
</body>
</html>
7. Write a program to print even numbers.
<!DOCTYPE html>
<html>
body style="background-color: grey;">
<h2>Do-While Loop</h2>
<script>
let i = 2;
[Link]("Even numbers: ");
do {
[Link](i + " ");
i += 2;
} while(i <= 10);
</script>
</body>
</html>
8. Write a program to display any text using function.
<!DOCTYPE html>
<html>
<head>
<title>Function Example</title>
</head>
<body style="background-color: grey;">
<button onclick="greet()">Click Me</button>
<script>
function greet() {
alert("Hello!");
}
</script>
</body>
</html>
9. Write a program to create a form and submit your name.
<!DOCTYPE html>
<html>
<head>
<title>Form Validation</title>
</head>
<body style="background-color: grey;">
<form>
Name: <input type="text" id="name">
<button type="button" onclick="validate()">Submit</button>
</form>
<script>
function validate() {
let n = [Link]("name").value;
if(n == "")
alert("Field cannot be empty");
else
alert("Form Submitted");
}
</script>
</body>
</html>
10. Write a program to demonstrate on click.
<!DOCTYPE html>
<html>
<head>
<title>Button Click Example</title>
</head>
<body style="background-color: grey;">
<h2>Simple Button Program</h2>
<button onclick="alert('Button Clicked')">Click</button>
</body>
</html>
11. Write a program to print sum and product using global variable.
<!DOCTYPE html>
<html>
<body style="background-color: grey;">
<h2>using Global Variables</h2>
<script>
let a = 10, b = 5;
let sum = a + b;
let product = a * b;
[Link]("Sum = " + sum + "<br>");
[Link]("Product = " + product);
</script>
</body>
</html>
12. Write a program to print sum and product using local variable.
<!DOCTYPE html>
<html>
<body style="background-color: grey;">
<h2>using local variable</h2>
<script>
function calculate() {
let a = parseInt(prompt("Enter first number:"));
let b = parseInt(prompt("Enter second number:"));
let s = a + b;
let p = a * b;
[Link]("First number: " + a + "<br>");
[Link]("Second number: " + b + "<br>");
[Link]("s = " + s + "<br>");
[Link]("p = " + p);
}
calculate();
</script>
</body>
</html>
13. Write a program to print a day from the week.
<!DOCTYPE html>
<html>
<body style="background-color: grey;">
<h2>Switch Case</h2>
<script>
let day = parseInt(prompt("Enter day number (1-7):"));
switch(day) {
case 1: [Link]("Sunday"); break;
case 2: [Link]("Monday"); break;
case 3: [Link]("Tuesday"); break;
case 4: [Link]("Wednesday"); break;
case 5: [Link]("Thursday"); break;
case 6: [Link]("Friday"); break;
case 7: [Link]("Saturday"); break;
default: [Link]("Invalid");
}
</script>
</body>
</html>
14. Write a program to calculate simple interest and amount.
<!DOCTYPE html>
<html>
<head>
<title>Simple Interest</title>
</head>
<body style="background-color: grey;">
<h2>Simple Interest Calculator</h2>
<script>
let p = parseFloat(prompt("Enter Principal:"));
let r = parseFloat(prompt("Enter Rate:"));
let t = parseFloat(prompt("Enter Time:"));
let si = (p * r * t) / 100;
let amount = p + si;
[Link]("P:" + p + "<br>");
[Link]("R: " + r + "<br>");
[Link]("T: " + t + "<br>");
[Link]("Si:" + si + "<br>");
[Link]("Total Amount:" + amount);
</script>
</body>
</html>
15. Write a program to check whether the number is positive, negative or zero.
<!DOCTYPE html>
<html>
<head>
<title>check number</title>
</head>
<body style="background-color:grey;">
<script>
let num = parseFloat(prompt("Enter a number:"));
if(num > 0) {
[Link](num + "Positive");
}
else if(num < 0) {
[Link](num + "Negative");
}
else {
[Link]("Zero");
}
</script>
</body>
</html>
E. PHP
1. Write a program to display “Hello World”.
<!DOCTYPE html>
<html>
<head>
<title>PHP Hello World</title>
</head>
<body>
<h2>PHP Hello World Example</h2>
<?php
echo "Hello World!";
?>
</body>
</html>
2. Write a program to display the sum of two numbers.
<!DOCTYPE html>
<html>
<head>
<title>PHP Variables Example</title>
</head>
<body>
<h2>Addition</h2>
<?php
$a = 10;
$b = 5;
$sum = $a + $b;
echo "The sum of $a and $b is $sum";
?>
</body>
</html>
3. Write a program to display your favorite fruit using an array.
<!DOCTYPE html>
<html>
<head>
<title>PHP Arrays</title>
</head>
<body>
<h1>Array</h1>
<?php
$fruits = ["Apple", "Banana", "Mango"];
echo "My favorite fruit is " . $fruits[2];
?>
</body>
</html>
4. Write a program to display if the user is adult or minor.
<!DOCTYPE html>
<html>
<head>
<title>PHP Conditionals</title>
</head>
<body>
<h1>Adult or Minor</h1>
<?php
$age = 18;
if($age >= 18){
echo "You are an adult.";
} else {
echo "You are a minor.";
}
?>
</body>
</html>
5. Write a program to make a form using the GET method.
<!DOCTYPE html>
<html>
<head>
<title>Simple GET Form</title>
</head>
<body>
<h1>Simple Form using GET Method</h1>
<form action="" method="get">
NAME: <input type="text" name="name" required><br><br>
AGE: <input type="number" name="age" required><br><br>
GENDER:
<input type="radio" id="male" name="gender" value="Male" required>
<label for="male">Male</label>
<input type="radio" id="female" name="gender" value="Female">
<label for="female">Female</label><br><br>
<input type="submit" value="Submit">
</form>
<?php
if(isset($_GET['name']) && isset($_GET['age']) && isset($_GET['gender'])){
$name = $_GET['name'];
$age = $_GET['age'];
$gender = $_GET['gender'];
echo "<h2>User Input:</h2>";
echo "Name: " . htmlspecialchars($name) . "<br>";
echo "Age: " . htmlspecialchars($age) . "<br>";
echo "Gender: " . htmlspecialchars($gender);
}
?>
</body>
</html>
CONCLUSION
This project helped me understand the concepts of Web Technology,
including HTML, JavaScript, PHP, and DBMS. Through practical programs, I
learned how to create web pages, apply conditional statements and loops in
JavaScript, handle forms using PHP, and manage data using SQL and
database concepts. This project improved my practical knowledge and
programming skills.
REFERENCES
● CDC (2025) Grade 12 Computer Science.
● OpenAI (2026) ChatGPT.
● School Notes (2026) Web Technology, unpublished class notes.
● W3Schools (2026) HTML, JavaScript and PHP Tutorials.