Considering the following definition of class FACTORY, write a method in Python to search and display the content in a pickled file FACTORY.DAT,where FCTID is matching with the value '105'.
class Factory:
def __init__(self,FID,FNAM):
self.FCTID = FID # FCTID Factory ID
self.FCTNM = FNAM # FCTNM Factory Name
self.PROD = 1000 # PROD Production
def Display(self):
print self.FCTID,':',self.FCTNM,':',self.PROD
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
Draw the Logic Circuit of the following Boolean Expression using only NOR Gates:
( A+B).(C+D)
Derive a Canonical POS expression for a Boolean function G, represented by the following truth table:
X | Y | X | G(X,Y,Z) |
0 | 0 | 0 | 0 |
0 | 0 | 1 | 0 |
0 | 1 | 0 | 1 |
0 | 1 | 1 | 0 |
1 | 0 | 0 | 1 |
1 | 0 | 1 | 1 |
1 | 1 | 0 | 0 |
1 | 1 | 1 | 1 |
Reduce the following Boolean expression to its simplest form using K-Map:
E(U,V,Z,W)= Σ (2,3,6,8,9,10,11,12,13)
Differentiate between communication using Optical Fiber and Ethernet Cable in context of wired medium of communication technologies.
Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii), which are based on the tables.
DVD
DCODE | DTITLE | DTYPE |
F101 | Henry Martin | Folk |
C102 | Dhrupad | Classical |
C101 | The Planets | Classical |
F102 | Universal Soldier | Folk |
R102 | A day in life | Rock |
MEMBER
MID |
NAME |
DCODE |
ISSUEDATE |
101 |
AGAM SINGH |
R102 |
2017-11-30 |
103 |
ARTH JOSEPH |
F102 |
2016-12-13 |
102 |
NISHA HANS |
C101 |
2017-07-24 |
Hi Standard Tech Training Ltd is a Mumbai based organization which is expanding its office set-up to Chennai. At Chennai office compound, they are planning to have 3 different blocks for Admin, Training and Accounts related activities. 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 by them in (i) to (iv), as per the distances between various blocks/locations and other given parameters.
Shortest distances between various blocks/locations:
Admin Block to Account Block | 300 meters |
Accounts Block to Training Block | 150 meters |
Admin Block to Training Block | 200 meters |
MUMBAI Head Office to CHENNAI Office | 1300 KM |
Number of computers installed at various blocks are as follows:
Training Block | 150 |
Accounts Block | 30 |
Admin Block | 40 |
(i) Suggest the most appropriate block/location to house the SERVER in the CHENNAI 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 CHENNAI office compound.
(iii) Suggest a device/software and its placement that would provide data security for the entire network of the CHENNAI office.
(vi) Suggest a device and the protocol that shall be needed to provide wireless Internet access to all smartphone/laptop users in the CHENNAI office.