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 |
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.
Optical Fiber | Ethernet Cable |
These cables are made up of many thin strands of glass that transmit data using light signals. | These cables are comprised of multiple copper wires twisted together that transmit digital information using electrical signals. |
Information sent via optical fibre cables is much more difficult to intercept because light can’t be read in the same way signals sent via copper cabling can be. |
Due to the way in which data is transmitted across Ethernet copper cabling, it is vulnerable to being intercepted. Ethernet switches can help to improve security. |
There are two kinds of the optical fibre; single-mode and multi-mode. |
There are two kinds of Ethernet cable; shielded pair and unshielded pair. |
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.