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.
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 |
Write a method in Python to read lines from a text file DIARY.TXT, and display those lines, which are starting with an alphabet ‘P’.
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