INDEX
PYTHON PROGRAMS:
1. WAP to display the sum of numbers from 1 to 10 using for loop.
2. WAP to find the largest of three numbers using if-elif-else. Accept the numbers from
the user.
3. WAP to calculate the factorial of a number using while loop. Accept the number from
the user.
4. WAP to print the multiplication table of a number using for loop. Accept the number
from the user. e.g., the pattern displayed must be 3X2=6
5. WAP to print the Fibonacci series up to n terms using a for loop.
6. WAP to check whether a person is eligible to vote or not.
7. WAP to check whether the entered year is a leap year or not.
8. WAP to print all prime numbers from 1 to 100.
9. Write a menu driven program for the following options of calculator:
a. Addition
b. Subtraction
c. Multiplication
d. Division
e. exponentiation
[Link] a menu-driven program
a. to check whether a number is even or odd using if-else.
b. to check whether a number is positive, negative or zero.
c. to count the number of vowels, present in the string.
d. To check there a number is palindrome or not.
MySQL Commands:
[Link] a table named 'students' with columns for student ID, name, class, age and
contact number where studentID is primary key and contact number is NOT NULL.
[Link] 10 records into the 'students' table
[Link] the class of a student in the 'students' table
[Link] a record from the 'students' table
[Link] all records from the 'students' table
PYTHON PROGRAMS:
WAP to find the largest of three numbers using if-elif-else. Accept the
numbers from the user.
Program:
Output:
WAP to find the largest of three numbers using if-elif-else. Accept the numbers from the
user.
Program:
Output:
WAP to calculate the factorial of a number using while loop. Accept the
number from the user.
Program:
Output:
WAP to print the multiplication table of a number using for loop. Accept
the number from the user. e.g., the pattern displayed must be 3X2=6
Program:
Output:
WAP to print the Fibonacci series up to n terms using a for loop.
Program:
Output:
WAP to check whether a person is eligible to vote or not.
Program:
Output:
WAP to check whether the entered year is a leap year or not.
Program:
Output:
WAP to print all prime numbers from 1 to 100.
Program:
Output:
Write a menu driven program for the following options of calculator:
a) Addition
b) Subtraction
c) Multiplication
d) Division
e) Exponentiation
Program:
Output:
Write a menu-driven program
a) to check whether a number is even or odd using if-else.
b) to check whether a number is positive, negative or zero.
c) to count the number of vowels, present in the string.
d) To check there a number is palindrome or not.
Program:
Output:
MYSQL COMMANDS:
Create a table named 'students' with columns for student ID, name,
class, age and contact number where studentID is primary key and
contact number is NOT NULL.
Command & Output:
Insert 10 records into the 'students' table.
Command:
Output:
Update the class of a student in the 'students' table.
Command & Output:
Delete a record from the 'students' table.
Command:
Output:
Display all records from the 'students' table.
Command & Output: