SSITSMentor - CS IP Tasks

Summer computer courses starting soon-
for class 10th onward students.
reserve your seat

RDBMS :

RDBMS stands for Relational Database Management System.

It is called Relational Database Management System (RDBMS) because it is based on the relational model introduced by E.F. Codd.

The data in an RDBMS is stored in database objects which are called as tables. This table is basically a collection of related data entries and it consists of numerous columns and rows.The data in an RDBMS is stored in database objects which are called as tables.

This table is basically a collection of related data entries and it consists of numerous columns and rows.Table is the most common and simplest form of data storage in a relational database.

Every table is broken up into smaller entities called fields.A field is a column in a table that is designed to maintain specific information about every record in the table.

// use of function @ python function

8) Simple Calculator
=
def add(x,z):
# This function is used for adding two numbers
return x + z
def subtract(x, z):
# This function is used for subtracting two numbers
return x - z
def multiply(x, z):
# This function is used for multiplying two numbers
return x * z
def divide(x, z):
# This function is used for dividing two numbers
return x /z
# Now we will take inputs from the user
print ("Please select the operation.")
print ("a. Add")
print ("b. Subtract")
print ("c. Multiply")
print ("d. Divide")

choice = input("Please enter choice (a/ b/ c/ d): ")

num_1 = int (input ("Please enter the first number: "))
num_2 = int (input ("Please enter the second number: "))

if choice == 'a':
print (num_1, " + ", num_2, " = ", add(num_1, num_2))

elif choice == 'b':
print (num_1, " - ", num_2, " = ", subtract(num_1, num_2))

elif choice == 'c':
print (num1, " * ", num2, " = ", multiply(num1, num2))
elif choice == 'd':
print (num_1, " / ", num_2, " = ", divide(num_1, num_2))
else:
print ("This is an invalid input")

5) Reverse of given integer
=>
number = int(input("Enter a positive integer: "))
rev = 0
while(number!=0):
digit = number%10
rev = (rev*10)+digit
number = number//10
print(rev)
-------------------------------------------------------
6) Generate the prime numbers from 1 to N
=>
num =int(input("Enter the range: "))
for n in range(2,num):
for i in range(2,n):
if(n%i==0):
break
else:
print(n)
----------------------------------------------------------
7) To Calculate the sum of the digits in an integer.
=>
num = int(input("Input a four digit numbers: "))
x = num /1000
x1 = (num - x*1000)/100
x2 = (num - x*1000 - x1*100)/10
x3 = num - x*1000 - x1*100 - x2*10
print("The sum of digits in the number is", x+x1+x2+x3)
---------------------------------------------------------------