Firewall: A system designed to prevent unauthorized access to or from a private network is called firewall. It can be implement in both hardware and software or combination of both.
VOIP: It is a methodology and group of technologies for delivering voice communications and multimedia sessions over IP networks, such as the Internet

Packet switching	Message switching
(i) There is a tight upper limit on the block size. A fixed size of packet is specified.	(i) In message switching, there was no upper limit.
(ii) All the packets are stored in main memory in switching office.	(ii) In message switching, packets are store on disk.This increases the performance as access.

Two advantages of using optical fibres are:
(i) Capable of extremely high speed.
(i) No electromagnetic interference.

Advantage of Bus topology is that the cable length required for this topology is the least compared to the other networks.

A router establishers connection between two networks and it can handle network with different protocols. Using a routing table, routers make sure that the data packets are traveling through the best possible paths to reach their destination

(i) Bus Topology
(ii) Star Topology

(i) VOIP [VoiceOver Internet Protocol]
(ii) IRC [Internet Relay chat]

Parameter	Usage
Dsn	Data source name. This usually includes the name of your database and the server where it is running.
Host	Host, or network system name, on which the database runs.
Database	Name of the database
User	User name for connecting to the database
Password	Password for the given user name

import MySQLdb
try:
db=MySQLdb.connect( ('localhost' .storemanager' ,'welcometostore123' .Tnventory') 
print "connected to the database"
except:
print "unable to connect to the database"

import MySQLdb
db = MySQLdb.connect('localhost' ,'HRMan','HRman@pwd','compvtLtd')
cursor=db, cursor()
cursor.execute("Drop Table Employee")
sql="""Create Table Employee(' Emp_id' INT
NOTNULL, 'Empriarne' char(50) NOTNULL,
'Dept' char(20)
NOTNULL, 'Age' INT NOTNULL)"""
cursor.execute(sql)
cursor.execute("""create index eid on
user, (Emp_Id)'''''')
cursor.commit()
cursor.close()
db.close()

Star topology should be used.
(ii) Sales is the most suitable building to place the server because it has maximum no. of computers.
(iii) Each building should have hub/switch and modern in case Internal connection is required.
(iv) MAN(Metropolitan Area Network) as this network can be carried out in a city network.

(i) Admin (Due to maximum number of computers)

(iii) Firewall or Router
(iv) Cable TV

(i) B-TOWN can house the server as it has the maximum no. of computers.
(ii) Optical fibre cable is the best for this star topology.

(iii) Switch
(iv) VoIP

(i) Faculty studio building.
(ii) Star topology
(iii) LAN
(iv) Satellite connection

import MySQLdb
db =MySQLdb.connect('localhost', 'HRMAN','Adminespwd', 'cosmetics')
cursor = db.cursor(prepared = TRUE)
sql = "''''Insert into table('EmpNo', 'EmpName','Job', 'Mgr', 'Hiredate', 'Sal', "DeptNo.")
values('%s', '%s', '%s', '%s', '%s', '%f, '%s')"""
current_ date = datetime.now()
Form_date = currencdate.strftime('%d-%m-%y')
insert_value = [('7369', 'Smith', 'Clerk', '7839',
currentdate.800, NULL),
('7788', 'Scott', 'Analyst', '7566',current date, 3000, 15)]
try:
cursor.executemany(sql 1, insert_value)
print(cursor.rowcount, "Records inserted")
db.commit()
except:
db. rollback ()
cursor.close()
db.close()
 

db MySQLdb.connect('localhost', 'PId' "PID@pwd', 'sales')
cursor = db.cursor()
sql = """Update Product set Price = Price-Su?"
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
cursor.close()
db.close()

import MySQLdb
db=MySQLdb.connect("localhost", "Fac", "Fac24", "Instds")
cursoredb.cursor()
cursor.execute("DROP TABLE IF EXISTS FACULTY")
sql="""Create Table Faculty(Id Number(3) PRIMARY KEY,LastName CHAR(30) NOT NULL, FirstName CHAR(30) NOT NULL,
LocationId Number(5), phone char(10), rank char(4) check (rank IN('ASSO','FULL', 'ASST', 'INST'))' startdate DATE)"""
cursor.execute(sql)
db.close()

Import MySQLdb
 db=MySQLdb.connect("localhost", "Adminxyz", "Axydrn l?", "xyzcorp")
cursor=db.cursor()
cursor.execute("DROP TABLEIF EXISTS CUSTOMER")
sql="""Create Table Customer (CUSTNUMB CHAR(3) NOTNULL, CUSTNAME CHAR(60) NOT NULL,
ADDRESS CHAR(100), BALANCE Float, CREDLIM Float, SLSRNUMB CHAR(2) NOT NULL)"""
cursor.execute(sql)
cursor.close()
rec_ins=[('124', 'TINA ADAMS', '481 Tilak lane, CP, Delhi', 41800.75,50000, '3'),
('256', 'R VENKAT', '215 Mylapore, Chennai', 100000.75, 80000,'6')'
('567', 'BHUVNA BALAJI', '808 BalaNagar, Hyderabad', 57000.75, 50000,'6')
('622', 'PRATHAMJAIN', '149 Plot 182, sec-9 Dwarka,Delhi', 57500.75,80000, '12')]
sql jnsert- """INSERT INTO Customer (CUSTNUMB, CUSTNAME, ADDRESS, BALANCE, CREDLIM ,
SLSRNUMB), (VALUES('%s', '%s', '%s', '%f, '%f, '%s')"""
cursor=db. cursor(prepared=TRUE)
try: 
cursor. executemany(sql_insert, rec_ins)
print(cursor.rowcount, "Records inserted successfully")
db.commit()
except:
db.rollback()
cursor.close()
db.close()

import MySQLdb
db=MySQLdb.connect('localhost', 'Admin', 'saIAd345', 'sales') cursoredb.cursortprepared-True)
insert_query= ''''''INSERT INTO TABLE (ORDNUMB, PARTNUMB, NUMBORD, QUOTPRIC) VALUES('%s','%s ','%s','%f ')"""
rec_ins=[('12489', 'AXI2', '11', 14.95), ('12491', 'BT04', '1' '402.99), ('12492', BZ66', '1',311.95), ('12498', 'cxn. '2', 57.95)]
try:
cursor.executemanytinsert..query, rec_ins)
print(cursor.rowcount, "Records inserted successfully")
db.commit()
except:
db.rollback()
cursor.close()
db.close()

import MySQLdb
db=MySQLdb. connect('localhost', 'salesman 1', 'sale 1', 'Sales ')
cursor=db. cursor(prepared = TRUE)
sql_query="""INSERT INTO Orders (ORDNUMB, CUSTNO, ORDDTE) VALUES ('%s', '%s', '%s')"''''
rec_inst=[('12489', '124', '01-03-98'), ('12491', '311', '10-03-98'), ('12495', '315', '31-03-98'),
('12498', '522', '10-04-98')]
try:
cursor.executemany(sql_query, rec_inst)
print(cursor.rowcount, "Records inserted successfully")
db.commit()
except:
db.rollback()
cursor.close()
db.close()

import MySQLdb
db=MySQLdb.correct('localhost', 'Admin','SalA345', 'sales')
cursor=db. cursor()
sql="""UPDATE OrderDetails set
NUMBORD=NUMBORD+5 where QUOTPRIC
<'%d' OR NUMBORD> '%d'"''''
check_value = (100,3)
try:
db.execute(sql, checkvalue)
db.commit()
except:
db.rollback()
db.close()

(a) import MySQLdb
db=MySQLdb.connect('localhost', 'Admin','Admin@pwd', 'cosmetics')
cursor=db.cursor()
sql=''''''Select*from Client where city=%s"""
city _query=('Delhi')
try:
cursor.execute(sql, city_query)
results = cursor.fetchall()
print ("Client ID, Name, City, Product")
for row in results:
CID = row[0]
CName = row[1]
CCity = row[2]
CProd = row[3]
prints ("%s %s %s %s" % \ (CID, CName,CCity, CProd)
except:
print ("Error: unable to fetch data")
cursor. close()
db.close()
(b) import MySQLdb
db=MySQLdb.connect('localhost', 'Admin','Admin@pwd', 'cosmetics')
cursoredb.cursor()
sql="""select * from Product where Price
BETWEEN %F to %F"""
value = (50,100)
try:
cursor.execute(sql, value)
results = cursor.fetchall()
print ("ID ProductName Manufacturer Price")
for row in results:
PID = row[0]
PName = row[l]
PManu = row[2]
PPrice = row[3]
print (" %s %s %s %s", % \ (PID, PName,PManu, PPrice)
print (cursor.rowcount, "Records Found")
except:
print ("Error unable to Fetch data")
cursor.close()
db.close()
(C )import MySQLdb
db = MySQLdb.connect('localhost', 'Admin','Admin@pwd', 'cosmetics')
cursor=db.cursor()
sql="""select ClientName, City From Client"""
try:
cursor.execute(sql)
results = cursor.fetchall()
print "ClientName","City"
for row in results:
print "%s %s", % \ (row[0], row[l])
print (cursor.rowcount, "RecordsFound")
except
print ("Error unable to Fetch data")
cursor.close()
db.close()
(d) import MySQLdb
db = MySQLdb.connect('localhost', 'Admin','Admin@pwd', 'cosmetics')
cursor=db. cursor(buffered=TRUE)
sql="""select price From Product where
Manufacturer = %s"""
query _value= ('ABC',)
try:
cursor.execute(sql, query_value)
results = cursor.fetchall()
print "Price of Items by %s", % \ (query_value)
for row in results:
print row[0]
print (cursor.rowcount, "Items listed")
except:
print ("Error unable to Fetch data")
cursor.close()
db.close()
(e) import MySQLdb
db MySQLdb.connect('localhost', 'Admin','Adminespwd', 'cosmetics')
cursor = db.cursor()
sql = """Select ProductName, Price *4 From Product'?"
try:
cursor.execute(sql)
results = cursor.fetchall()
print ("ProductName","Price")
for row in results:
print ("%s %s" % \ (row[0]. row[1]))
print (cursor.rowcount, "Records found")
except:
print ("Unable to fetch data")
cursor.close()
db.close()

a)Both (A)and (R) are true and (R) is the correct explanation of (A)
Explanation:
Modem is a communication device that works on the process of modulation/demodulation. In modulation, digital data of the sender computer is converted in analog form to travel over the telephone lines to the target computer. In demodulation, received analog data is converted back to digital form for the target computer.

a)Both (A)and (R) are true and (R) is the correct explanation of (A)
Explanation:
A hub can also act as an amplifier at times. Hubs can function as either passive or active devices. Active hubs electrically amplify the signal as it moves from one connected device to another. While passive hubs allow the signal to pass from one computer to another without any change.

a)Both (A)and (R) are true and (R) is the correct explanation of (A)
Explanation:
A repeater is not like an amplifier because a repeater not only amplifies the signal but also performs signal regeneration. When a signal weakens over long distances, the repeater collects the inbound packet and then retransmits it as if it were originating from the source station. This process effectively removes noise.

a)Both (A)and (R) are true and (R) is the correct explanation of (A)
Explanation:
Both IMAP and POP3 protocols are used with email accessing. IMAP (Internet Message Access Protocol) is a standard protocol for accessing e-mail from local server. Whereas POP3 (Post Office Protocol 3) provides a simple, standardized way for users to access mailboxes and download messages to their computers.