Wednesday, April 5, 2023

Machine Learning for Agriculture

 Machine learning has the potential to revolutionize agriculture by helping farmers make more informed decisions and optimize their operations. Here are some applications of machine learning in agriculture:

1. Crop yield prediction: Machine learning algorithms can analyze data from a variety of sources such as soil moisture, temperature, and weather patterns to predict crop yields. This information helps farmers plan for the optimal planting and harvesting times. 2. Pest and disease detection: Machine learning can be used to detect pests and diseases in crops by analyzing images of plants and leaves. This information can help farmers take action to prevent the spread of pests and diseases and protect their crops. 3. Precision agriculture: Machine learning algorithms can analyze data from sensors and drones to provide farmers with detailed information about their fields, such as soil moisture, nutrient levels, and crop health. This information can help farmers make more informed decisions about planting, fertilizing, and harvesting. 4. Livestock monitoring: Machine learning can be used to monitor the health and behavior of livestock by analyzing data from sensors and cameras. This information can help farmers identify potential health issues and take action to prevent them. 5. Agricultural supply chain optimization: Machine learning can be used to optimize the agricultural supply chain by analyzing data on crop yields, weather patterns, and transportation routes. This information can help farmers and distributors make more efficient and cost-effective decisions. Overall, machine learning can help farmers increase productivity, reduce costs, and make more informed decisions about their operations.

Sunday, July 31, 2022

 

FUNDAMENTALS OF INFORMATION TECHNOLOGY

Computers have a profound impact on society. They've turned us into their pawns. Whether it's the ticket desk, the microwave, or your automobile, we expect them to be there. To pursue one's job objectives and operate successfully and efficiently, one must have at least the basic understanding 

of computer abilities. For now and tomorrow's fast- changing computing world, computer literacy is both a  need and a voice. It's an integral part of modern society. Everything it touches, from our everyday lives to the globe at large, is impacted, both positively and negatively. In today's world,

it's normal to see new technology advancements. An example is internet & smartphones. We can only progress as a species if we keep coming up with new ideas. Misuse of technology, on the other hand, has been related to the mental health problems, attention deficit disorder, and worries about personal privacy. Using the keyboard to enter text or do mathematical computations is the extent of most people's computer knowledge. This, however, is insufficient. It is necessary to have a basic understanding of the components and operation of computers. We're spending more and more of

our time online. While being able to do anything and everything online has made our lives easier, it has also put us at risk. AI, machine learning, including intelligent data have increased connection in internet of things. Pushing the boundaries of internet of things, even more gadgets are being linked to the internet. As new technologies as well as new products incorporating network technologies emerge, the Internet of things would continue to expand.


For FUNDAMENTALS OF INFORMATION TECHNOLOGY Notes Students May Click on the given URL

https://drive.google.com/file/d/1ach82Z-Y6309_gCEnZ6fzs4wS_5ekQm2/view?usp=sharing

or

https://drive.google.com/file/d/1ach82Z-Y6309_gCEnZ6fzs4wS_5ekQm2/view?usp=sharing

Saturday, July 30, 2022

BASIC CONCEPTS OF MANAGEMENT INFORMATION SYSTEM

 BASIC CONCEPTS OF MANAGEMENT INFORMATION SYSTEM 

(As per the Syllabus of State University in Uttar Pradesh for BCA, MCA, Computer Science, and Other Professional Course) 


The course of Structured Management Information System involves planning for a proposed system analyzing the existing system, identifying the problem, and solving it by preparing to deign and coding methods. The Students of Computer Science at Various universities are always in search of relevant and well organized matter. I have tried my best to accomplish this task. The Ultimate Aim of this book is to help the MCA, BCA, PGDCA, Engineering students of State University level. Students will find out the topic as per university syllabus. Each chapter covers examples wherever required. 

Management Information Systems course, the student should be able to 

  Define the key terms. 

  Describe the use and function of information systems. 

  Describe and evaluate information systems development processes and techniques. 

  Identify and evaluate hardware and software requirements for information systems. 

  Explain the security risks associated with management information systems.

For Notes, Students may click on this URL

https://drive.google.com/file/d/1GokyJ5yTc432UKXBxNh4gbhtV9JD_3t6/view?usp=sharing

or

https://drive.google.com/file/d/1GokyJ5yTc432UKXBxNh4gbhtV9JD_3t6/view?usp=sharing

BASIC CONCEPTS OF E-COMMERCE

 

BASIC CONCEPTS OF E-COMMERCE 


(As per Syllabus of State University in Uttar Pradesh for BCA, MCA, PGDCA Computer Science, and Other Professional Course) 


The course of Structured E-Commerce involves and focuses on principles of e-commerce from a business perspective, providing an overview of business and technology topics, business models, virtual value chains, and social innovation and marketing strategies. In addition, some of the major issues associated with e-commerce—security, privacy, intellectual property rights, authentication, encryption, acceptable use policies, and legal liabilities—will be explored. Students will build their own web presence and market it using an online platform. The Students of Computer Science at Various universities are always in search of relevant and we organized matter. I have tried my best to accomplish this task. The Ultimate Aim of this book is to help the MCA, BCA, PGDCA, and Engineering students of the State University level. Students will find out the topic as per the university syllabus. Each chapter covers examples wherever required. 

For Notes Students may Click on this URL


https://drive.google.com/file/d/11WqY4jkhzlJ39YItd-Wc-lxRB1usIOWo/view?usp=sharing

Monday, February 24, 2020

Monday, November 25, 2019

DBMS Quiz 2019

