Saturday, February 24, 2018

2017-18 Sem II Class: TE(IT) Subject: C N Assignment I


MGM’s College of Engineering, Nanded.
Department of IT
Semester II (2017-18)
Class: TE(IT)       Subject:  C N       Assignment I

1.      Draw and explain layers of TCP/IP model.
2.      Draw the architecture of Internet. Explain its components.
3.      Calculate the time required to download a 2MB file on an internet having speed of 10Mbps.
4.      Explain classful addressing in TCP/IP.
5.      Change the following IPv4 addresses from binary to hexadecimal  and decimal notation.
i)10001001  00001001  00001011  11101011
ii)11001001  10010011  00011011  11111011
6.      Change the following IP addresses from dotted-decimal notation to binary and hex notation.
(i)                 110.56.45.80  (ii)  210.215.211.198  (iii)  71.165.101.12
7.      For the following addresses, find the class, the block and the range of addresses:
(i)                 11.1.1.1     (ii) 145.56.1.1  (iii) 216.120.74.1
8.      Find the error, if any, in the following IP addresses:
(i)                 115.075.79.85   (ii)  275.91.79.15  (iii)  260.074.155.261
9.      (a) Find the class of the following IP addresses, and give explanation for it:
(i)                 11000011  10000011   00011011 11111111
(ii)               00101001  00001011   00001011 11101111
(iii)             10010001 00101011   00001011 11101111
(b) One of the address in a block is 201.12.8.45.Find the number of addresses, the first address and the last address.
10.  Draw and explain the header of ARP/RARP protocol. A host with IP address 155.25.42.20 and physical address 0xb2efc577f42c has a packet to send to another host with 155.25.42.29 and physical address 0xe456173f227c. The two hosts are on the same Ethernet. Write the contents of ARP request and reply packets.
11.  Draw and explain the fields of an IP datagram. An IP packet has arrived with the first 8 bits as shown:
                                       ç  11100010
     The receiver discards the packet. Why?
12.  What are the different options for IP datagram option field? Explain briefly. An IP packet has the value of HLEN as 1101 in binary. How many bytes of options are being carried by this packet?
13.  (a) In an IP packet, the value of HLEN is 5 (decimal) and the value of the total length field is 45 (decimal). How many bytes of data are being carried by this packet?
(b) In an IP packet, the value of HLEN is 0A (hex) and the value of the total length field is 0A2F (hex). How many bytes of data are being carried by this packet?
14.  Calculate the checksum for the following IP datagram
4
5
0
56
2A
0
0
6
8
0
192.169.11.2
195.169.11.9
15.  An IP packet has arrived with the hexadecimal digits as shown below:
ç  450000380d3a00000201bb6ec0a802034a7de2f4
How many hops can this packet travel before being dropped, The data belong to what upper layer protocol, What is identification value, what is the value for checksum, what is source and destination address?
16.  What is the significance of identification, flags, and offset fields of IP datagram? A datagram of size 11520 bytes is transmitted on a network of MTU 960 bytes. Calculate the offset values and range of data bytes present in each fragments. What is the status of flags bit in each fragment?


Additional Questions for practice

17.  Enlist and explain the properties of internet.
18.  What services are provided by network-level of internet? Discuss in detail.
19.  Explain in detail application-level services of internet.
20.  Draw and explain different fields of Ethernet frame.
21.  Compare connection-oriented and connectionless delivery systems.
22.  Enlist the advantages and drawbacks of packet-switching networks.
23.  What are the advantages of circuit-switching networks over packet-switching? Why?
24.  What connecting devices are used at layer-1, layer-2, and layer-3 in internet? Explain their characteristics and functions.
25.  What addresses are used at layer-1, layer-2, and layer-3 in internet? Explain briefly.
26.  Explain the application programs at your site that use TCP/IP.
27.  What is Ethernet address? What are its properties?
28.  What is an IP address? What are the desirable properties of IP address? What is signified by prefix and suffix of IP address?
29.  What are the differences between Ethernet address and IP address?
30.  Draw and explain ARP and RARP protocol format.
31.  Explain the concept of (i) datagram encapsulation, (ii) network MTU, (iii) and multiplexing at IP and TCP layers.
32.  What is proxy ARP? Explain with example.
33.  What is ARP? Explain ARP cache timeout.
34.  Define : (i) Multihomed host (ii) Directed broadcast address (iii) Limited broadcast address (iv) Loopback address.


