UT-6/J-25:56020
ESSENTIALS OF INFORMATION TECHNOLOGY
CSE-304
M.M. 75
Time-3 Hrs
Note: All questions in Part-A and Part-B are compulsory. Attempt any four questions from
Part-C selecting at least one from each unit.
PART-A (15 Marks)
Q. No. – 1 Answer the following questions. 15x1=15
(i) What is the use of this keyword in Java?
(ii) 4.
Define D
array.
(iii) Define Algorithm.
(iv) What is method overloading?
(v) What are the four basic data types in Java?
(vi) What do you mean by object?
(vii) What is the difference between instance variables and static variables?
(viii) Define Multiple inheritance.
(ix) Define a primary key in a relational database.
(x) What is command line argument?
(xi) What is an interface in Java?
(xii) What is class diagram?
(xiii) Define relational schema.
(xiv) Define Normalization.
(xv) What is an ER model in database design?
PART-B (20 Marks)
UNIT-I
2 Write an algorithm of Insertion sort and explain it with the help of example. 5
UNIT-II
3 What are access specifiers in Java? Explain their types with suitable examples. 5
UNIT-III
4 Differentiate between static and dynamic polymorphism in Java with examples. 5
UNIT-IV
5 What are the different types of SQL statements (DDL, DML, DCL)? 5
PART-C (40 Marks)
UNIT-I
6 What is stack? Explain its operations with suitable algorithms and examples. 10
7 What is sorting? Write an algorithm of insertion sort and explain with example. 10
UNIT-II
8 (a) Write a program to print factorial of a number using java. 5
(b) Discuss the importance of constructors in Java. Explain with example. 5
9 Explain the use of UML diagrams in software development. How are use case 10
diagrams and class diagrams used to represent a system?
UNIT-III
10 Write a Java program to determine method overloading and method overriding. 10
11 Define inheritance and discuss its various types. Write a java program to 10
implement single Inheritance.
UNIT-IV
12 Explain the process of database normalization. Discuss 1NF, 2NF, and 3NF with 10
examples.
13 Elaborate ER Model with suitable example. Explain the conversion of ER Model 10
into relational algebra.
