Uncategorized

Primary Key Foreign Key It identifies the each record in a table uniquely. It maintains the relation between two tables. A foreign key is primary key in another related table. A table can have only one Primary key. A table can have more than one Foreign key. Primary key cannot have NULL values. Foreign key […]

Database Schema Database State Database Schema represent overall design of the database. Database state represent current state of data in database. Database schema is changed ocassionally Database state is changed frequently Initially when defining a database, only Database schema is specified Initially when defining a database, database state is empty state.

Foreign Key is used to represent the relation between two tables. Because in the field with Foreign key attribute data comes from Primary key field in another related table and so Foreign key are allowed to have Null Values if it not the part of Primary key field of the related table. For example- Here

a) Collection of logically related records.b) DBMS creates a file that contains description about the data stored in the database.c) Attribute that can uniquely identify tuples in a relationd) Special value that is stored when actual data value is unknown for an attribute.e) An attribute which can uniquely identify tuples of the table but is

(a)for I in range (20,30,2):print(i)(b)country = ‘INDIA’for i in country:print (i)(c)i=0; sum = 0while i < 9 :if i % 4 == 0:sum = sum + ii = i + 2print (sum) Ans: (a) Will display output2022242628        (b) Will display outputINDIA (c) Will display output 12

To implement conditions in a program we always use if statement. We can use single if statement or multiple if statement as per our situation. When we want to implement multiple if statement than we use if…elif…else statement in python. Here ‘eleif’ is short form of ‘else if’ which is used in other languages. We

from datetime import datedates = date.today()name = input(“Enter your Name”)age = int(input(“Enter your Age”))diff = 100 – ageresult_year = dates.year + diffprint(“You will turn 100 years old in “, result_year)

num1 = int(input(“Enter Num1”)num2 = int(input(“Enter Num2”)num3 = int(input(“Enter Num3”)average = (num1 + num2 + num3 )/3print(“Average = “, average)

n = int(input(“How many times you want to repeat message”))for num in range(n):    print(“GOODMORNING”)   

P = int(input(“Enter Principal Amount or Money lent”))R= int(input(“Enter Rate of Interest”))T = int(input(“Enter Time Period”))SI = (P*R*T)/100amt = P + SIprint(“Amount Payable is = ” , amt)