Faculty Incharge: Hashmi S A



2017-18 Sem II Class: BE(IT) Subject: MC Assignment I


MGM’s College of Engineering, Nanded.
Department of IT
Semester II (2017-18)
Class: BE(IT)       Subject: MC         Assignment I
________________________________________________________
1.     What different multiplexing techniques are used in wireless communication? Explain in brief.
2.     What are the different spread spectrum techniques in wireless networks? Explain briefly.
3.     Enlist advantages and drawbacks of FDMA and TDMA.
4.     Why IR signals are not generally used and radio signals are used for wireless communications such as wifi and cellular networks?
5.     Give comparison between 802.3 and 802.11.
6.     What is hidden terminal problem? How it is solved?
7.     Enlist characteristics of wireless LANs.
8.      Draw and explain the two types of architectures used in 802.11 networks.
9.     What are the different layers of 802.11 protocol? Explain their functions.
10.  A smartphone downloads an jpeg file of 2MB using FHSS physical interface of wifi having 2Mbps data rate. Calculate the frame size and time required for downloading. Also list the functions of different fields of FHSS packet format.
11.    A laptop uploads mp3 file of 6MB using DSSS physical interface of wifi having 6Mbps data rate. Calculate the frame size and time required for uploading. Also list the functions of different fields of DSSS packet format.
12.   Which access method will be used by five mobile stations sharing a single channel for transmission? Explain in detail.
13.   What are the different IFS used in 802.11 MAC layer? A mobile station is ready with an ACK packet, how long should it wait before transmission using FHSS and DSSS?
14.  What are the different fields present in 802.11 MAC frame format? A smartphone receives a MAC packet on wifi network with the following bits in MAC frame:
0001110000000111
What information is present in this MAC packet?
15.     What is a beacon frame? A laptop and 2 Smartphone’s are present in wifi infrastructure-based network. How synchronization is done using beacon transmission?
16.  What is TIM? How power management is done using DTIM and ATIM in 802.11 networks?


Additional Questions for practice
17.  What are the drawbacks of mobile and wireless communication? Explain.
18.  Give comparison between wireless networks and fixed networks.
19.  Calculate the 802.11 MAC frame size for Q. No. 10 and 11.
20. What additional functions are required for wireless MAC protocol? Why?
21. Draw and explain IEEE 802.11 FHSS frame format.
22. Draw and explain IEEE 802.11 DSSS frame format.
23. What are the design goals of wireless LAN? Why?
24.What are the different digital modulation techniques? Discuss in brief
25.What are the three access methods used by 802.11 standard? Explain in detail.
26.Give comparison between infrared and radio transmission.
27. What are the applications of mobile and wireless communication? Explain in detail.
28.Enlist and explain the components of infrastructure networks of 802.11.
29.State and explain the 3 versions of 802.11 physical layers.
30.What functions are performed by MAC management of 802.11? Discuss in detail.
31.How power management is done in 802.11 infrastructure and ad-hoc networks?
32.Write short note on: (i)Wifi Dual Band (ii) Wifi Direct


Faculty Incharge: Hashmi S A








Friday, October 6, 2017

Class: BE(IT)-CGPA Subject: DMDW Assignment II

MGM’s College of Engineering, Nanded.
Department of IT
Semester I (2017-18)
Class: BE(IT)       Subject: DMDW         Assignment II