DBMS Quiz 2019
a) A relational database consists of a collection of
a) Tables
b) Fields
c) Records
d) Keys
b) A ________ in a table represents a relationship among a set of values.
a) Column
b) Key
c) Row
d) Entry
c) The term attribute refers to a ___________ of a table.
a) Record
b) Column
c) Tuple
d) Key
d) Course(course_id, sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________
a) Relations, Attribute
b) Attributes, Relation
c) Tuple, Relation
d) Tuple, Attributes
e) 1. In the __________ normal form, a composite attribute is converted to individual attributes.
a) First
b) Second
c) Third
d) Fourth
f) SQL can be used to:
a) Create database structures only
b) Query database data only
c) Modify database data only
d) All of the mentioned
g)  Using which language can a user request information from a database ?
a) Query
b) Relational
c) Structural
d) Compiler
h) The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
a) Select
b) Join
c) Union
d) Intersection
i) The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
a) Join
b) Projection
c) Select
d) Union
j) Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Query
d) Relational Schema
k) To remove a relation from an SQL database, we use the ______ command.
a) Delete
b) Purge
c) Remove
d) Drop table
l) Which of the following makes the transaction permanent in the database ?
a) View
b) Commit
c) Rollback
d) Flashback
m) In order to maintain the consistency during transactions database provides
a) Commit
b) Atomic
c) Flashback
d) Retain
n) A transaction completes its execution is said to be
a) Committed
b) Aborted
c) Rolled back
d) Failed
o) The default extension for an Oracle SQL*Plus file is:
a) .txt
b) .pls
c) .ora
d) .sql
p) What type of join is needed when you wish to include rows that do not have matching values?
a) Equi-join
b) Natural join
c) Outer join
d) All of the mentioned
q)  Which forms are based on the concept of functional dependency:
a) 1NF
b) 2NF
c) 3NF
d) 4NF
r) The entity set person is classified as student and employee. This process is called _________
a) Generalization
b) Specialization
c) Inheritance
d) Constraint generalization
s) Functional Dependencies are the types of constraints that are based on______
a) Key
b) Key revisited
c) Superset key
d) None of the mentioned
t) A deadlock exists in the system if and only if the wait-for graph contains a ___________
a) Cycle
b) Direction
c) Bi-direction
d) Rotation
U)Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Query
d) Relational Schema
V)Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Query
d) Relational Schema
W) To remove a relation from an SQL database, we use the ______ command.
a) Delete
b) Purge
c) Remove
d) Drop table
X) Updates that violate __________ are disallowed.
a) Integrity constraints
b) Transaction control
c) Authorization
d) DDL constraints
Y) The user defined data type can be created using
a) Create datatype
b) Create data
c) Create definetype
d) Create type
Z) In the __________ normal form, a composite attribute is converted to individual attributes.
a) First
b) Second
c) Third
d) Fourth


Friday, November 8, 2019

Java Quiz-I (2019-20) and Class Test papers

Java Quiz -I (2019-20)& Class Test Paper



1. For Java Programming Quiz Student can hit at given link

https://drive.google.com/file/d/1cRLyAW_BwQDqrdpc5Rta9zRTwZPnm6Tx/view?usp=sharing


https://drive.google.com/file/d/1cRLyAW_BwQDqrdpc5Rta9zRTwZPnm6Tx/view?usp=sharin

2. For SAD Class Test papers Student can hit at given link(please copy the following url and past it to your browser)

https://drive.google.com/file/d/1-Md4SOXV4TIzS2W2fq30jGT6XccB2TAD/view?usp=drivesdk


3. For IJP Class Test papers Student can hit at given link (please copy the following url and past it to your browser)

https://drive.google.com/file/d/1-MdpWQ9a-aA8n8TA3XCci-5QIDY_5417/view?usp=drivesdk

Friday, November 1, 2019

Student's Feedback Forms

Dear Students,
Please find the links for the Student's Feedback Forms




Feedback Form 1: 
I have made you the editor of the form so that you could edit the form and permissions accordingly. In case of any further queries, feel free to contact me.

Regards

MCA / BCA JAVA PROGRAMMING LAB MANUAL 2019-20

 MCA/BCA JAVA PROGRAMMING LAB MANUAL 2019-20


Students may use this URL for java programming lab manual


https://drive.google.com/open?id=18GrQ5DEyOxDcYNuNuy2pl7eQ8D7yQERT

SPECIAL CARRY OVER THEORY EXAMINATION 2019


BCA-403        
B.C.A, - Semester-IV
SPECIAL CARRY OVER THEORY EXAMINATION 2019
DATA COMMUNICATION AND COMPUTER NETWORKS
                                 
Time:  03 Hours                                                                             Total Marks: 70
Note:     Attempt any five questions.
            
                                                                                                (14*5=70)
.
1.      What is computer networking? What are its main objectives of Computer Network?
2.      Discuss the OSI reference model? Discuss the functioning of each layer in detail.
3.      Explain Transmission media with the help of diagrams and their properties.     
4.      Explain, Slotted ALOHA and Pure ALOHA.                        
5.      What is framing? Explain the types of framing.
6.      Explain Domain Name System (DNS).
7.      Explain the LAN, MAN, and WAN.
8.      Difference Between Connectionless and Connection-Oriented Communication.
           9.      What are the advantages of encryption/decryption?
          10.  What is Error Control in Data Link Layer? Explain Stop and wait ARQ.
      Or
Short Notes :( Any Two)
(a) Routing.
(b) FTP and HTTP protocols.
(c) Transmission Mode.
(d) IP Addressing.

SYSTEM ANALYSIS AND DESIGN ASSIGNMENTS 2019-20 (BCA-312)

BCA-312
B.C.A, - Semester-III
ODD SEMESTER 2019-20
SYSTEM ANALYSIS AND DESIGN
ASSIGNMENT:-1

1. What is the system? Explain Elements of the system with a diagram.
2. Who is a system analyst? Explain the role of system analyst in system development.
3. Explain each layer of the system development life cycle with suitable examples and
    diagrams.
4. What are Information gathering techniques? Explain?

BCA-312
B.C.A, - Semester-III
ODD SEMESTER 2019-20
SYSTEM ANALYSIS AND DESIGN
ASSIGNMENT:-2

1. What is DFD? Define the DFD Symbols with the help of a suitable example.
2. Discuss the importance of system analysis and design in the development of a system.
3. What do you mean by the successful implementation of the system?

BCA-312
B.C.A, - Semester-III
ODD SEMESTER 2019-20
SYSTEM ANALYSIS AND DESIGN
ASSIGNMENT:-3

1. What is system testing? What is the difference between black-box testing and white box
     testing? Discuss.
