Gujarat University BCA,BBA,B.Com,M.Com solved question paper available
www.dotcombooks4u.com
9825183881
www.dotcombooks4u.com
9825183881
Dotcom Publications was founded as server in the field of education. We have dedicated ourselves to help and reach the people who want to go for higher / technical education but are helpless to achieve their goal due to non-availability of proper guidance and help.
Sunday, 25 September 2016
GTU MBA/MCA Solved question paper available
GTU MBA/MCA Solved question paper available
www.dotcombooks4u.com
9825183881
www.dotcombooks4u.com
9825183881
Sunday, 4 September 2016
Assignment July - 2016 & January - 2017 MCSE-011
MCSE-011
1. Explain how
instruction set, compiler technology, CPU implementation and Control affect the
CPU performance and Justify the effects in terms of Program Length, Clock Rate,
and Effective CPI. (25 Marks)
2. Compare
control-flow and data flow in terms of the Program Flow mechanism used. (25 Marks)
3. Explain the
applicability and the restrictions involved in using Amdahl’s law and
Gustafson’s Law to estimate the speed up performance of an n-processor system
compared with that of a single processor system. Ignore all communication
overheads. (25 Marks)
4. Explain
the structures and operational requirements of the instruction pipelines used
in CISC and Scalar RISC. Comment on the cycles per instruction expected from
these processor architectures.
*****************************************************************
Note: Answer with Dotcom Books
www.dotcombooks4u.com
(Last 5 year solved question
paper with Assignment solutions)
9825183881
****************************************************************
Assignment July - 2016 & January - 2017 MCSE-004
MCSE-004
1. (a) If 0.333 is the approximate value of 1/3, then find absolute,
relative and percentage errors.
(6 Marks)
(b) For
x = 0.4845 and y = 0.4800, calculate the value of (x2 – y2) / (x +y) using normalized floating point arithmetic compare value with
the value of (x – y). (4 Marks)
2. (a) Find the real root of equation f(x) = x3 – x – 1 = 0 using Bisection method. (5 Marks)
(b) How many
iterations of Bisection method are required to be performed, to obtain smallest
positive root of x3 – 2x – 5 = 0, correct upto 2 decimal
places. (3 Marks)
(c) Use Newton’s method to find root of the
equation x3 – 2x – 5 = 0 (5 Marks)
3. (a) Use Gauss
Elimination to solve
10x1
– 7x2 = 7;
-3x1
+ 2.099x2 + 6x3 = 3.901;
5x1
– x2 + 5x3 = 6.
Correct to six decimal places of significant digit.
(b) Solve Ax = B, where
LU decomposition method.
(c) Solve the
following system of equations using (i) Jacobi Method (ii) Gauss – seidel
method
x + y – z = 0;
- x + 3y = Z,
x – 2z = 3,
assume the initial solution vector as [ 0.8 0.8
2.1]T (10 Marks)
4. (a) For the
given discrete data find the interpolating polynomial using
(i) Lagrange’s interpolation
(ii) Newton Divided difference interfdation
|
xi
|
0
|
1
|
3
|
|
|
Fi
|
1
|
3
|
55
|
|
(b) Evaluate
by using (i) Simpson’s 1/3 rule (ii) Simpson’s 3/8 rule (iii)
Weddle’s rule
(c) Solve the
difference equation
(where y(0) = 2) find y(0.1) and y(0.3) correct to four
decimal places using
(i) Runge-kutta second order formula
(ii) Runge-Kutta Fourth order formula
5. Find the two
regression lines from the following data
|
X
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
|
Y
|
10
|
12
|
16
|
28
|
25
|
36
|
41
|
49
|
40
|
50
|
|
*****************************************************************
Note: Answer with Dotcom Books
www.dotcombooks4u.com
(Last 5 year solved question
paper with Assignment solutions)
9825183881
****************************************************************
Assignment July - 2016 & January - 2017 MCSE-003
MCSE-003
1. How does the
use of heuristics reduce the search space? Suggest a heuristic function for
travelling salesman problem. (10 Marks)
2. Explain the
following knowledge representation techniques with suitable example. (10
Marks)
(i) Semantic Net
(ii) Rule-Based Representation
3. (a) Differentiate between an expert system and a conventional system. (2.5
Marks)
(b) Discuss state space representation for the
following: (7.5 Marks)
(i) Traveling Salesman Problem
(ii) Water-Jug Problem,
(iii) Human Cannibal River-Crossing Problem.
4. (a) Write a
recursive function in LISP named partial-factorial that takes two natural
numbers m and n as arguments, and then computes the product of all natural
numbers between m and n (including m both m and n). It is not necessary that m
is less than n. (5 Marks)
(b) Write a PROLOG
programme that answers questions about family members and relationships.
Include predicates and rules which define sister, brother, father, mother,
grandfather, grand-child and uncle. The programme should be able to answer
queries such as the following:
?
– grandfather (X, mohan)
?
– grandchild (X, Y)
?
– uncle (phillips, mary)
?
– mother (ruksana, X)
5. What
are Agents ? Discuss various types of agents with reference to their relevance
and significance in expert systems. (10 Marks)
6. (a) Give Frame-Based Representation for the
following facts:
Ramesh
is a 35-year-old Professor of Hindi in Delhi University.
The
name of his wife, son and daughter are respectively Kavita, Ravi and Sameera. (5 Marks)
(b) Give Semantic Net
representation (instead of Frame-based representation) of the facts given in part
(a) of this question. (5 Marks)
7. (a) Compare backward reasoning and forward reasoning strategies in
Artificial Intelligence. (5 Marks)
(b) Explain each of the following w.r.t. the
discipline of Artificial Intelligence : (5 Marks)
(i) Learning
(ii) Understanding
(iii)
The Turing Test
(iv) Uncertainty
(v) A.I. problem
8. Write
A* algorithm. How is A* algorithm different from AO*? Out of the two which one
is better and why? Justify with suitable arguments.
*****************************************************************
Note: Answer with Dotcom Books
www.dotcombooks4u.com
(Last 5 year solved question
paper with Assignment solutions)
9825183881
Assignment July - 2016 & January - 2017 MCSL-054
MCSL-054
PART-I: MCS-051 (Advanced Internet Technologies)
1. Develop
a web page using servlet to display the details of teachers who are teaching
the 5th semester courses of MCA programme. (4 Marks)
2. Write
a JSP program for an NGO, which displays a web page with NGO basic information
and containing two web links one for organization details such as objectives,
people associated with NGO, current date and time and some activities
photographs etc. Other link show the schedules of future activities and details
of work plan and peoples association for these activities. On clicking these
web links web page open with necessary details. Make necessary assumptions
require. (7 Marks)
3. Create
a web page for registration of participants in a J2EE Programming Quiz
completion organised by an Institution. (5 Marks)
4. Create
an XML document for Reservation of Tickets of Indianan Railways. (4
Marks)
PART-II: MCS-053 (Computer Graphics and Multimedia)
1. Write a program in C/C++
using OpenGL to draw a circle of orange colour and inside that draw a triangle
of green colour. (4 Marks)
2. Write a program in C/C++
using OpenGL to show a ball rolling. (4 Marks)
3. Write a program in C or
C++ to implement Bresenham's circle generation algorithm. (4
Marks)
4. Write a program in C/C++ to
implement Following Algorithms:
1. DDA
line drawing algorithm.
2. Cohen-Sutherland
line clipping algorithm.
*****************************************************************
Note: Answer with Dotcom Books
www.dotcombooks4u.com
(Last 5 year solved question
paper with Assignment solutions)
9825183881
Assignment July - 2016 & January - 2017 MCS-053
MCS-053
1. What is Computer Graphics ? Discuss the role of
Computer Graphics in image processing, scientific visualization and
simulations. (5 Marks)
2. Differentiate between, any two of the following (5
Marks)
(i) Random scan & Raster scan display
devices
(ii) Drawing & Painting
(iii) Graphics & Animation
3. Write DDA Algorithm for lines with positive slopes.
Modify it for negative sloped lines. Apply DDA Algorithm to draw line segment
from (3, 5) to (9, 9). Verify the existence of staircase effect in the line,
generated. (5 Marks)
4. Discuss the recursive approach for scan lane polygon
filling. (5 Marks)
5. Find the transformation matrix for the reflection
about line Y = X. (5 Marks)
6. Reflect the polygon ABCD
with vertices (5 Marks)
A(-1, 0),
B(0, -2), C(1, 0) and D(0, 2); about
(i) y = 2
(ii) x = 2 (iii) y = x + 2
7. Obtain the transformation matrix for perspective
projection of an object, projected on to x
= 3 plane and viewed from (5, 0, 0). (5
Marks)
8. Apply Cyrus Beck Algorithm to clip a line segment,
passing through Non-Convex window. Discuss all steps with suitable explanation.
(5 Marks)
9. Write Bresenham Line generation algorithm. Use it to
generate line segment between (15, 5) and (25, 13). (5 Marks)
10. Write Bresenham circle generation algorithm. Use it to generate a
circle of radius 5 units, in the 1st Quadrent from x = 0 to x = y. (5 Marks)
11. Find the equation of the Berier curve, which passes through the points
(0, 0) and (-2, 1), and is controlled through the points (7, 5) and (2, 0). (5 Marks)
12. Discuss how the depth value (Z) is calculated for the surface position
(x, y) in the Z-buffer algorithm.
13. Differentiate the following (7.5 Marks)
(i) Ray tracing & Ray casting
(ii) Gourand & Phong shading
(iii) Specular & Diffused reflection
14. Discuss the mathematical formulation used to simulate all categories of
accelerations i.e., zero & non zero both, in any animation. (5 Marks)
15. Write short notes on
(i) Authoring tools & its types
(ii) Multimedia tools & its types
(iii) Video file formats
*****************************************************************
Note: Answer with Dotcom Books
www.dotcombooks4u.com
(Last 5 year solved question
paper with Assignment solutions)
9825183881
Assignment July - 2016 & January - 2017 MCS-052
MCS-052
1. Explain in brief the basic principles that should be
considered while designing an organization structure. What are the shortcomings
in vertical organisational structure? Discuss. (10 Marks)
2. What is the concept of Enterprise Resource Planning?
Discuss some of the basic features of ERP. Also, differentiate between
Enterprise Resource Planning (ERP), and Supply Chain Management (SCM). (10 Marks)
3. (a) Explain the
concept of database? List the advantages of DBMS over file processing system.
(5 Marks)
(b) Discuss why
management needs information. Is it possible for the management of an
organization to make effective decisions without the aid of an information
system? (5 Marks)
4. (a) Why is it
important to correctly identify the objects and their relationships early in
the development process? (5 Marks)
(b) What is data
modelling? Differentiate between logical and physical models. Give any three
reasons why logical models are superior for structuring business requirements. (5 Marks)
5. (a) Explain the
role of a system analyst as an agent of change. Why are interpersonal and
technical skills necessary in system development? (5 Marks)
(b) Discuss the
different tools used to automate the Portfolio Management Processes. (5 Marks)
6. List the main stages in the development of a system
and briefly describe the work carried out by the system analyst at each stage.
What is the difference between system analysis and system design? Can one begin
to design without analysis? Explain.
7. Discuss the role of intelligent systems in
e-business. Also, explain different roles of business intelligence tools in
different management levels. (10 Marks)
8. What are the drawbacks and challenges of IT
(Information Technology) development in business and management? Suggest some
solutions to avoid these drawbacks and misuse of information technology.
*****************************************************************
Note: Answer with Dotcom Books
www.dotcombooks4u.com
(Last 5 year solved question
paper with Assignment solutions)
9825183881
Assignment July - 2016 & January - 2017 MCS-051
MCS-051
1. (a) A business
organization has a telephone directory that records details of every employee
working in the organization in form of empid, empfirstname, designation, age
and email address. Every employee is attached to a particular department which
is the main organizing unit of the organization. The telephone directory is
typically displayed in department order hierarchy and shows for each department
the contact phone, fax number and email address.
Create an XML file containing some directory data.
Also give reasons for using XML. In what ways are XML DTD and Schema are
similar to or different from each other.
[Note: Show at least two departments and five
employees in each department in the XML file.] (7 Marks)
(b) What do you mean by XML parsing ? (3 Marks)
2. (a) Make a very
simple online banking application that collects a customer ID and inputs the
first name, last name and bank account balance of the customer with that ID. It
should give an error page for an unknown ID. Data is stored in Oracle database.
Write the programe using Servlet and JDBC. (7 Marks)
(b) Write in brief how do you use JDBC to query
and modify a database. (3 Marks)
3. (a) Make a
course registration form using JSP that collects a first name, last name,
contact no. Email address, age and course name.
(i) Validate it if the user name, and e-mail address are not blank.
Display error message to user, if either of them is blank.
(ii) Validate if the user name already exists and display an error
message to the user.
(iii) Create text boxes for first name, last name, contact number, email
address, age and course name.
(iv) Use 3 check boxes for multiple selection.
(v) Send the registration information to a Servlet that stores data in
Oracle database and displays it. (use HTTP post method)
(b) What is a customer tag in JSP ? Explain. (3 Marks)
4. Assume there is a course registration table with the
following fields student_id, name, course name, email address. Add at least 10
records. Write and run a Java programe to make queries to the course
registration table and modify it using JDBC APIs. (7 Marks)
5. What are the advantages of using Java’s multiple layer
security implementation ? Explain with the help of an example programe. (8 Marks)
6. (a) Describe
the layer architecture of EJB and explain all its components briefly. (7 Marks)
(b) What is the
advantage of using Entity bean over directly using JDBC API to do database
operations. (5 Marks)
7. What do you mean by
session tracking ? Also explain in brief different ways to handle session
tracking ? (5 Marks)
8. Explain four basic mechanisms
which a web client can authenticate a user to a web server during HTTP
authentication.
*****************************************************************
Note: Answer with Dotcom Books
www.dotcombooks4u.com
(Last 5 year solved question
paper with Assignment solutions)
9825183881
****************************************************************
Assignment July - 2016 & January - 2017 MCSL-045
MCSL-045
PART-I: MCS-041
1. Write the UNIX commands for the following :
(a) Use the more command, and a pipe to send the contents of your .profile and .shrc files to the screen.
(b) Use head and tail
in a pipeline to display lines 10 through 15 of a file?
(c) To search the /etc/passwd file for the string given
by the user and display whether it is found.
(d) To display the
lines in /etc/passwd that
begins with the character “a”.
(e) List all the files
in the /tmp directory owned by
the user root.
(f) To see a complete
listing of all the processes currently scheduled.
(g) Use the ps command, and the grep command, in a pipeline to find all
the processes owned by you.
(h) To force
termination of a job whose process ID is
given.
(i) Sort the /etc/passwd
file, place the results in a file called paswd, and trap any errors in a file called err with the command.
(j) To sort a text file containing the names of 10 students
in alphabetical order and place
the results in a file called sortedfile.
(5 Marks)
2. (a) Write
a shell program to count the number of special symbols, end of line characters
and blank-spaces present in a text file. Redirect the output to a file called
as output. (5 Marks)
(b) Write a shell
script to take username as an argument and check whether s/he has logged in or
not for every 30 seconds for 5 minutes.
(c) Write a shell
script to display the number of files and their details in the current
directory, whose filenames are starting with the character “b”. (5 Marks)
PART-II: MCS-043
1. (a) Create
an appropriate database using Oracle for a “MCA Evaluation System” for all the
6 semesters. It should cater to the student-wise marks entry for all the
assignments and term end exam of all the courses, marks processing, calculation
of total marks, generation of grade card etc.. Perform Normalization, to the
required levels. (10 Marks)
Note: Assumptions can be
made wherever necessary. Follow the evaluation scheme given in your MCA
Programme Guide.
(b) Perform following queries using SQL:
(i) To find the total no. of marks for all the assignments submitted
by a student in 5 semesters, if the enrolment no. is given.
(ii) To find the total no. of marks for all the Term End Exams of a
student in 5 semesters, if the enrolment no. is given.
(iii) To display the list of student who have passed in all the first
semester assignments.
(iv) To display the list of all the students who scored more than 70% in
MCS-011.
(v) To display the list of all the students who were failed in MCS-011
course. (5 Marks)
(c) Write appropriate
triggers, exceptions and functions for the above said system database schema
and describe them briefly.
*****************************************************************
Note: Answer with Dotcom Books
www.dotcombooks4u.com
(Last 5 year solved question
paper with Assignment solutions)
9825183881
****************************************************************
Assignment July - 2016 & January - 2017 MCSP-044
MCSP-044
Background
and Project Specifications: A medical
store needs to maintain its inventory of medicines and other products using a
computerized system. It is planning to create a network of computers which
should be placed at various sales and cash counters. It also proposes to have a
centralized workstation for the database and system administrators. Customer
orders are accepted at the sales counters which in turn produces a medicine
collection challan. The challan includes the order number, name of medicine,
batch number, date of expiry, shelf number where it is kept and quantity
ordered. One order may contain more than one medicine. As per challan,
medicines are put in a basket by a person, who passes it to billing assistant.
Billing assistant checks the medicine is as per the challan, any shortcoming is
either corrected or reported to customer. On receiving conformation from the
customer the bill is generated. The cash counter collects the money as per the
bill and dispenses the medicine to the customer.
This
system also produces reports relating to daily sales, list of medicines that
needs to be procured for the medical store, the list of medicines that are
nearing expiry date etc. You may study the requirements from a medicine shop
for more details. Perform the following tasks for the system given above:
1. (a)
Which System Development Life Cycle
(SDLC) will you propose for the specification given above? (5 Marks)
(b) Justify you selection by evaluating
suitability of at least two SDLCs. (5 Marks)
2. (a) What would be major costs of the system? (2 Marks)
(b) What may be the financial benefits of
installing such a system? (2 Marks)
(c) Perform a cost-benefit analysis for the
proposed software and report its findings. (2 Marks)
(d) List the major
tasks and milestones of the Project and make a project schedule. You must make
both GANTT and PERT charts. Explain the two charts drawn by you. (4 Marks)
3. (a)
Study the system and create a software
requirement specification. You must identify either processes or objects while
analyzing. During the analysis give consideration to possible input and output
of the processes. (15 Marks)
(b) After identifying
the requirements, create Analysis Models. You may either use the classical
approach and draw Entity relationship diagram and data flow diagrams (DFD’s) up
to level 2-3; or you may take object oriented analysis approach and create
class diagram, use case diagram, use cases etc. (10 Marks)
4. (a)
Design the system architecture and the
database as per the needs of the system. You must perform normalization on
relations up to 3rd normal form. The table design must include Primary and
Foreign keys and constrains. (15 Marks)
(b) Create the system
flow chart or detailed process design and state transition diagrams. Also
design the user input screens and output report formats. (10
Marks)
5. Design
various unit test cases for different testing techniques/strategies.
*****************************************************************
Note: Answer with Dotcom Books
www.dotcombooks4u.com
(Last 5 year solved question
paper with Assignment solutions)
9825183881
****************************************************************
Subscribe to:
Posts (Atom)