Differentiate between the following:
Write a method in python to read the content from a text file diary.txt line by line and display the same on screen.
def read_file():
inFile = open('diary.txt', 'r')
for line in inFile:
print line
Observe the following table MEMBER carefully and write the name of the RDBMS operation out of (i) SELECTION (ii) PROJECTION (iii) UNION (iv) CARTESIAN PRODUCT, which has been used to produce the output as shown in RESULT. Also, find the Degree and Cardinality of the RESULT.
NO | MNAME | STREAM |
M001 | JAYA | SCIENCE |
M002 | ADIYTA | HUMANITIES |
M003 | HANSRAJ | SCIENCE |
M004 | SHIVAK | COMMERCE |
NO | MNAME | STREAM |
M002 | ADIYTA | HUMANITIES |
SELECTION
Degree of table RESULT=3
Cardinality of table RESULT = 2
Considering the following definition of class COMPANY, write a method in Python to search and display the content in a pickled file COMPANY.DAT, where CompID is matching with the value ‘1005’.
class Company:
def __init__(self,CID,NAM):
self.CompID = CID #CompID Company ID
self.CName = NAM #CName Company Name
self.Turnover = 1000
def Display(self):
print self.CompID,':',self.CName,':',self.Turnover
import pickle
def ques4c():
f=Factory()
file=open('COMPANY.DAT','rb')
try:
while True:
f=pickle.load(file)
if f.CompID==1005:
f.Display()
except EOF Error:
pass
file.close() #IGNORE