2. Define Decision Tree and Decision Table with the help of a suitable example.
3. Define technical, operational and economic feasibility.

Java Programming Assignments 2019-20 (BCA-501)

BCA-501
B.C.A, - Semester-V
ODD SEMESTER 
JAVA PROGRAMMING
Assignment:-1 
    1.      What is an object-oriented programming concept? Explain in detail.
2.      Explain the features of Java. How is platform-independence implemented by Java?
3.      What is the difference between Overriding and Overloading?
4.      Define a constructor. Is it possible to, overload a constructor? Justify your answer using an example.
5.      What is Inheritance? Write a sample JAVA program to describe the usage of single and multi-level inheritance.

BCA-501

B.C.A, - Semester-V
ODD SEMESTER 
JAVA PROGRAMMING
Assignment:-2
1.      What is a “java applet? What is the life cycle of Java Applets?
2.      How do we define interfaces in Java?  Explain with the help of an example.
3.      Discuss the concept of exception handling. Write a program that prompts the user to enter an integer divisor and integer dividend.

BCA-501


B.C.A, - Semester-V
ODD SEMESTER 
JAVA PROGRAMMING
Assignment:-3
1.      Define Threads in Java? Explain with Suitable Example.
2.      Write short note on:
a)      Explain the usage of Java packages.
b)      JDK.
c)      String class.
d)     Character Stream

Thursday, September 28, 2017

IJP Assignment

INTERNET JAVA PROGRAMMING  ASSIGNMENT 1


1. Explain basic concepts of OOPS.
2. Why is JAVA known as platform independent language
3. How is JAVA more secure than other languages
4. Describe in detail the steps involved I implementing a stand-alone program
5. WAP to find the number and sum of all integers greater than 100 and less than 2000 that are divisible by 7
6. WAP to compute the sum of digits of a given integer number
7. Explain the following: a. Static Members b. Final Method c. Final Class d. Abstract class e. Abstract method
8. How does String class differ from StringBuffer Class
9. Give an example where the interface can be used to support multiple inheritance. Give Example
10. Discuss Various levels of access protection available for packages and their implications 

Saturday, July 29, 2017

Internet and Java Programming Important Questions- MCA-302

Important 20 Questions

Course:                       M.C.A
Subject:                       Internet and Java Programming
Paper Code:                MCA-302
Semester:                    III

Questions from Unit I

Q.1. What is the Internet? Explain type of Internet connections
Q.2. What is E-mail? Explain advantages of E-mail.
Q.3. What do you mean by Video conferencing? Explain type and benefits of Video conferencing.
Q.4. Explain purpose of following
        a) XML b) HTMP c) DNS d) ISP e) JVM f) ISDN & FTP
Questions from Unit II
1. What is the difference between a constructor and a method?
2. What is the difference between an Interface and an Abstract class?
3. Explain different way of using thread? Also, define multithreading.
4. Write short notes on
     (a) What are the different ways to handle exceptions?
     (b) What is the difference between Overriding and Overloading?
     (c)What is string buffer? How does it differ from a string? Give the three ways of creating a string object.
    (d) Explain the usage of Java packages.
    (e) What is the “java applet? What is the life cycle of Java Applets?
    (f)  What is an interface? What is the use of interface?
Questions from Unit III
Q1. The difference between Swing and AWT?
Q2. Which method can be used to obtain the length of the String? How do you concatenate Strings?
Q3. Which method can be used to compare two strings for equality? Which method can be used to perform a comparison between strings that ignores case differences?
Q4. Short Notes.
a. HTTP request, Write programs in Java using sockets programming.
b. What is meant by Stream and what are the types of Streams and classes of the Streams?
Questions from Unit IV
Q1. What is a Java Bean? Discuss the state of bean state of Bean. In this reference describe indexed properties of a class with the help of suitable example.
Q2. What do you mean by JAR filters? Discuss.
Q3.What is the difference between the Reader/Writer class hierarchy and the InputStream/OutputStream class hierarchy?
Q4. How do I select a URL from my Applet and send the browser to that page?
Questions from Unit V

Q1. Discuss the role of JSP in the development of a website.
Q2. Explain the basic components of JDBC. Explain in detail the different drivers of JDBC.
Q3. Define following in brief:
i. Servlet Life Cycle.
ii. Net Bean.
Q4. Explain the steps to create RMI based clients and server. Explain the various methods for registering and gaining access to the Remote Object.

DBMS List of Lab Exercises


SCA of Computer Application
DBMS Lab
IFTM,University,Moradabad


1 Database Schema for a customer-sale scenario
Customer(Cust id : integer, cust_name: string)
Item(item_id: integer, item_name: string, price: integer)
Sale(bill_no: integer, bill_data: date, cust_id: integer,
item_id: integer, qty_sold: integer)
For the above schema, perform the following—
a) Create the tables with the appropriate integrity constraints
b) Insert around 10 records in each of the tables
c) List all the bills for the current date with the customer names
and item numbers
d) List the total Bill details with the quantity sold, price of the
item and the final amount
e) List the details of the customer who have bought a
product which has a price>200
f) Give a count of how many products have been bought by
each customer
g) Give a list of products bought by a customer having
cust_id as 5
h) List the item details which are sold as of today
i) Create a view which lists out the bill_no, bill_date,
cust_id, item_id, price, qty_sold, amount
Create a view which lists the daily sales date wise for the last
one week

