💫💫DBMS PROGRAM PDF💫💫
💫💫 FULL STACK DEVELOPMENT (FSD)💫💫
Q)Write a program to validate the following fields in a registration page
i.Name (start with alphabet and followed by alphanumeric and the length should
not be less than 6 characters)
ii. Mobile (only numbers and length 10 digits)
iii. E-mail (should contain format like xxxxxxx@xxxxxx.xxx)
CODE👇
<!DOCTYPE html>
<html>
<head>
<title>
validation
</title>
</head>
<body>
<h3>Validation</h3>
<form id="form">
<input type="text" id="name"
placeholder="Enter name" required>
<br>
<input type="text" id="email"
placeholder="Entet email" required>
<br>
<input type="Number" id="number"
placeholder="Enter valid mobile number"
required>
<br>
<button type="submit" id="submit">
SUBMIT
</button>
<div id="message"></div>
</form>
<script>
document.getElementById("form")
.addEventListener("submit",function(event)
{
event.preventDefault();
let name=document.getElementById("name").value;
let email=document.getElementById("email").value;
let message=document.getElementById("message");
let namereg = /^[A-Za-z][A-Za-z0-9]{5,}$/;
let emailreg=/^[^\s@]+@[^\s@]+\.[^\s@]+$/;
let number=document.getElementById("number").value;
let numbereg=/^\d{10}$/;
if(!numbereg.test(number))
{
message.textContent="Enter valid 10 digit mobile number";
return;
}
if(!namereg.test(name)){
message.textContent="enter valid nane";
return;
}
if(!emailreg.test(email))
{
message.textContent="enter valid email";
return;
}
message.textContent="Registration Successfu!";
});
</script>
</body>
</html>
Q)Write a program to display the denomination of the amount deposited in the bank in terms
of 100’s, 50’s, 20’s, 10’s, 5’s, 2’s & 1’s. (Eg: If deposited amount is Rs.163, the output
should be 1-100’s, 1-50’s, 1- 10’s, 1-2’s & 1-1’s)
CODE👇
<!DOCTYPE HTML>
<html>
<head>
<title> amount</title>
</head>
<body>
<button onclick="calculate()">calculate</button>
<script>
function calculate()
{
let dem=[100,50,20,10,5,2,1];
let amount=parseInt(prompt("Enter amount"));
let result="";
for(let i=0;i<dem.length;i++)
{
let a=Math.floor(amount/dem[i]);
if(a>0)
{
result+=a+"-"+dem[i]+"s, ";
amount%=dem[i];
}
}
alert(result.slice(0,-2));
}
</script>
</body>
</html>
<!doctype html>
Q) Write a program to print 1 to 10 numbers using for, while and do-while loops.
CODE👇
<html>
<head>
<title> numbers print</title>
</head>
<body>
<h3>Print upto given number</h3>
<input type="number" id="number" placeholder="Enter a number" required>
<br>
<br>
<button id="submit">Submit</button>
<div id="for"></div>
<br>
<br>
<div id="while"></div>
<br>
<br>
<div id="dow"></div>
<script>
document.getElementById("submit")
.addEventListener("click",function()
{
let num=document.getElementById("number").value;
let out="";
for(let i=1;i<=num;i++)
{
out+=i+" ";
}
document.getElementById("for").innerHTML="using for loop:=>"+out;
let out2="";
let j=1;
while(j<=num)
{
out2+=j+" ";
j++;
} document.getElementById("while").innerHTML="using while loop=>"+out2;
let k=1;
out3="";
do{
out3+=k+" ";
k++;
}
while(k<=num);
document.getElementById("dow").innerHTML="using do while loop=>"+out3;
});
</script>
</body>
</html>
Q)Design a HTML having a text box and four buttons named Factorial, Fibonacci, Prime,
and Palindrome. When a button is pressed an appropriate function should be called to
display
i. Factorial of that number
ii. Fibonacci series up to that number
iii. Prime numbers up to that number
iv. Is it palindrome or not
CODE👇
<!doctype html>
<html>
<head>
<title> palindrome </title>
</head>
<body>
<h2>Palindrome?</h2>
<input type="number" id= "number"
placeholder="enter a number" required>
<br>
<button onclick="palindrome()" id="submit">Palindrome</button>
<button onClick="fact()" id="fact"> Factorial</button>
<button onClick="fibbo()" id="fibbo">Fibbinacci</button>
<button onClick="Prime()" id="Prime">prime numbers</button>
<div id="result"></div>
<div id="result1"></div>
<div id="result2"></div>
<div id="result3"></div>
<script>
function palindrome()
{
let num1=document.getElementById("number").value;
num=num1.toString();
let reverse=num.split('').reverse().join('');
if(num===reverse){
document.getElementById("result").innerHTML="palindrome";
}
else{
document.getElementById("result").innerHTML="Not a palindrome";
}
};
function fact(){
let num=document.getElementById("number").value;
let output=1;
for(let i=1;i<=num;i++)
{
output*=i;
}
document.getElementById("result1").innerHTML=output;
};
function fibbo(){
let num=document.getElementById("number").value;
let j=0;
let output=0+" ";
for(let i=1;i<=num;i++)
{
output+=i+" ";
document.getElementById("result2").innerHTML=output;
}
};
function Prime()
{
let num=document.getElementById("number").value;
let output=" "
for(let i=2;i<=num;i++)
{
let isprime=true;
for(let j=2;j<=Math.sqrt(num);j++)
{
if(i%j===0)
{
isprime=false;
}
}
if(isprime)
{
output+=i+" ";
document.getElementById("result3").innerHTML=output;
}
}
};
</script>
</body>
</html>
Q) Develop a program to determine whether a given number is an ‘ARMSTRONG
NUMBER’ or not.
CODE👇
<!doctype html>
<html>
<head>
<title>Armstrong</title>
</head>
<body>
<h3> Armstrong Number?</h3>
<input type="number" id= "number"
placeholder="enter a number" required>
<button onClick="armstrong()">Submit</button>
<script>
function armstrong(){
let num=document.getElementById("number").value;
let number=parseInt(num);
let temp=number;
let sum=0;
let cube=num.length;
while(temp>0)
{
let digit=temp%10;
sum+=Math.pow(digit,cube);
temp=Math.floor(temp/10);
}
if(sum===number)
{
alert("armstrong number");
}
else{
alert("not an Armstrong no");
}
};
</script>
</body>
</html>
💫💫DATABASE MANAGEMENT SYSTEM(DBMS)💫💫
Q)Queries using Conversion functions (to_char, to_number and to_date),string functions(Concatenation, lpad, rpad, ltrim,rtrim, lower, upper,initcap, length, substr and instr), datefunctions (Sysdate, next_day,add_months, last_day, months_between, least, greatest,trunc,round,to_char, to_date)
SELECT TO_CHAR(12345, '99999') AS num_to_str FROM dual;
-- TO_CHAR (date to string)
SELECT TO_CHAR(SYSDATE, 'DD-Mon-YYYY') AS date_str FROM dual;
-- TO_NUMBER (string to number)
SELECT TO_NUMBER('12345') AS str_to_num FROM dual;
-- TO_DATE (string to date)
SELECT TO_DATE('07-APR-2025', 'DD-MON-YYYY') AS str_to_date FROM dual;
-- Concatenation
SELECT 'Hello' || ' ' || 'World' AS greeting FROM dual;
-- LPAD and RPAD
SELECT LPAD('123', 5, '0') AS left_padded, RPAD('123', 5, '*') AS right_padded FROM dual;
-- LTRIM and RTRIM
SELECT LTRIM(' hello') AS left_trimmed, RTRIM('hello ') AS right_trimmed FROM dual;
-- LOWER and UPPER
SELECT LOWER('ORACLE') AS lower_text, UPPER('oracle') AS upper_text FROM dual;
-- INITCAP
SELECT INITCAP('welcome to oracle') AS initcap_text FROM dual;
-- LENGTH
SELECT LENGTH('Hello World') AS str_length FROM dual;
-- SUBSTR
SELECT SUBSTR('Database', 5, 3) AS substring FROM dual;
-- INSTR
SELECT INSTR('programming', 'g') AS first_g_pos FROM dual;
-- SYSDATE
SELECT SYSDATE AS today FROM dual;
-- NEXT_DAY
SELECT NEXT_DAY(SYSDATE, 'FRIDAY') AS next_friday FROM dual;
-- ADD_MONTHS
SELECT ADD_MONTHS(SYSDATE, 2) AS two_months_later FROM dual;
-- LAST_DAY
SELECT LAST_DAY(SYSDATE) AS month_end FROM dual;
-- MONTHS_BETWEEN
SELECT MONTHS_BETWEEN(TO_DATE('07-APR-2025'), TO_DATE('01-JAN-2025')) AS months_diff FROM dual;
-- LEAST and GREATEST
SELECT LEAST(10, 20, 5), GREATEST(10, 20, 5) FROM dual;
-- TRUNC (date)
SELECT TRUNC(SYSDATE, 'MM') AS first_of_month FROM dual;
-- ROUND (date)
SELECT ROUND(SYSDATE, 'MONTH') AS rounded_date FROM dual;
-- TO_CHAR (for formatting date)
SELECT TO_CHAR(SYSDATE, 'Month DD, YYYY') AS formatted_date FROM dual;
-- TO_DATE (convert string to date)
SELECT TO_DATE('2025-04-07', 'YYYY-MM-DD') AS converted_date FROM dual;
Comments
Post a Comment