Short Answer TypeConsidering 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.Turnoverimport 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() #IGNOREObserve the following table CANDIDATE 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.
TABLE: CANDIDATE
| No | NAME | STREAM |
| C1 | AJAY | LAW |
| C2 | ADITI | MEDICAL |
| C3 | ROHAN | EDUCATION |
| C4 | RISHAB | ENGINEERING |
RESULT
| No | NAME |
| C3 | ROHAN |
Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii), which are based on the tables
TABLE: BOOK
|
Code |
BNAME |
TYPE |
|
F101 |
The priest |
Fiction |
|
L102 |
German easy |
Literature |
|
C101 |
Tarzan in the lost world |
Comic |
|
F102 |
Untold Story |
Fiction |
|
C102 |
War Heroes |
Comic |
|
MNO |
MNAME |
CODE |
ISSUEDATE |
|
M101 |
RAGHAV SINHA |
L102 |
2016-10-13 |
|
M103 |
SARTHAK JOHN |
F102 |
2017-02-23 |
|
M102 |
ANISHA KHAN |
C101 |
2016-06-12 |
(i) To display all details from table MEMBER in descending order of ISSUEDATE.
(ii) To display the BNO and BNAME of all Fiction Type books from the table BOOK
(iii) To display the TYPE and number of books in each TYPE from the table BOOK
(iv) To display all MNAME and ISSUEDATE of those members from table MEMBER who have books issued (i.e ISSUEDATE) in the year 2017.
(v)SELECT MAX(ISSUEDATE) FROM MEMBER;
(vi) SELECT DISTINCT TYPE FROM BOOK;
(vii) SELECT A.CODE, BNAME, MNO, MNAME FROM BOOK A, MEMBER B WHERE A.CODE=B.CODE ;
(viii) SELECT BNAME FROM BOOK
WHERE TYPE NOT IN ('FICTION', 'COMIC');
State Distributive Laws of Boolean Algebra and verify them using truth table.
(i) X. (Y+Z)= X.Y + X.Z
(ii) X + Y.Z= (X + Y). (X+Z)
Draw the Logic Circuit of the following Boolean Expression using only NAND Gates:
X.Y + Y.Z
Derive a Canonical SOP expression for a Boolean function F, represented by the following truth table:
| U | V | W | F(U,V,W) |
| 0 | 0 | 0 | 1 |
| 0 | 0 | 1 | 0 |
| 0 | 1 | 0 | 1 |
| 0 | 1 | 1 | 1 |
| 1 | 0 | 0 | 0 |
| 1 | 0 | 1 | 0 |
| 1 | 1 | 0 | 1 |
| 1 | 1 | 1 | 0 |
Reduce the following Boolean Expression to its simplest form using K-Map:
F(X,Y,Z,W)= Σ (0,1,2,3,4,5,10,11,14)
Differentiate between Radio Link and Microwave in context of wireless communication technologies.
Long Answer TypeHi-Speed Technologies Ltd is a Delhi based organization which is expanding its office setup to Chandigarh. At Chandigarh office campus, they are planning to have 3 different blocks for HR, Accounts and Logistics related work. Each block has a number of computers, which are required to be connected in a network for communication, data and resource sharing.
As a network consultant, you have to suggest the best network related solutions for them for issues/problems raised in (i) to (iv), keeping in mind the distances between various blocks/locations and other given parameters.
Shortest distances between various blocks/locations:
| HR Block to Accounts Block | 400 meters |
| Accounts Block to Logistics Block | 200 meters |
| Logistics Block to HR Block | 150 meters |
| DELHI Head Office to CHANDIGARH Office | 270 Km |
Number of Computers installed at various blocks are as follows:
| HR Block | 70 |
| Account Block | 50 |
| Logistics Block | 40 |
(i) Suggest the most appropriate block/location to house the SERVER in the
CHANDIGARH Office (out of the 3 Blocks) to get the best and effective
connectivity. Justify your answer.
(ii) Suggest the best wired medium and draw the cable layout (Block to Block) to efficiently connect various Blocks within the CHANDIGARH office compound.
(iii) Suggest a device/software and its placement that would provide data security for the entire network of CHANDIGARH office.
(iv) Which of the following kind of network, would it be
(a) PAN
(b) WAN
(c) MAN
(d) LAN
Switch