2 Database Schema for a Student Library scenario
Student(Stud_no : integer, Stud_name: string)
Membership(Mem_no: integer, Stud_no: integer)
Book(book_no: integer, book_name:string, author: string)
Iss_rec(iss_no:integer, iss_date: date, Mem_no: integer,
book_no: integer)
For the above schema, perform the following—
a) Create the tables with the appropriate integrity constraints
b) Insert around 10 records in each of the tables
c) List all the student names with their membership numbers
d) List all the issues for the current date with a student .
e) List the details of students who borrowed book whose author is ABC.
f) Give a count of how many books have been bought by each student
g) Give a list of books taken by student with stud_no as 5
h) List the book details which are issued as of today
i) Create a view which lists out the iss_no, iss _date,stud_name, book name
j) Create a view which lists the daily issues-date wise for the last one week
3 Database Schema for an Employee-pay scenario
employee(emp_id : integer, emp_name: string)
department(dept_id: integer, dept_name:string)
paydetails(emp_id : integer, dept_id: integer, basic: integer,
deductions: integer, additions: integer, DOJ: date)
payroll(emp_id : integer, pay_date: date)
For the above schema, perform the following—
a) Create the tables with the appropriate integrity
constraints
b) Insert around 10 records in each of the tables
c) List the employee details department wise
d) List all the employee names who joined after particular date
e) List the details of employees whose basic salary is between 10,000 and 20,000
f) Give a count of how many employees are working in each department
g) Give a name of the employees whose netsalary>10,000
h) List the details for an employee_id=5
i) Create a view which lists out the emp_name, department, basic, deductions, net salary
j) Create a view which lists the emp_name and his net salary
4 Database Schema for a Video Library scenario
Customer(cust_no: integer,cust_name: string)
Membership(Mem_no: integer, cust_no: integer)
Cassette(cass_no:integer, cass_name:string, Language:
String) Iss_rec(iss_no: integer, iss_date: date, mem_no: integer,
cass_no: integer)

For the above schema, perform the following—
a) Create the tables with the appropriate integrity constraints
b) Insert around 10 records in each of the tables
c) List all the customer names with their membership
numbers
d) List all the issues for the current date with the customer
names and cassette names
e) List the details of the customer who has borrowed the
cassette whose title is “ The Legend”
f) Give a count of how many cassettes have been borrowed
by each customer
g) Give a list of book which has been taken by the student
with mem_no as 5
h) List the cassettes issues for today
i) Create a view which lists outs the iss_no, iss_date,
cust_name, cass_name
j) Create a view which lists issues-date wise for the last one
week
5 Database Schema for a student-Lab scenario
Student(stud_no: integer, stud_name: string, class: string)
Class(class: string, descrip: string)
Lab(mach_no: integer, Lab_no: integer, description: String)
Allotment(Stud_no: Integer, mach_no: integer, day of week: string)
For the above schema, perform the following—
a) Create the tables with the appropriate integrity constraints
b) Insert around 10 records in each of the tables
c) List all the machine allotments with the student names,
lab and machine numbers
d) List the total number of lab allotments day wise
e) Give a count of how many machines have been allocated
to the ‘CSIT’ class
f) Give a machine allotment etails of the stud_no 5 with his
personal and class details
g) Count for how many machines have been allocated in
Lab_no 1 for the day of the week as “Monday”
h) How many students class wise have allocated machines in
the labs
i) Create a view which lists out the stud_no, stud_name,
mach_no, lab_no, day of week
j) Create a view which lists the machine allotment details for
“Thursday”.
6 Write a program to find the largest number from the given three numbers.
7 Simple programs using a loop, while and for iterative control statement.
8 Write a program to check whether the given number is Armstrong or not
9 Write a program to generate all prime numbers below 100.
10 Write a program to demonstrate the GOTO statement.
11 Write a program to demonstrate %type and %rowtype attributes
12 Write a program to demonstrate predefined exceptions
13 Write a program to demonstrate user defined exceptions
14 Create a cursor, which displays all employee numbers and names from the EMP table.
15 Create a cursor, which updates the salaries of all employees as per the given data.
16 Create a cursor, which displays names of employees having salary > 50000.
17 Create a procedure to find reverse of a given number
18 Create a procedure to update the salaries of all employees as per the given data
19 Create a procedure to demonstrate IN, OUT and INOUT parameters
20 Create a function to check whether given string is palindrome or not.
21 Create a function to find the sum of salaries of all employees working in depart number 10.
22 Create a trigger before/after update on employee table for each row/statement.
23 Create a trigger before/after delete on employee table for each row/statement.
24 Create a trigger before/after insert on employee table for each row/statement.
25 Create a Form to display employee details using SQL
26 Create a Report to generate all employee annual salaries….

Additional Programs
S. No Name of the Program
1 Create a form using Forms 6i to display Employee table data.
2 Create a Master/details relationship form which performs Add New, Search, Delete, Save and Update on the records
3 Generate a report to calculate employee’s salaries department wise from employee table.
4 Create a Report to generate the details of employee table including sum and average salaries department wise.

Assignments and Question Bank(Data communication and Networking)


SCA,IFTM University,Moradabad
ASSIGNMENTS(Data communication and Networking)
MCA/BCA


(a) ASSIGNMENT-1

1. What is mean by data communication?
2. What are the three criteria necessary for an effective and efficient network?
3. What are the three fundamental characteristics determine the effectiveness of data
communication system?
4. What are the advantages of distributed processing?
5. Why are protocols needed?
6. Why are standards needed?
7. For n devices in a network, what is the number of cable links required for a
mesh and ring topology?
8. What is the difference between a passive and an active hub?
9. Distinguish between peer-to- peer relationship and a primary-secondary
relationship.
10. Assume 6 devices are arranged in a mesh topology. How many cables are
needed? How many ports are needed for each device?
11. Group the OSI layers by function.
12. What are header and trailers and how do they get added and removed?
13. The transport layer creates a communication between the source and
destination. What are the three events involved in a connection?
14. What is the DC component?
15. List out the advantages and drawbacks of bus topology.
16. List out the advantages and drawbacks of the ring topology.
17. Why star topology is commonly preferred?
18. Is there any relationship between transmission media and topology?
19. What are the functions of OSI layers? Discuss.
20. Explain in detail about the types of topologies.
21. Explain detail about the transmission media for data transmission.
22. a. i. What is a protocol? List the three key elements of a protocol.
ii. With relevant examples differentiate between simplex, half duplex, and full duplex
communication.
23. Explain ISO OSI in detail with an explanation of each layer explicitly.
24. Explain TCP/IP.