1. Suppose we have the following values for salary (in thousands of dollars), shown in increasing order: 30, 36, 47, 50, 52, 52, 56, 60, 63, 70, 70, 110. (a) Calculate mean, median, mode, midrange, standard deviation of the salary. (b) Can you find (roughly) the first quartile (Q1) and the third quartile (Q3) of the data?
2. For the above values for salary (a) Give the five-number summary of the data. (b) Show a boxplot of the data.
3. Given two objects represented by the tuples (22, 1, 42, 10) and (20, 0, 36, 8):
(a) Compute the Euclidean distance between the two objects.
(b) Compute the Manhattan distance between the two objects.
(c) Compute the Minkowski distance between the two objects, using q= 3.
4. Explain min-max and z-score normalization with an example.
5. Imagine that you need to analyze AllElectronics sales and customer data. You note that many tuples have no recorded value for several attributes such as customer income. How can you go about filling in the missing values for this attribute?
6. Price (in dollars) for a product are: 8, 4, 21, 15, 21, 24, 34, 25, 28. Apply binning methods for smoothing the Price data.
7. Write an overview of data transformation strategies.
8. Discuss issues to consider during data integration.
9. A database has five transactions. Let min_ sup= 60% and min_ conf= 80%.
TID                 Items Bought
T100                M, O, N, K, E, Y
T200                D, O, N, K, E, Y
T300                M, A, K, E
T400                M, U, C, K, Y
T500                C, O, O, K, I, E
Find all frequent itemsets using Apriori.
10. Define : (i) Support (ii) Confidence  (iii) Frequent Itemset
11. State and explain the steps of apriori algorithm.
12. For the following transaction database, Generate Association rules from frequent itemset.(take support=2)
TID                 List of item IDs
T100                I1, I2, I5
T200                I2, I4
T300                I2, I3
T400                I1, I2, I4
T500                I1, I3
T600                I2, I3
T700                I1, I3
T800                I1, I2, I3, I5
T900                I1, I2, I3
13. How can we improve the efficiency of Apriori-based mining?
14. Create an FP-tree for the above transaction database (Q.12).
15. What is classification? Enlist applications of classification.
16. Write short note on: Pattern evaluation methods.


                                                                                                          Faculty Incharge: Hashmi S A

Thursday, October 5, 2017

TE(IT)-CGPA Subject: DBMS Assignment II

MGM’s College of Engineering, Nanded.
Department of IT
Semester I (2017-18)
Class: TE(IT)       Subject: DBMS         Assignment II

1. Explain various set operations available in SQL with examples.
2. Explain how the GROUP BY clause works. What is the difference between WHERE and HAVING clauses? Explain with the help of an example.
3. How are queries based on joins expressed in SQL? Explain the various join operations.
4. Explain the concept of nested queries with examples.
5. Discuss the different operators in SQL, which are used with subqueries/nested queries.
6. What are assertions? Why are they necessary?
7. What is the purpose of view in SQL? How can you create a view?
8. What are stored procedures? When are they beneficial? Give the syntax and example of creating a procedure and function in SQL.
9. What are triggers? How are they created? Explain with an example how triggers offer a powerful mechanism for dealing with the changes to database.
10. What do you understand by an embedded SQL? How are variables declared and used in an embedded SQL? Explain with examples.
11. What is the purpose of ODBC in SQL? How is it implemented? Explain with examples.
12. What is the purpose of JDBC in SQL? Explain with examples.
13.Consider the given tables
Loan
LoanNo           BranchName               Amount
L101                Mumbai                       1000
L103                Pune                            2000
Borrower
CustomerName           LoanNo
Sonam                         L101
Nandy                         L103
Anusha                        L103
Depositor
CustomerName           AccountNo
Anusha                        A102
Sonam                         A103
Nandy                         A104
(a)  What are the number of tuples present in the result of cross product of the above two tables?
(b) Write an SQL to Find all customers who have only accounts but no loans.
(c) Write an SQL to Find the names of all customers who have either an account or loan but not both.
14. Define functional dependency. Explain different Normal forms.
15.The given table is in BCNF form, convert it to the 4th normal form.
Employee       Skill                             Language
Jones               Electrical                     French
Jones               Electrical                     German
Jones               Mechanical                  French
Jones               Mechnical                    German
Smith               Plumbing                     Spanish


16. Compute the closure of the following set F of functional dependencies
for relation schema R = (A, B, C, D, E).
ABC
CDE
BD
EA



Faculty Incharge: Hashmi S A