There are eight questions in this assignment. Each question carries 10 marks. Rest 20 marks are for viva-voce. Answer all the questions. You may use illustrations and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation.

Q1:
Create a Telephone directory using JSP and store all the information within a database, so that later could be retrieved as per the requirement. Make your own assumptions.

Q2:
Create a student enquiry system using EJB through which a student could enquire about the Program / Courses on offer by the different Schools of Studies of a particular University.

Q3:
Write a program using Servlet and JDBC which takes a name, telephone number and an id number issued by the telephone company and provides online detailed information regarding the monthly bill a customer has to pay. Make your own assumptions.

Q4:
Create a database of students enrolled at your study center who are working in a BPO company and then write a program using JSP and JDBC to display their names, addresses and the names of the companies where they are working currently.

Q5:
Using Servlet, JSP, JDBC and XML, create a web application for a tourist company to provide online help in the searching for tourist places across the country, and other details like cost, and how to reach these places.

Q6:
Implement the award list of MCA final year students as an XML document. The table must have student name, enrolment number, three subjects and its score.

Q7:
Write a XML document that gives an introduction of the third block of MCS-051. (i.e., Block introduction).

Q8:
Write a servlet application that displays the current time, date and the number of hits if a person opens a particular web site.

This assignment has eight questions. Answer all questions. Each question is of 10 marks. Rest 20 marks are for viva voce. You may use illustrations and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation. Answer to each part of the question should be confined to about 300 words.

Q1:
Define what do you mean by Management Information System. What role does MIS play in an organization?
(10 Marks)

Q2:
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? Discuss.
(10 Marks)

Q3:
What is the purpose of Decision Support Systems in MIS? List few characteristics of DSS.
(10 Marks)

Q4:
How are databases used in e-business? How does e-business fit into different locations within the production chain?
(10 Marks)

Q5:
Define OLAP. What is the role of OLAP in decision-making? What does the term drill mean down in an executive information system?
(10 Marks)

Q6:
Explain different components of an ERP? Outline the main stages in the development of an ERP system.
(10 Marks)

Q7:
Explain some of the security threats to information systems? How does encryption ensure data security?
(10 Marks)

Q8:
Explain the advantages of outsourcing computer facilities. Also explain some of its drawbacks. (10 Marks)

There are four questions in this assignment. Answer all the questions. 20 Marks are for viva-voce. You may use illustrations and diagrams to enhance explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation.

Q1:
a) Digitize a line from point (-1, -1) to point (4, 5) using Bresenham’s Line Generation Algorithm. (5 Marks)

b) Find out (using Bresenham algorithm) the pixel location approximating the first octant of a circle having center at (0,0) and radius 5. (5 Marks)

c) Compare and contrast the following:
i) Cyrus Beck and Cohen Sutherland Line clipping algorithms
ii) Random and Raster Scan display devices (5 Marks)

d) With the help of suitable diagram and related tables describe how frame buffer can be used to control the color and intensity of the picture display? (5 Marks)

Q2:
a) Say ABC is a triangle with coordinates A(-2,0), B(-1,1), C(-1,-1).
Find the transformed coordinates when the triangle ABC is subjected to the anticlockwise rotation of 45° about an axis passing through the centroid of the triangle such that it is parallel to y-axis? (5 Marks)

c) A polygon has 4 vertices located at A (10, 10) B (10, 40), C (40,10), D (40,40). Indicate a transformation matrix to have its reflection about X-axis? (5 Marks)

d) Obtain the Perspective projection on the X=Z plane, with center of projection being at (-1,0,0), also find principal vanishing point? (5 Marks)

e) Compare and contrast the perspective projection with the parallel projection? Justify your answer that parallel projections preserves lateral measurements? (5 Marks)

Q3:
a) Find equation of Bezier curve which passes through points (0, 0) and (– 2, 1) and is controlled through points (7, 5) and (2, 0). (5 Marks)

b) A Bezier curve is to be drawn given the control points P1 (40, 40), P2 (10, 40), P3 (60, 60), P4 (60, 0). Calculate the coordinates of the points on the curve corresponding to the parameter t = 0.2, 0.4, 0.6. Draw a rough sketch of the curve and show coordinates of various points on it.? (5 Marks)

c) Briefly discuss the concept of following: (5 Marks)
• Hidden surface removal algorithms
• Phong shading

d) What do you mean by Specular reflection?Is their any relation of surface texture with the type of reflection produced on the exposure of that surface to some light source? Explain with the help of diagram and suitable mathematical equations? (5 Marks)

Q4:
a) Differentiate between following:- (5 Marks)
• Morphing and Panning
• Motion Specific animation and Motion Generalized animation

b) How many key frames are required to produce an animation film Sequence with duplications, having duration of five minutes? (3 Marks)

c) What do you mean by terms Cel animation and Sprite animation? Suggest which technique of animation is better and why? (4 Marks)

d) How do we simulate deceleration in animation scenes? Why the animation seems to be decelerating if the spacing between frames keeps on decreasing,? Graphically discuss the mathematical function used to produce deceleration in any animation? (3 Marks)

e) Briefly describe following file formats: (5 Marks)
• MPEG
• MP3
• GIF
• JPG
• WAV

The assignment has two parts A and B (Advanced Internet Technologies and Computer Graphics & Multimedia) and each part is for 20 marks. Answer all the questions. Lab record for all the respective sessions (given in the MCSL-054 Lab Manual) for each course carries 20 Marks each. Rest 20 marks are for viva voce. Please go through the guidelines regarding assignments given in the MCA Programme Guide for the format of presentation. If any assumptions made, please state them.

PART-I: MCS-051 (Advanced Internet Technologies)

Q1:
Write a Program using Servlet and JDBC for developing online application for displaying TEE results of MCA Program. A student has to score 50 % in theory, practical and assignment to qualify the paper. Create appropriate databases. (5 Marks)

Q2:
Write a JSP Program, which displays a web page containing the name of the school, program being offered currently, number of students enrolled in each program, new programs to be offered, eligibility criteria for taking admission in each program. (5 Marks)

Q3:
Write a program using JDBC and JSP to display the names and addresses of all those MCA students who are working in Software Development Company. (5 Marks)

Q4:
Write an XML document to represent the TEE grade card of MCA that will contain student name, subjects, assignment marks, total marks, and final status (pass/fail). (5 Marks)

PART-II: MCS-053 (Computer Graphics and Multimedia)

Q1:
Write a program in C or C++ demonstrate Bresenham’s Line generation algorithm? (5 Marks)

Q2:
Using OpenGL write a program to develop a chessboard pattern on the screen? (5 Marks)

Q3:
Using OpenGL develop a scene of rising and setting Sun? (5 Marks)

Q4:
Write a program in C or C++ to produce the sweep representation of a circle and hence produce a cylinder?
(5 Marks)