25. Differentiate between OSI and TCP/IP.
26. Which of the following protocols are examples of TCP/IP transport layer protocols?
a. Ethernet
b. HTTP
c. IP
d. UDP
e. SMTP
27. What are the major advantages of STP over UTP?
28. Describe the components of fiber optic cable. Draw a picture.
29. What is the difference between network layer delivery and transport layer delivery?
30. What are the principles that were applied to arrive at the seven layers in OSI model?
31. Why transport layer protocols like TCP and UDP are called end-to- end protocols. W
is the difference between them?
32. Differentiate between:
(i) Baseband coaxial cable and broad band coaxial cable
(ii) Optical fiber and twisted pair

(b)ASSIGNMENT-2

1. What is the difference between a protocol and a service interface? Explain in terms of a
ISO seven layer model.
2. a. List the four properties by which transmission media can differ
b. Three packet switching networks each contain n nodes. The networks have a star
topology with a central switch, a ring respectively and a third is fully interconnected with
a wire from every node to every other node. What are the best, average and worst case
transmission paths in hops?
3. a. Describe the key elements of protocols and the standards.
b. Explain in detail the data transmission in OSI reference model.
4. What are the responsibilities of data link layer?
5. Mention the types of errors.
6. Define the following terms.
7. What is the redundancy?
8. List out the available detection methods.
9. Write short notes on VRC.
10. Write short notes on LRC.
11. Write short notes on CRC.
12.Write short notes on CRC generator.
13. Write short notes on CRC checker.
14. Give the essential properties for a polynomial.
15. Define checksum.
16. What are the steps followed in checksum generator?
17. List out the steps followed is checksum checker side.
18. Write short notes on error correction.
19. Mention the types of error correcting methods.
20. What is the purpose of hamming code?
21.Define flow control.
22. What is a buffer?
23. Mention the categories of flow control.

(H) ASSIGNMENT-3

1. a. Define CRC. Explain CRC generator & CRC checks in detail with one example
b. Explain in detail about error correction using Hamming code.
2. Explain HDLC and explain it in detail.
3. a. Given a 10 bit sequence 1010011110 and a divisor of 1011 find the CRC. Check the
answer.
b. Bit stuff the following data
i.0001111110111110011110011111001
ii. 00011111111111111111111111111111111110011111001
4. What is IEEE 802.3? What are the types of Ethernet? Discuss.
5. Draw the sender and receiver window for a system using Go Back N ARQ and
selective repeat ARQ, given the following
a. Frame 0 is sent, frame 0 is acknowledged
b. Frames 1 and 2 are sent, frames 1 and 2 are acknowledged
c. Frames 3,4 and 5 are sent; frame 4 is acknowledged; timer for frame 5 expired.
Frames 5,6
and 7 are sent; frames 4 through 7 are acknowledged
6. Discuss Token Bus & Token Ring networks in detail.
7. Define FDDI & its needs in detail.
8. a. What is SONET?
b. Name some layers of SONET &its functions.
c. Discuss SONET frame in detail with a neat diagram.
9. a. Define bridges?
b. Difference between bridges and repeaters.
c. Explain the loop problems solved by bridges.
10. What are the network support layers and the user support layers?
11. With a neat diagram explain the relationship of IEEE Project to the OSI model?
12. What are the functions of LLC?
13. What are the functions of MAC?
14. What is protocol data unit?
15. What are headers and trailers and how do they get added and removed?
16. What are the responsibilities of network layer?
17. What is a virtual circuit?
18. What are data grams?
19. What are the two types of implementation formats in virtual circuits?
20. What is meant by switched virtual circuit?
21. What is meant by Permanent virtual circuit?
22. Define Routers.
23. Define DNS and explain the major sections of DNS in detail?
24. With a neat diagram explain the basic model of FTP?
25. What is public key cryptography and explain RSA in detail with one example.
26. Explain various types of substitution techniques.
27. a. SMTP, FTP and HTTP are protocols to transfer messages from one point to
another. Compare and contrast their use
b. Write short notes on HTTP Request and Response messages
28. Explain in detail about SMTP.
29. a. Use the following encryption algorithm to encrypt the message,
a. Replace each character with its ASCII code
b. Add a 0 bit at the left to make each character 8 bits longc. Swap the first 4 bits
with the last 4 bits.d. Replace every 4 bits with its hexadecimal equivalent What is the
key in this method

30. Using the RSA algorithm, encrypt and decrypt the message “BE” with key pairs(3,15)
and (5,15).


Sample Questions

1. What are the major advantages of STP over UTP?
2. Describe the components of fiber optic cable. Draw a picture.
3. Why are slots used in DQDB?
4. What is the difference between network layer delivery and transport layer
delivery?
5. How can a device have more than one IP address?
6. Which control bit is involved in setting up a TCP session?
7. What factors effect the data rate of a link?
8. What are the advantages of FDDI over a basic token ring?
9. What 3 functions can SNMP perform to manage network devices?
10. What is the purpose of the timer at the sender in systems using ARQ?
11. Is there any drawback of using piggybacking?
12. Which of the following address does not belong to the same network(no
subnetting)? Explain why?

1. 130.31.23.31
2. 130.31.24.22
3. 130.32.23.21
4. 130.31.21.23
1. What are the two reasons for using layered protocols?
2. What do you mean by link to link layers of OSI reference model? Explain their
functions briefly?
3. Write a short note on ISDN?
4. What is the difference between boundary level masking and non- boundary level
masking? Give examples
5. Draw the IP datagram header format. “IP datagram has a checksum field still it is
called an unreliable protocol”. Justify?
6. What are the principles that were applied to arrive at the seven layers in OSI
model?
7. Explain the working of 3-bit sliding window protocol with suitable example.
8. Explain the following ARQ techniques in detail
1. Stop and wait for ARQ
2. Selective repeat ARQ

9. What are the reasons for using layered protocols?
10. 10 Enumerate the main responsibilities of data link layer?
11. Is the Nyquist theorem true for optical fiber or only for copper wire? Explain.
12. Why do data link layer protocols position the checksum in the trailer and not in
the header?
13. Compare the maximum window size in go-back- N and selective-repeat ARQs.
14. Why does ATM use the cell of small and fixed length?
15. Give the equivalent binary word for the polynomial x 8 +x 2 +x+1.
16. In which of the 7 layers of OSI will a service handling conversion of characters is
from EBCDIC to ASCII be normally implemented?
17. Where is the special IP address 127.0.0.0? used ?
18. Convert the IP address 197.228.17.56 into binary ?
19. Compare satellite with fiber as a communication medium and enumerate the
application areas where satellite still holds a niche(or special)marker.
20. A binary signal is sent over a 3-khz channel whose signal-to- noise ratio is 20
db.Calculate the maximum achievable data rate ?
21. What does ‘data transparency’ mean ? With the help of a flow chart, explain the
process of bit de-stuffing at the receiver’s end.
22. Assuming classful addressing, find the no of subnets and the no of hosts per
subnet foe the following blocks:
(i) 122.45.77.32/20

(ii) A class B block having mask of 255.255.192.0
23. Write short note on any four of the following:
(a) The ATM reference model
(b) HDLC
(c) Salient difference between ISO-OSI and TCP/IP models.
(d) Network Topologies and their uses.
(e) Wireless networks.
24. (a) Differentiate between static and dynamic channel allocation.
(b) List out the main responsibilities of the network layer.
(c) Give two examples of a ‘collision-free’ protocol ?
(d) Why is IP called ‘best-effort delivery’ protocol?
(e) What is a transparent bridge?
(f) what are the two sub layers of data link layer called ?
(g) What are the other names of IEEE 802.11 protocol or standard?
(h) What is the baud rate of a standard 10 mbps Ethernet LAN ?
(i) What is a minimum data size of an Ethernet frame ?
25. Explain distance vector routing . What are its limitations and how are they overcome?
26.Explain pure-ALOHA and slotted- ALOHA systems.Give the expression for
throughout for each,clearly explaining the various terms.
27. Explain 1-persistent, p-persistent and 0-persistent CSMA giving strong and weak
points of each.
28. Explain network equipment used in wired-LANS and explain the function of Hub,
Switch, and bridge.
29. Write short note on any four of the following:
(a) Token ring
(b) Various fields in Ethernet frame format
(c) Difference between congestion control and QoS(or Quality of service)
(d) FDDI
(e) Traffic shaping using token bucket algorithm
(f) CSMA/CD
30. If the transmitted code word is 10011000 and the received code word is 11001001.
What is the error word ? Write transmitted code word , received code word and error
word as polynomials.
31.Why transport layer protocols like TCP and UDP are called end-to- end protocols.
What is the difference between them?

32. Differentiate between:
(i) Baseband co-axial cable and broad band coaxial cable
(ii) Optical fibre and twisted pair
(iii) SMTP and SNMP
33. What are the basic functions of the data link layer? Write down the basic features of
HDLC protocol? Could HDLC be used as a data link protocol for a LAN? Justify your
answer.
34. The physical layer service is a non-confirmed service. Assume that some bits of data
are lost during transmission over physical media,which layer will detect the loss and take
some remedial measures. Explain any one method clearly depicting how this operation is
performed.
35. What are the advantages of cell switching that is used in ATM?
36. Outline and discuss the main fields in Ethernet IEEE 802.3 frame. What are the main
objectives of preamble ?

37. What is the average number of transmission required to send a frame of length 1600
bytes correctly, if the bit error rate is 1 x 10 -6 .
38. Explain what is meant by the term ‘integrated service digital network’. Give three
reasons a company might choose an ISDN link in preference to a leased line.
39. Subnet the class C network address 198.67.25.0 into eight subnets. Why are the ‘all
ones’ and ‘all zeroes’ subnets not used ?
40.What do you understand by the term ‘structured cabling’. State the main rules that
should be used when installing a cable. Show that maximum cabling area for LAN for
horizontal cabling runs is approximately 200m.
41. What are the various classes of IP addressing? Calculate the maximum number of
class A, B and C network Ids.
42. Why is a data link layer switch preferred over a hub ?
43. Which device is needed to connect two LANs with different network Ids ?
44. When is a translating bridge used ?
45. Can a switch be used to connect two LANs with different network IDs ?
46. Write two ways in which computer applications differ from network applications ?
47. What is count to infinity problem ?
48. What was the reason for selecting a speed of 155.52 Mbps in the original ATM
standard ?
49. Contrast link state and distance vector routing protocols, giving an example of each.
50. What is ISO-OSI reference model ? Compare it with TCP/IP reference model. Why
TCP/IP reference model is more popular than OSI model ? Which layer is used for the
following :
(i) to route packets
(ii) to convert packets to frame
(iii) to detect and correct errors
(iv) to run services like FTP, Telnet etc.
51. Discuss Shannon’s capacity. What implications does it have ?
52. Discuss how satellite network differs from traditional networks such as Ethernet,
Tokenbus.
53. What is packet switching ? Explain two different approaches of packet switching. ?
54. Doscuss the different factors affecting congestion control algorithms. ?
55. How does a token ring network work ? In what way is it different from Ethernet ?
56. Describe and distinguish between FDMA, TDMA, and CDMA.
57. Discuss the following terms with respect to ATM: VPI, UNI, asynchronous, AAL,
Cell , PVC.
58. What is sliding window protocol ? Differentiate between stop-and wait ARQ and
Go-back- N protocol.
59. Differentiate between ISO-OSI and TCP/IP reference model.
60. Explain leaky bucket algorithm and compare it with token bucket algorithm.
61. Explain ATM reference model.
62. Explain different kinds of Switching techniques.
63. Differentiate between Link state and Distance Vector Routing algorithm.
64. Explain network layer in ATM,
65. Differentiate between IEEE 802.3, IEEE 802.4 and IEEE 802.5 standards.

66. Explain any three error detection and correction techniques.
67. Explain various cabling techniques used in IEEE 802.3 standard,





(P) UNIT WISE QUESTION BANK

UNIT I

DATA COMMUNICATIONS
PART A ( 2 Marks)


1. Define Data communication
2. List out the characteristics of data communication
3. What are the components of data communication?
4. What are the various forms of data?
5. What are the various types of data flow?
6. Define networks
7. Define Distributed Systems
8. Define Distributed Processing
9. Define Transit time and Response time
10. Define Topology
11. What are the types of topology available and the number of links required to connect n
match
12. Define Protocol.
13. Why are protocols needed?
14. What are the key elements of a protocol?
15. Why are standards needed?

16. Who is the standard committee?
17. Define OSI model
18. What are the seven layers of OSI Model?
19. Define Network architecture
20. Define Protocol stack
21. Define Transmission medium
22. Define Guided Media
23. Define Unguided media
24. Define Line coding
25. What is the relationship between the data element and signal element?
26. Define data rate and signal rate
27. Define Bandwidth
28. What is the line coding scheme available?
29. How does NRZ – L differ from NRZ – I?
30. Define Modem
31. What are the standards available in modem?
32. Discuss the mode for propagating light along optical channels
33. What is the difference between a passive and an active hub?
34. What are the three criteria necessary for effective and efficient networks?

PART B
1. What are the functions of OSI layers? Discuss. (16)
2. a. Explain the types of line coding with neat diagrams. (8)
b. Explain about the RS-232 interface. (8)
3. Explain in detail about the types of topologies. (16)
4. Explain detail about the transmission media for data transmission. (16)
5. a. i. What is a protocol? List the three key elements of a protocol. (4)
ii. With relevant examples differentiate between simplex, half duplex, and full duplex
communication. (4)
b .i. A sine wave completes one cycle in 25 microseconds. What is its frequency?
Express the frequency in kHz. (4)
ii. A digital signal has a bit interval of 40 microseconds. What is the bit rate? Express
the bit rate in Kbps. (4)
6. What is the difference between a protocol and a service interface? Explain in terms of a
ISO seven layer model. (16)
7. a. List the four properties by which transmission media can differ (4)
b. Three packet switching networks each contain n nodes. The networks have a star
topology with a central switch, a ring
respectively and a third is fully interconnected with a wire from every node to every
other node. What are the best, average and
worst case transmission paths in hops? (12)
8. a. Describe the key elements of protocols and the standards. (8)
b. Explain in detail the data transmission in OSI reference model. (8)

UNIT II
DATA LINK LAYER
PART A ( 2 Marks)

1. List out the functions of data link control.

2. Define errors.
3. List out the types of error.
4. Define error detection.
5. Define error correction.
6. List out error correction mechanism.
7. Define Block coding.
8. Draw the process of error detection in block coding?
9. Define hamming distance.
10. Find the Hamming distance
11. Define simple parity check code.
12. Define flow control.
13. Define error control.
14. Define ARQ
15. Define Piggybacking
16. Define sliding window
17. Define HDLC and its transfer mode.
18. List out the frames in HDLC and its purpose.
19. Draw the neat diagrams of a frame format of various frames of HDLC.
20. List out the control field for S frames.
21. Define LAN & List out the technologies.
22. What are the two sublayers of Data Link layer and define its functional
23. Draw the frame format of Ethernet.
24. List out the Ethernet types.
25. Define CSMA /CD
26. Define NAV.
27. Define the frame format of IEEE 802.5
28. Define FDDI.
29. What are the devices used in SONET.
30. What are the four SONET layers?

PART B


1. a. Define CRC. Explain CRC generator & CRC checks in detail with one example(10)
b. Explain in detail about error correction using Hamming code. ( 6 )
2. Explain HDLC and explain it in detail. (16)
3. a. Given a 10 bit sequence 1010011110 and a divisor of 1011 find the CRC.Check the
answer (10)
b. But stuff the following data (6)i. 0001111110111110011110011111001
ii.
0001111111111111111111111111111111111001111100
14. What is IEEE 802.3? What are the types of Ethernet? Discuss. (16)
5. Draw the sender and receiver window for a system using Go Back N ARQ and
selective repeat ARQ, given the following (16)
a. Frame 0 is sent, frame 0 is acknowledged. Frames 1 and 2 are sent, frames 1 and 2 are
acknowledge. Frames 3,4 and 5 are sent;
frame 4 is acknowledged; a timer for frame 5 expires. Frames 5,6 and 7 are sent; frames 4
through 7 are acknowledged
6. Discuss Token Bus & Token Ring networks in detail. (16)
7. Define FDDI & its needs in detail. (16)
8. a. What is SONET? (2)
b. Name some layers of SONET &its functions. (6)
c. Discuss SONET frame in detail with a neat diagram. (8)

9. a. Define bridges? (2)
b. The difference between bridges and repeaters. (4)
c. Explain the loop problems solved by bridges. (10)
UNIT III
NETWORK LAYER
PART A ( 2 Marks)


1. Define internetworking?
2. Distinguish between networking and internetworking.
3. What are the devices used for internetworking?
4. What do you mean by switching and mention its types?
5. What is the difference between packet switching and circuit switching?
6. Mention any two advantages of subnetting.
7. What are the approaches in packet switching?
8. What are the two main elements of distance vector routing?
9. What is the role of packet lifetime?
10. Give the fields available in IP address.
11. What is meant by classful addressing?
12. Define Unicast, multicast, and broadcast.
13. Compare Ethernet address with IP address.
14. What are the functions of IP Protocol?
15. Identify the class and default subnet mask of the IP address 217.65.10.7.
16. Distinguish between bridges and routers.
PART B


1. What is the internet? Imagine an organization where the internet is needed & discuss it in
detail with a neat diagram. (16)
2. Explain in detail about datagram approach and compare with circuit switching.(16)
3. a. Explain Routing Table and Routing Module (8)
b. A company is granted the site address 201.70.64.0. The company needs 6
subnets.Design the subnets. (8)
4. a. How is the looping problem solved by switches and by routers? How
do switches/routers handle link failure? (8)
b. Explain the IP addressing. (8)
5. a. Change the following IP address from dotted decimal notation to binary notation. (2)
i. 114.34.2.8 ii. 129.14.6.8b.
Change the following IP address from binary notation to dotted decimal notation. (2)
i. 01111111 11110000 01100111 01111101
ii. 11110111 11110011 10000111 11011101c.
Find the net and host id of the IP addresses (2)
i. 241.34.2.8
ii. 11101111 11110111 11000111 00011101d.
In a class C subnet, find out the network address (2)i.IP address: 182.44.82.16Mask:
255.255.255.192e.
What is the maximum number of subnets in class A / B using the following masks.(8)i.
255.255.192.0ii.
255.192.0.0iii.255.255.0.0iv. 255.255.224.0

UNIT IV
TRANSPORT LAYER
PART A ( 2 Marks)


1. What are the services provided by the transport layer?
2. Define reliability and its aspects.
3. Define multiplexing.
4. Define RTT.
5. What is the purpose of the Urgent pointer in the TCP header?
6. What is meant by the slow start in TCP?
7. Define socket.
8. Define datagram socket.
9. Draw a neat diagram of a transport layer segment.
10. Differentiate between TCP and UDP.
11. Define QoS.
12. What are the steps in the call set up the process?
13. Define integrated services.
14. Name some tuples which are used to identify a TCP socket.
15. What do you mean by congestion?
16. What are the types of congestion control? Explain.
17. Define flow control?

PART B


1. A client uses UDP to send data to a server. The data are 16 bytes. Calculate the
efficiency of the transmission at the UDP Level (16)
2. Explain the concepts behind in the Silly Window Syndrome. (16)
3. a. Draw and explain in detail about the State Transmission diagram of TCP (8)
b. Explain in detail about congestion avoidance in TCP (8)
4. a. Define UDP. (2)
b. Explain the segment format of UDP (6)
c. Explain in detail about congestion control (8)
5. a. Explain the three phases of TCP (8)
b. Explain the segment format of TCP (8)
6. Explain in detail about various techniques to improve Qos (16)
7. Explain in detail about integrated services (16)
UNIT V
APPLICATION LAYER
PART A ( 2 Marks)

1. Define DNS.
2. Name some generic domain labels
.3. What are the four main properties of HTTP?
4. Describe why HTTP is designed as a stateless protocol.
5. Define virtual terminal.
6. What do you mean by active web pages?
7. What are the transmission modes of FTP?
8. Compare HTTP and FTP.
9. What are the types of source records?
10. What do you mean by FTP?
11. Draw the basic model of FTP.
12. What are the things supported by SMTP?

13. Draw the General format of HTTP request messages.
14. What are the categories of web documents and specify the languages which it issued
for each
15. What are the things define by URL?
16. What are the aspects of information security?
17. Name some security services.
18. What are the types of security attacks?
19. Define AES.
20. Write the steps for an RSA.
21. What is the relationship between CGI & dynamic documents?
22. What is an active document?
23. What is conventional encryption?
24. Define the structure of data in FTP.
25. Define Catching in DNS.


PART B


1. Define DNS and explain the major sections of DNS in detail? (16)
2. With a neat diagram explain the basic model of FTP? (16)
3. What is public key cryptography and explain RSA in detail with one example.(16)
4. Explain various types of substitution techniques. (16)
5. a. SMTP, FTP, and HTTP are protocols to transfer messages from one point to another.
Compare and contrast their use (8)
b. Write short notes on HTTP Request and Response messages (8)
6. Explain in detail about SMTP. (16)
7. a. Use the following encryption algorithm to encrypt the message, a. Replace each
character with it’s ASCII codeb. Add
a 0 bit at the left to make each character 8 bits longc. Swap the first 4 bits with the
last 4 bits.d. Replace every 4 bits
with its hexadecimal equivalentWhat is the key in this method (8)
b. Using the RSA algorithm, encrypt and decrypt the message “BE” with key
pairs(3,15) and (5,15). (8)

PART B

UNIT I
1. Explain in detail the error detection and error corrections.(UQ)
2. Discuss in detail about the layers of OSI model. (UQ)
3. Discuss in detail about HDLC.
4. Discuss in detail about SONET.
5. Explain the different approaches of framing in detail.
6. Write the Sliding Window Algorithm and explain it in detail.
7. Compare Stop and Wait for ARQ scheme with sliding window ARQ scheme.
8. Write in detail about the flow control mechanisms.
UNIT II

1. Name the four basic network topologies and explain them giving all the relevant
features.(UQ)
2. Explain the functioning of wireless LAN in detail.(UQ)
3. Explain Ethernet in detail.
4. Discuss the frame format of a token ring in detail.
5. Differentiate FDDI from token ring
6. Write in detail about Resilient Packet Ring.
7. Write short notes on WI-Fi, Wi- Max.
8. Write short notes on Cellphone technologies.

UNIT III
1. Write notes on the following(UQ)
(i) Internet Protocol.
(ii) Routers.
2. Discuss in detail the various aspects of IPV6. (UQ)
3. What are the different approaches in Packet Switching?Explain them in detail.
4. Write in detail about bridges.
5. Discuss the spanning tree algorithm in detail.
6. What are the limitations of bridges?
7. Explain in detail the ATM cell format.
8. Explain about the different AAL protocols.
9. Discuss DHCP in detail.
10. Explain Distance Vector routing in detail.
11. Explain OSPF in detail.
12. Discuss RIP in detail.
13. Problems in subnetting.
14. Write short notes on the following
i. Broadcasting
ii. Multicasting
iii. ARP
iv. RARP

UNIT IV
1. With neat architecture, explain TCP in detail.

2. Explain adaptive flow control in detail and its uses.
3. With neat architecture, explain UDP in detail.
4. Discuss the different Queuing Discipline in detail.
5. Explain the Congestion Avoidance techniques in detail.
6. Explain TCP Congestion control techniques in detail.
7. Explain how QoS is provided through Integrated Services.
8. Explain how QoS is provided through Differentiated Services.

UNIT V
1. Explain the SMTP and HTTP. Give their uses, state strengths, and weaknesses.
2. Explain the role of a DNS on a computer network.
3. Explain Email protocols in detail.
4. Discuss FTP in detail.
5. Discuss SNMP and Telnet in detail.
6. Write short notes on
i. PGP
ii. SSH

Machine Learning for Agriculture

  Machine learning has the potential to revolutionize agriculture by helping farmers make more informed decisions and optimize their operati...