PROGRAMMING FOR MOBILE AND REMOTE COMPUTERS (PMRC) DECEMBER 2013 INFORMATION TECHNOLOGY SEMESTER 6TH

PROGRAMMING FOR MOBILE AND REMOTE COMPUTERS (PMRC) DECEMBER 2013 INFORMATION TECHNOLOGY SEMESTER 6TH

Con.9234-13                                                                                                        LJ-11668

                                                               (3 Hours)                                          [Total Marks: 100]        

N.B.: (1) Question No.1 is compulsory.
         (2) Attempt any four questions out of remaining six questions.                                                            
1. (a) Differentiate between J2ME, J2EE and J2SE. Explain web container. [10 Marks]    
    (b) Differentiate between List and Choice Group. [5 Marks]
    (c) Create a MIDP application to check and display whether string is palindrome or not
         on mobile screen. [5 Marks]

2. (a) Create a login form using servlet. Login form will contain userid and password and display in
         textbox the output as valid user or not. If user fails to authenticate in three attempts then
         he/she will be not be allowed to re-login further. [10 Marks]
     (b) What are JDBC drivers? Describe each type in short. [10 Marks]

3. (a) Explain EJB centric and Web centric approach of building Web application.[10 Marks]
    (b) Create MIDP application to display warning alert when customer try to perform. Withdraw
          and his/her account balance is less than minimum balance. [10 Marks]

4. (a) Differentiate between configurations and profile. Explain J2ME profile. [10 Marks]
    (b) Explain MIDLet life cycle. State the need of an Obfuscator. [10 Marks]

5. (a) Write a MIDP application to translate a filled curve of height 30, width 50, start angle
         180 degree, arc angle 180 degree from position 0,0 on mobile screen by 45,45 using
         low level API. [10 Marks]
    (b) Write a MIDP application to create calculator to perform operation like add, subtract,
          multiply and divide using list. [10 Marks]

6. (a) What is MIDlet suit? How security is handled in MIDlet suite? [10 Marks]
    (b) Explain event handling and its type in J2ME. [10 Marks]

7. Write a short notes on following:- [20 Marks]
     (i) AJAX
     (ii) JavaMail
    (iii) Customlitem
    (iv) OBEX

Also see Programming for mobile and remote computers question papers for May 2010

DATABASE TECHNOLOGIES (DBT) DECEMBER 2011 SEMESTER 6TH INFORMATION TECHNOLOGY

DATABASE TECHNOLOGIES (DBT) DECEMBER 2011 SEMESTER 6TH INFORMATION TECHNOLOGY

                                         (3 Hours)                                 [Total Marks: 100]                              

1. (a) Explain transient and persistent objects. [5 Marks]
    (b) What are triggers? Illustrate the cases when triggers must not be used. [5 Marks]
    (c) Define and explain the term "Data Warehouse". [5 Marks]
    (d) Explain BCNF with suitable example. [5 Marks]

2. (a) Explain design and implementation issues in mobile database. [10 Marks]
    (b) Explain with proper example nested relation in ORDBMS. [10 Marks]

3. (a) All electronic company have sales department sales consider the dimensions
         namely [10 Marks]
           i) Time    ii) Product    iii) Branch   iv) Location
              with two measures
           i) Dollars-Sold      ii) Unit-Sold
              Design star schema and write a DMQL for the above statement.
     (b) Explain primary horizontal fragmentation is distributed database. [10 Marks]

4. (a) What are the main architectures used for building parallel database? Give 10 advantages
          and disadvantages of each. [10 Marks]
    (b) Explain following concept with example: [10 Marks]
          i) Object identity
          ii) Type constructors.

5. (a) Consider a data warehouse for a hospitals, where there are three dimensions: [10 Marks]
          i) Doctor    ii) Patient    iii) Time
          and two measures
          i) Cont and ii) Charge
         Where charge is the fee that the doctor charges a patient for a visit.
         Using the above example describe the following OLAP operations:
         i) Slice    ii) Dice    iii) Rollup    iv) Drilldown
   (b) Explain security and authorization in SQL. [10 Marks]

6. (a) Explain various extended features of ER diagram such as aggregation, specialization and
         generalization with suitable example. [10 Marks]
    (b) Give a relation with eight attributes [10 Marks]
          Proj_no, Proj_name, Emp_name, Job_class, Charge_hrs, Hrs_billed and Tot_charges
          Normalize it upto 3rd normal form.

7. Write short note on : [20 Marks]
     a) Comparison between OLTP and OLAP.
     b) Two phase commit protocol.
     c) Spatial Database.
     d) Integrity Constraint.

Also see Database technologies question papers for May 2011 

Software Engineering (SE), T.E. (I.T.), Semester 6, May 2010

Software Engineering (SE), T.E. (I.T.), Semester 6, May 2010

Con. 3623-10

AN-4592

(3 Hours)

[Total Marks100]

N.B.: (1) Question no 1 is compulsory.
(2) Attempt any four questions out of remaining six questions.
(3) All questions carry equal marks.
(4) Figure to the right indicates full marks.

1. (a) Discuss the different types of cost estimation model. --- (10 Marks)
(b) Explain in detail the Incremental model with advantage and disadvantages. --- (10 Marks)

2. (a) What are the different tasks of Software Configuration Management (SCM)? Discuss each in brief. --- (10 Marks)
(b) What is quality assurance? Explain various levels of quality assurance in Software Engineering. --- (10 Marks)

3. (a) Explain the fundamental software design concepts. --- (10 Marks)
(b) What are the advantages of Object Oriented Software Engineering? --- (10 Marks)

4. (a) Explain basis path testing and cyclomatic complexity in detail. --- (10 Marks)
(b) Discuss and compare coupling and cohesion in brief. --- (10 Marks)

5. (a) Explain Black Box testing and White Box testing. --- (10 Marks)
(b) What are the various version control activities? Explain. --- (10 Marks)

6. (a) Explain various technics in software requirement analysis. --- (10 Marks)
(b) Explain path testing and cyclomatic complexity in detail. --- (10 Marks)

7. Write notes on any two: - --- (20 Marks)
(a) Empirical Estimation Model.
(b) Re- engineering.
(c) Software Requirements Specification.
(d) Software Project Planning.

Also see Software engineering question papers for December 2010

Software Engineering (SE), T.E. (I.T.), Semester 6, December 2010

Software Engineering (SE), T.E. (I.T.), Semester 6, December 2010

Con. 5808-10

GT-7680

(3 Hours)

[Total Marks100]

N.B.: (1) Question no 1 is compulsory.
(2) Attempt any four questions out of remaining six questions.
(3) Makes for each question are given in brackets at the right hand side.

1. (a) Explain process and project matrics. ---- (5 Marks)
(b) What are the projects best suited for agile methodology and why? --- (5 Marks)
(c) Identify the risk in web based application development. --- (5 Marks)
(d) When do you prototype? What are the outcomes of prototyping? --- (5 marks)

2. (a) Explain the steps in requirement engineering. --- (10 Marks)
(b) What do you understand by process maturity? Mention the activities in CMM level 4 and 5. --- (10 Marks)

3. (a) How are efforts estimated? In which phase of development cycle effort estimation done? --- (10 Marks)
(b) What are the risks associated with delayed projects? How do project managers manage such risks? --- (10 marks)

4. (a) State the five major tasks in SCM. How is version control done? --- (10 Marks)
(b) Describe the activities done during FTR, Configuration Audit and status reporting. --- (10 marks)

5. (a) Explain cohesion and coupling and the purpose of modular design. --- (10 Marks)
(b) Relate the data flow and control flow diagram with an example case study of your choice. --- (10 Marks)

6. (a) What are the advantage of test – driven development? --- (5Marks)
(b) State Software quality factors. --- (5 Marks)
(c) Describe the different techniques in white box testing. --- (10 Marks)

7. Write short notes on any two. --- (20 Marks)
(a) Security engineering
(b) Project scheduling and tracking
(c) System Testing.

Also see Software engineering question papers for May 2011

DATABASE TECHNOLOGIES (DBT) MAY 2011 SEMESTER 6TH INFORMATION TECHNOLOGY

DATABASE TECHNOLOGIES (DBT) MAY 2011 SEMESTER 6TH INFORMATION TECHNOLOGY

                                                     (3 Hours)                                         [Total Marks:100] 

1. (a)	Explain the following terms:-	5
	(i) Inheritance, (ii) Specialization.
(b)	Explain Replication in Distributed Database.	5
(c)	Compare Data Warehouse and Data Mart.	5
(d)	Explain BCNF with suitable example.	5
2. (a)	Explain concept of referential integrity with an example.	10
(b)	Explain with proper example nested relation in ORDBMS.	10
3. (a)	Explain security and authorization in SQL.	10
(b)	Explain design and implementation issues in mobile databases.	10
4. (a)	Describe the event-condition-action model for triggers. Why triggers are	10
	required ?
(b)	Suppose, that we decompose the schema R+ (A, B, C, D, E) into	10
	(A, B, C)
	(A, D, E)
	Show that this decomposition is a loss less-join decomposition if the following
	set F of functional dependencies holds :
	A -> BC
	CD -> E
	B -> D
	E -> A
5. (a)	What are the main architectures used for building parallel databases ? Give	10
	advantages and disadvantages of each.
(b)	Explain the following concepts with examples :	10
	(i) Object Identity
	(ii) Type Constructor.
6. (a)	All electronics company have sales department sales consider three dimensions	10
	namely :-
	(i) Time (ii) Product (iii) Store.
	The schema contains a central fact table sales with two measures :-
	(i) dollars-sold and (ii) units-sold.
	Design star schema and snowflake schema.
(b)	Define data warehouse. Explain the architecture of data warehouses with	10
	suitable block diagram.
7.	Write short notes on (any two) :-	20
	(a) Spatial Databases
	(b) OLAP Servers
	(c) Vertical and Horizontal fragmentation in distributed database

Also see Database technologies question papers for May 2012

DATABASE TECHNOLOGIES (DBT) MAY 2012 SEMESTER 6TH INFORMATION TECHNOLOGY

DATABASE TECHNOLOGIES (DBT) MAY 2012 SEMESTER 6TH INFORMATION TECHNOLOGY

Con. 3782-12.                                                                                                       GN-7337
  
                                                    (3 Hours)                                                [Total Marks : 100]

N.B. (1) Question No.1 is compulsory.
        (2) Answer any four out of remaining questions.
        (3) Assume any suitable data if necessary and clearly state it.

1. (a) Explain object Identity and Type constructors. [5 Marks]
    (b) Explain the term Data Transparency. [5 Marks]
    (c) Explain two phase commit protocol. [5 Marks]
    (d) Differentiate between Data warehouse and Data base system. [5 Marks]

2. (a) Database is being constructed to keep track of the teams and games of a sports league.
         A team has a number of players, not all of whom participate in each game. It is desired
         to keep track of the players participating in each game for each team, the position they
         played in that game, and the result of the game.
         i) Design an EER schema, stating any assumptions you make. [7 Marks]
         ii) Show mapping of EER schema to relational schema. [5 Marks]
   
     (b) What are multidimensional database? How do this store data? [8 Marks]

3. (a) Suppose a company would like to design a data warehouse to facilitate the analysis of
         moving  vehicles in an online analytical processing manner. The company registers huge
         amounts of auto movement data int he format of (Auto ID, location, speed,time). Each
         Auto ID represents a vehicle associated with information, such as vehicle category, driver
         category, etc., and each location may be associated with a street in a city. Assume that a
         street map is available for the city.
         Design a data warehouse to facilitate effective online analytical processing and write DMQL
         for above schema. [10 Marks]
    (b) Explain with proper example nested relation in ORDBMS. [10 Marks]

4. (a) Explain in details the major steps in the ETL process. [10 Marks]
    (b) Explain design and implementation issues in mobile database. [10 Marks]

5. (a) Consider the following global schema :
                BOOKS (Book#, primary_author, Topic, Total_Stock, $price)
                BOOKSTORE (Store#, City, State, Zip, Inventory_value)
                STOCK (Store#, Book#, Qty)
        i) Give an example of two simple predicates that would be meaningful for the BOOKSTORE
           relation for horizontal partitioning.
        ii) How would a horizontal derived partitioning of STOCK be defined based on the partitioning
            of BOOKSTORE.
       iii) Show predicates by which BOOKS may be horizontally partitioned by topic.
       iv) Show how the STOCK may be further partitioned from the partitions in (ii) by adding
            the predicate in. [10 Marks]
   (b) What are the main architectures used for building parallel database? Give advantages
          and disadvantages of each. [10 Marks]

6. (a) Explain in brief the architecture of data warehouse. [10 Marks]
    (b) Consider relation R (PQRSTU) with following functional dependencies.
           P -> Q
           ST -> PR
           S -> U
           State R in which normal form? Decompose it to BCNF. [10 Marks]

7. Write short notes on : [20 Marks]
     a) Referential integrity.
     b) Authorization in SQL.
     c) Spatial Database.
     d) Temporal Database

Also see Database technologies question papers for December 2012 

    

DATABASE TECHNOLOGIES (DBT) DECEMBER 2012 SEMESTER 6TH INFORMATION TECHNOLOGY

DATABASE TECHNOLOGIES (DBT) DECEMBER 2012 SEMESTER 6TH INFORMATION TECHNOLOGY

Con.8283-12.                                                                                                   KR-8873

                                                                 (3 Hours)                               [Total Marks :100]

N.B.: (1) Question No.1 is compulsory.
         (2) Attempt any four questions from remaining six questions.
         (3) Assume any suitable data if necessary.

1. (a) Explain degree of freedom analysis with example. [10 Marks]
    (b) Explain P and ID with suitable example. [10 Marks]

2. (a) What data if required to calculate the dew point of a binary mixture? Give an algorithm to
         calculate the dew point of the binary mixture from the above data for ethane and propane
         mixture. [10 Marks] 
     (b) Define Dew Point, Bubble point, Relative Volatility and explain physical property database
          for gases. [10 Marks]

3. (a) Explain the design procedure for dubble pipe exchanges using bore or longitudinal
         fins. [10 Marks]
    (b) Explain the Nutter method for calculating tower diameters where valve traus are
         used. [10 Marks]

4. (a) Give equation for calculation of pressure drop in shell and tube heat exchanger and explain
          all the terms. [10 Marks]
    (b) What is meant by basic and detailed design of heat exchanger. [10 Marks]

5. (a) Discuss the structure, application and scope of CAD. [10 Marks]
    (b) Explain Chen equation to determine friction factor. [10 Marks]

6. Explain the process design of horizontal and vertical storage vessel. [20 Marks]

7. Write short notes on:- [20 Marks]
    (a) Estimation of Heat transfer coefficient in transaction region.
    (b) Computer flow sheeting.
    (c) Pipe fitting.
    (d) Wilson equation.    

Also see Database technologies question papers for December 2010 

DATABASE TECHNOLOGIES (DBT) DECEMBER 2010 SEMESTER 6TH INFORMATION TECHNOLOGY

 DATABASE TECHNOLOGIES (DBT) DECEMBER 2010 SEMESTER 6TH INFORMATION TECHNOLOGY

Con. 5796-10.                        (REVISED COURSE)                                          GT-7689
                                                      (3 Hours)                                           [Total Marks:100]

N.B.: (1) Question No. 1 is compulsory.
         (2) Attempt any four questions out of remaining six questions.

1. (a) Explain the following terms:- [5 Marks]
            (i) Data Warehouse  (ii) Inheritance
    (b) Explain 3NF with suitable example. [5 Marks]
    (c) Explain Data fragmentation in distributed Database [5 Marks]
    (d) Explain Transient and persistent objects. [5 Marks]

2. (a) What are triggers ? Give an example. Illustrate the cases when triggers must         
         not be used. [10 Marks]
    (b) Explain design and implementation issues in mobile databases. [10 Marks]

3. (a) Explain various extended features of ER diagram such as aggregation, 
         specialization and generalization with suitable example. [10 Marks]
    (b) Find out the data transfer cost of distributed query processing for following queries.
         "For each employee, retrive the employee name and name of the department
         for which employee works." [10 Marks]

      Site 1
     Employee

   

   

   
       10,000 records, each record is 100 bytes long.
       SSN field is a bytes, Fname is 15 bytes
       DNO field is 4 bytes, Lname is 15 bytes.

      Site 2
     Department

      

    
       

        Dname  Dnumber  Mgrssn  Mgrstartdate
        100 recods, each record is 35 bytes long.       
        Dnumber field is 4 bytes, Dname field is 10 bytes
        Mgrssn field is 9 bytes.
        Query is submitted to result site 3.
        Consider different strategies for executing this query and find which strategy is
        best using natural join and semijoin.    

4. (a) Consider relation R (PQRSTU) with following dependencies. [10 Marks] 

 

        
         State R is in which normal form ? Decompose it to BCNF. Show step by procedure.
    (b) Explain object identifier and object structure with example. [10 Marks]

5. (a) All electronics company have sales debt. Sales consider four Dimensions namely
         time, item , branch and location. The schema contain a central fact table sales
         with two measures dollar_sold and unit sold.
         Designer star schema and snowflake schema. [10 Marks]
    (b) Consider a data warehouse for a hospital, where there are three dimensions.
         (i) Doctor  (2) Patient and (3) Time and two measures : (i) Count and (ii) Charge
         where charge is the fee that the doctor charges a patient for a visit. using the
         above example describe the following OLAP operations.
         (1) Slice (2) Dice (3) Rollup (4) DrillDown. [10 Marks]

6. (a) Explain type of constraints with an example. [10 Marks]
    (b) Explain security and Authorization in SQL. [10 Marks]

7.  Write short notes on (any four) :-
          (a) Comparison of RDBMS, OODBMS, ORDBMS [20 Marks]
          (b) SQL 3 standard
          (c) Comparison between OLTP and OLAP
          (d) Two phase committ protocol
          (e) Temporal Databases.

Also see Database technologies question papers for May 2010 

Software Engineering (SE), T.E. (I.T.), Semester 6, May 2011

Software Engineering (SE), T.E. (I.T.), Semester 6, May 2011

(3 Hours)

[Total Marks:100]

N.B.: (1) Question no 1 is compulsory.
(2) Attempt any four questions out of remaining six questions.
(3) All questions carry equal marks.

1. (a) Explain Spiral Model. Compare and differentiate it with the sequential model. --- (10 Marks)
(b) Explain CMM along with the levels and activities within each level. --- (10 Marks)

2. (a) List down and explain software design principles. --- (10 Marks)
(b) List down different effort estimation techniques. Explain COCOMO in detail. --- (10 Marks)

3. (a) What do you understand by Quality Assurance? Explain the levels of quality assurance. --- (10 Marks)
(b) Explain risk analysis and management in detail. --- (10 Marks)

4. (a) Explain change control in detail along with software configuration items and baseline. --- (10 Marks)

(b) Explain requirement engineering. --- (10 Marks)

5. (a) Explain Basis path testing and cyclomatic complexity in detail. --- (10 Marks)

(b) What do you under stand by metrics? List down and explain process and project metrics. --- (10 Marks)

6. (a) List down and explain the activities of project scheduling and tracking. --- (10 marks)
(b) Explain agile methodology using SCRUM. --- (10 Marks)

7. Write short notes on any four: - --- (20 Marks)
(a) Re-engineering
(b) Software Project Planning
(c) Version Control
(d) Security Testing
(e) Software Design Document.

Also see Software engineering question papers for December 2011

Software Engineering (SE), T.E. (I.T.), Semester 6, December 2011

Software Engineering (SE), T.E. (I.T.), Semester 6, December 2011

(3 Hours)

[Total Marks:100]

N.B.: (1) Question no 1 is compulsory.
(2) Attempt any four questions out of remaining six questions.
(3) All questions carry equal marks.

1. (a) Enlist and explain the steps require to perform cost estimation using COCOMO model? --- (10 Marks)
(b) Give a Software Requirement Specification (SRS) for developing a software for payroll Management System. --- (10 marks)

2. (a) Explain Software Configuration Management and Change Control Management in detail. --- (10 Marks)
(b) Explain CMM along with the level and activities with each level. --- (10 Marks)

3. (a) Explain how Gantt – chart can be used for planning and controlling small project with example? What are the limitations of Gantt- chart? --- (10 Marks)
(b) Explain risk identification, risk projection, RMMM plan in detail. --- (10 Marks)

4. (a) What do you understand by Quality Assurance? Explain the levels of Quality Assurance. --- (10 Marks)
(b) Explain Basic path testing and Cyclomatic complexity in detail. --- (10 Marks)

5. (a) Compare conventional approach and object oriented approach to software development? What are the advantages of OOAD? --- (10 Marks)
(b) What is feasible study? Explain its types, contents and purpose. --- (10 Marks)

6. (a) Explain how project scheduling and tracking is done for a software development project. --- (10 Marks)
(b) Describe data flow and control flow diagram with suitable example. --- (10 Marks)

7. Distinguish between : --- (20 Marks)
(a) White Box and Black Box Testing
(b) Coupling and Cohesion
(c) RAD and Spiral Model
(d) FP Based and LCC based Cost Estimation.

Also see Software engineering question papers for May 2012

DATABASE TECHNOLOGIES (DBT) MAY 2010 SEMESTER 6TH INFORMATION TECHNOLOGY

DATABASE TECHNOLOGIES (DBT) MAY 2010 SEMESTER 6TH INFORMATION TECHNOLOGY

Con. 3503-10.                            (REVISED COURSE)                                       AN-4603
                                                          (3 Hours)                                        [Total Marks:100]


N.B.: (1) Questions No. 1 is compulsory.
         (2) Solve any four questions out of remaining six.
         (3) Assume any suitable data wherever required but justify the same.

Q. 1   Consider the following information about a Life Insurance Corporation:
          The Netwark divisional office of the Life Insurance Corporation of America
           Keeps all the necessary information about the policy holders is a database. A
           policy holder pays a premium untill the maturity of the policy of his death. at
           which time sum assured and bonus is paid to the nominee. The premium to be
           paid is worked out based on the age of the person proposed and the term of
           the policy. Network division keeps the following information about each policy
           holder: social security number, name, address, date of birth , description of the
           terms of the policy and the annual premium. The corporation has divided its
           Netwark division into 15 zones for its convenience. Each zone has it manager.
           Every zone has a number of agents allotted, typically ranging from 10 to 20.
           Every agent must procure a minimum of 10 customers.
      (a) Draw an E-R diagram for the Corporation database (state any assumption you
           believe you need to make in order to develop a complete diagram). Identify the
           key attribute (attributes) for each entity and the cardinality of each entity
           relationship. [10 Marks]
      (b) Write SQL statement to create corresponding relation and the capture as of the 
           constraints as possible. if you cannot capture some constraints, explain why? [10 Marks]

Q.2 (a) Explain ACID properties in detail? [10 Marks]
      (b) Explain 3NF and 4NF with suitable example? [10 Marks]

Q.3 (a) What is deadlock? Explain the different method to prevent and detected it? [10 Marks]
      (b) What is difference persistent and transient object ? How the persistence handle
           typical OODBMS? [10 Marks]

Q.4 (a) How is a vertical and a horizontal partitioning of a relation is specified? How
           can a relation be put back together from a complete vertical and a complete
           horizontal partitioning? [10 Marks]
      (b) Explain relational algebra operators in details ? [10 Marks]

Q.5 (a) Explain the reference integrity with example? [10 Marks]
      (b) Explain concurrency control in DBMS with help ant two protocols? [10 Marks]

Q.6 (a) Explain database system structure in detail? [10 Marks]
      (b) Explain the architecture of datawarehouse in detail. [10 Marks]

Q.7     Short notes on (any four) [20 Marks]
               a) Comparison of ODBMS ORDBMS
               b) OLAP
               c) Temporal database
               d) Mobile database
               e) Trigger and Assertion. 

Also see Database technologies question papers for May 2013 

DATABASE TECHNOLOGIES (DBT) MAY 2013 SEMESTER 6TH INFORMATION TECHNOLOGY

DATABASE TECHNOLOGIES (DBT) MAY 2013 SEMESTER 6TH INFORMATION TECHNOLOGY

Con. 7342-13.                                                                                               GS-1006

                                                       (3 Hours)                                              [Total Marks: 100]

N.B.: (1) Question No.1 is compulsory.

         (2) Attempt any four questions of remaining six questions.

         (3) Assume suitable data if required.

         (4) Figures at right indicate full marks

1. (a) Explain object identity and type constructor. [5 Marks]

    (b) Suppose that we decompose the Schema R = { A, B, C, D, E } into: [5 Marks]

                     R1 = { A, B, C } and 

                     R2 = { A, D, E } 

         Show that the decomposition is lossless join decomposition if the following set 

         F of functional dependencies holds.

                     A -> BC

                     C -> E

                     B -> D

                     E -> A

    (c) Explain factless fact table with example. [5 Marks]

    (d) Explain BCNF with suitable example. [5 Marks]

2. (a) Describe the event-condition-action model for triggers. Why triggers are required? [10 Marks]

    (b) Consider a dependency diagram of  Relation R. [10 Marks]

          (i) The relation R in which normal form? Justify your answer.

          (ii) Normalize relation R upto third normal form 

3. (a) Explain design and implementation issues in Mobile Database. [10 Marks]

    (b) Explain in detail the major steps in the ETL process. [10 Marks]

4. (a) Explain the concept of referential integrity with suitable example. [10 Marks]

    (b) Consider an employee table with a multivalued dependents attribute employee. [10 Marks]

          i) Define employee table using nasted relation  in ORDBMS or OODBMS. 

         ii) Comment on the normalization rule violation if we define nested relation .

5. (a) Explain the architecture of Data warehouse in detail. [10 Marks]

    (b) Given the relation R with attributes A to J and the following set of funtional   

          dependencies:- [10 Marks]

           FD = {{A, B}     ->    {c},

                      {B, D}     ->    {E, F},

                      {A, D}     ->    {G, H},

                      {A}          ->    {I},

                      {H}          ->    {J}}

      (i) What is the key of relation R.

      (ii) Decompose Relation R into 2NF and 3NF.

6. (a) Write short note on temporal database. [10 Marks]

    (b) Consider following Schema and PROJECT relation instance. [10 Marks]

        Pay

Project

    (i) Apply primary horizontal fragmentation (PHF) to PROJECT realtion.

    (ii) Clearly state the different minterm predicates. 

    (iii) State and derive the implcation of  minterm predicates.

7. (a) Explain authorization in SQL. [5 Marks]

    (b) Compose primary key and object identity. [5 Marks]

    (c) Compass Data warehouse and Data marts. [5 Marks]

    (d) Write short note on parallel Database. [5 Marks] 

Also see Database technologies question papers for December 2011 

Software Engineering (SE), T.E. (I.T.), Semester 6, May 2012

Software Engineering (SE), T.E. (I.T.), Semester 6, May 2012

Con. 4045-12.

GN-7328

(3 Hours)

[Total Marks: 100]

N.B.: (1) Question no 1 is compulsory.
(2) Attempt any four questions out of remaining six questions.
(3) All questions carry equal marks.
(4) Assume suitable data if necessary.

1. A system is designed for evaluation of various tenders received by an organization. It had various steps like data entry of bids, tabulation of bids, preparation of lowest bid document , entry of actual orders with actual prices negotiated, preparation of a ‘deviation document’ that will record all differences between lowest bid and actual orders. The entire system was built under text based UNIX and is being proposed to be changed to a GUI and windows based system. Draw data flow diagram (level 0, 1, 2, 3) and control flow diagram describing all details. --- (20 Marks)

2. (a) Explain Software Configuration Management in detail. --- (10 Marks)
(b) Compare and Contrast Coupling and Cohesion. --- (10 Marks)

3. (a) Explain risk identification, risk projection, RMMM plan in detail. --- (10 Marks)

(b) Explain how Gantt – chart can be used for planning and controlling small project with suitable example? What are the limitations of Gantt – chart? --- (10 Marks)

4. (a) Explain various steps involved in SRS for case study in question no. one. --- (10 Marks)
(b) What is feasibility study? Explain its type, contents and purpose. --- (10 Marks)

5. Explain the difference between: --- (20 Marks)
I. White Box and Black Box Testing.
II. Component Based Model and Spiral Model.

6. (a) Describe project scheduling and tracking with any suitable example. --- (10 Marks)
(b) Explain in detail software project plan with case study in question no. one. --- (10 Marks)

7. Write short notes on any two : - --- (20 Marks)
(a) CMM and Key Process Areas
(b) Security engineering
(c) Reengineering
(d) Design Concepts and Principles.

Also see Software engineering question papers for December 2012

Software Engineering (SE), T.E. (I.T.), Semester 6, December 2012

Software Engineering (SE), T.E. (I.T.), Semester 6, December 2012

Con. 8192-12.

KR-9008

(3 Hours)

[Total Marks: 100]

N.B. : (1) Question no 1 is compulsory.
(2) Attempt any four questions out of remaining six questions.

1. (a) What are the different tasks of Software Configuration Management (SCM)? Discuss each in brief. --- (10 Marks)
(b) What do you understand by Quality Assurance? Explain the Levels of Quality Assurance. --- (10 Marks)

2. (a) What is Feasibility Study? Explain its type, contents and purpose. --- (10 Marks)
(b) What do you understand by metrics? List and explain Process and Project metrics. --- (10 Marks)

3. (a) Compare and contrast coupling and cohesion. --- (10 Marks)
(b) Explain the user interface Design Process. --- (10 Marks)

4. (a) Explain the difference between White Box and Black Box testing. --- (10 Marks)
(b) What are the advantages of Object Oriented Software Engineering? --- (10 Marks)

5. (a) Give a Software Requirement Specification (SRS) for developing software for Hospital management System. --- (10 Marks)
(b) Describe Project Scheduling and tracking with any suitable example. --- (10 Marks)

6. (a) Explain agile methodology using SCROM. --- (10 Marks)
(b) Explain requirement engineering. --- (10 Marks)

7. Write short notes on any four of the following: --- (20 Marks)
(a) Software Tools for Analysis.
(b) Re- engineering .
(c) Architectural Styles.
(d) Software Project Planning.
(e) RAD and Spiral Models.

Also see Software engineering question papers for December 2013

CONVERGENCE OF TECHNOLOGIES AND NETWORKING IN COMMUNICATION (CTNC) MAY 2011 SEMESTER 5TH INFORMATION TECHNOLOGY

CONVERGENCE OF TECHNOLOGIES AND NETWORKING IN COMMUNICATION (CTNC) MAY 2011 SEMESTER 5TH INFORMATION TECHNOLOGY

Con.3463-11                                                                                                     RK-2172

                                                          (3 Hours)                                      [Total Marks : 100] 

N.B.: (1) Question No.1 is compulsory.
         (2) Answer any four questions from remaining.
         (3) Do not write any thing on question papers except seat no.
         (4) Draw the well labeled diagram.
         (5) Each question carries equal maximum marks 20.

1. (a) Draw and explain different Network Topology. [6 Marks]
    (b) Explain voice integration technique. [6 Marks]
    (c) Explain with block diagram Generation and Reception of BPSK. [8 Marks]

2. (a) What is BFSK? Draw and explain BFSK Tr and co-herent receiver. Comment on
          B-W Requirement. [10 Marks]
    (b) Prove that probability of error of QPSK is :-

                    
           Where Eb is bit energy.

3. (a) Explain Traffic Management in ATM. [10 Marks]
    (b) Draw and explain CDMA in UMTS Network. [10 Marks]

4. (a) Explain 3G and 4G wireless communication with advantages. [10 Marks]
    (b) Explain the term Network Architecture with suitable example. [10 Marks]

5. (a) Draw and explain architecture of IMS and UTMS. [10 Marks]
    (b) Derive the equation for BPSK spectrum and draw it, Also plot the geometric representation
         of BPSK signal. [10 Marks]

6. (a) What is data encryption technique and explain Transposition Ciphers in details. [10 Marks]
    (b) Differentiate between ASK, PSK and FSK. Write advantages of each. [10 Marks]

7. Write short notes on (any three):- [20 Marks]
     (a) Ad-hoc Network
     (b) Firewalls
     (c) Digital Signature and Certificate
     (d) Traffic Policing

Also see Convergence of technologies and networking in communication question papers for MAY 2012 

CONVERGENCE OF TECHNOLOGIES AND NETWORKING IN COMMUNICATION (CTNC) MAY 2012 SEMESTER 5TH INFORMATION TECHNOLOGY

CONVERGENCE OF TECHNOLOGIES AND NETWORKING IN COMMUNICATION (CTNC) MAY 2012 SEMESTER 5TH INFORMATION TECHNOLOGY

Con.4415-12                                                                                                    GN-8210
                                    
                                                                (3 Hours)                                 [Total Marks: 100]

N.B.: (1) Question No.1 is compulsory.
          (2) Attempt any four questions from remaining.
          (3) Each question carries equal maximum marks.

1. (a) Discuss the different types stations defined by HDLC. How a communication
         channel in HDLC that is used by a station can be configured. [5 Marks]  
    (b) Describe the characteristics of 3G system. [5 Marks]
    (c) Compare different multiplexing techniques. [5 Marks]
    (d) Compare SDMA, FDMA, TDMA and CDMA. [5 Marks]

2. (a) Explain classification of signalling techniques. [10 Marks]
    (b) Explain 3G UMTS network. [10 Marks]

3. (a) Explain traffic management in ATM. Also explain ATM traffic policing. [10 Marks]
    (b) Classify different switching architectures. Discuss one of them. [10 Marks]

4. (a) Describe in brief BPSK modulator and demodulator. Also calculate probability of
          error. [10 Marks] 
    (b) Explain Handoff algorithm. [10 Marks]

5. (a) What are different types of traffic? Explain leaky bucket algorithm in brief. [10 Marks]
    (b) Explain different traffic descriptors used in ATM. [10 Marks]

6. (a) Explain ISDN protocol stack in detail with neat sketches. [10 Marks]
    (b) What do you mean by ancryption? Explain symmetric key and asymmetric key method
          in detail. [10 Marks]

7. Write short notes on any two :- [20 Marks]
          (a) TMN
          (b) LLC Sublayer 
          (c) Sprwading code and scrambling process.

Also see Convegence of technologies and networking in communication question papers for December 2010

CONVERGENCE OF TECHNOLOGIES AND NETWORKING IN COMMUNICATION (CTNC) December 2010 SEMESTER 5TH INFORMATION TECHNOLOGY

 CONVERGENCE OF TECHNOLOGIES AND NETWORKING IN COMMUNICATION (CTNC) December 2010 SEMESTER 5TH INFORMATION TECHNOLOGY

Con.5805-10.                                        (REVISED COURSE)                           GT-6789

                                                                        (3 Hours)                            [Total Marks: 100]

N.B.: (1) Question No.1 is compulsory, solve any four questions from from questions No.2 to 
                question No.7
          (2) Mention your answers with neat sketches and examples wherever necessary.
          (3) Assume any data and mention the name while attempting the questions.

1. Attempt the following :-
    (a) Explain characteristics of connection oriented and connectionless service, list various examples
         for both the services. [5 Marks]
    (b) Explain ISO-OSI layered architecture in brief. [5 Marks]
    (c) Compare LAN-WAN and MAN. [5 Marks]
    (d) Explain different Network Topologies with neat sketches [5 Marks]

2. (a) Explain ASK FSK and PSK in detail. [10 Marks]
    (b) Explain different transmission media in detail with neat sketches and it's Technical
         characteristics. [10 Marks]

3. (a) What are various functions of Data Link Layer? Explain with suitable examples. [10 Marks]
    (b) What do you mean by bridge? Explain bridging techniques in detail. [10 Marks]

4. (a) What are various design requirements for Routing protocol? Explain Link State
          Routing. [10 Marks]
    (b) What do you mean by Logical Address and Physical Address? Explain network address
          in detail. [10 Marks]

5. (a) What are different types of Traffic? Explain leaky bucket algorithm in brief. [10 Marks]
    (b) What do you mean by Encryption? Explain symmetric key and Asymmetric key. [10 Marks]

6. (a) Explain ISOI protocol stack in detail with neat sketch. [10 Marks]
    (b) Explain classification of signalling techniques. [10 Marks]

7. Write short note on any four of the following :- [20 Marks]
     (a) Traffic Management in ATM
     (b) TMN
     (c) SNMP
     (d) 3G UMTS Network
     (e) Digital Signatures and Certificates
     (f) Data Multiplexing

Also see Convergence of technologies and networking in communication question papers for May 2010

Software Engineering (SE), T.E. (I.T.), Semester 6, December 2013

Software Engineering (SE), T.E. (I.T.), Semester 6, December 2013

Con. 8532-13.

LJ-11586

(3 Hours)

[Total Marks: 100]

N.B. : (1) Question no 1 is compulsory.
(2) Attempt any four questions out of remaining six questions.
(3) All questions carry equal weightage.
(4) Figures indicate right marks.
(5) Assume data wherever necessary.

1. (a) Discuss incremental process model and evolutionary process model with reference to the suitability of the project. --- (10 Marks)
(b) Explain how size oriented metrics differs from function oriented metrics. Give example which each are recommended. --- (10 Marks)

2. (a) Give software requirement specification (SRS) for developing a software for pay roll management system. --- (10 marks)
(b) Workout data flow diagram and control flow diagram in detail respect to payroll management system. --- (10 marks)

3. (a) Explain the various levels of quality assurance in software Engineering with reference to different parameters of quality. --- (10 Marks)
(b) What is configuration audit? How change in managed in web applications. --- (10 marks)

4. (a) Discuss and compare TDD (Test Driven Development) and DDT (Design Driven Testing). --- (10 Marks)
(b) What activities are carried out during FTR and status reporting and why? --- (10 marks)

5. (a) List down and explain the activities carried out during scheduling and tracking. --- (10 Marks)
(b) Discuss the cases where the change control and version control are required with its purpose. --- (10 Marks)

6. (a) Compare the conventional approach and object oriented approach to software development with suitability. --- (10 Marks)
(b) What is requirement of risk analysis? What are the possible risks that may affect the scheduling? How you can overcome the same? --- (10 Marks)

7. Write short note on:- --- (20 marks)
(a) SCRUM and CRYSTAL
(b) Design concepts and principles
(c) Coupling and cohesion
(d) Gantt chart.

Also see Software engineering question papers for May 2010

CONVERGENCE OF TECHNOLOGIES AND NETWORKING IN COMMUNICATION (CTNC) MAY 2010 SEMESTER 5TH INFORMATION TECHNOLOGY

CONVERGENCE OF TECHNOLOGIES AND NETWORKING IN COMMUNICATION (CTNC) MAY 2010 SEMESTER 5TH INFORMATION TECHNOLOGY

Con.3472-10.                              (REVISED COURSE)                                    AN-4312
                       
                                                           (3 Hours)                                         [Total Marks : 100]

N.B.(1) Question No.1 is compulsory
        (2) Attempt any four questions of the remaining six.
        (3) Figures to the right indicate full marks.
        (4) Answers to questions should be grouped and written together.

Q.1 (a) Describe in brief Binary Phase Shift Keying modulator and demodulator? Also calculate
             probability of error for BPSK?  [15 Marks]
       (b) Compare the different evolution of second, third, fourth generation of wireless
             communication system. [5 Marks] 

Q.2 (a) Explain the digital signature. Also explain firewall used for security purpose. [10 Marks]
       (b) Explain traffic management in ATM. Also explain ATM traffic policing. [10 Marks]

Q.3 (a) What is convergence? Also explain IEEE.802.11 standard? [7 Marks]
       (b) Explain Multiple Access Techniques TDMA, FDMA, SDMA and SSMA. Also explain
            Packet Radio Multiple Access (slotted ALOHA/pure ALOHA). [13 Marks]

Q.4 (a) Compare the probability of error for an optimum filter. What is matched filter? [10 Marks]
       (b) Explain basic concept of cellular system. How frequency reused method is
             implemented? [10 Marks]

Q.5 (a) How channel capacity is improved by sell splitting and cell sectoring? [10 Marks]
       (b) How Tiger Hash function used for encryption? Compare block ciphers with
             stream ciphers. [10 Marks]

Q.6 (a) Explain General GSM architecture. Also explain different GSM channel used. [10 Marks]
       (b) Explain high level data link (HDCL) prptocol. Also explain the frame structure
             in HDCL. [10 Marks]

Q.7 Write short notes on (any four) : [20 Marks
         (a) Bluetooth
         (b) Binary frequency keying
         (c) Handoff Algorithm
         (d) Telecommunicaton Management Network (TMN)
         (e) ISDN

Also see Convergence of technologies and networking in communication question papers for December 2009

CONVERGENCE OF TECHNOLOGIES AND NETWORKING IN COMMUNICATION (CTNC) DECEMBER 2009 SEMESTER 5TH INFORMATION TECHNOLOGY

CONVERGENCE OF TECHNOLOGIES AND NETWORKING IN COMMUNICATION (CTNC) DECEMBER 2009 SEMESTER 5TH INFORMATION TECHNOLOGY

Con.5480-09.                          (REVISED COURSE)                                 SP-8639

                                                      (3 Hours)                                       [Total Marks : 100]


N.B.: (1) Question No.1 is compulsory.
         (2) Attempt any four questions of the remaining six questions.
         (3) Figures to the right indicate full marks.
         (4) Answer to questions should be grouped and written together.
         (5) Use blue/black ink pen to write answers. 

1. (a) Describe in brief each modulation method. [10 Marks]
    (b) Compare the different data multiplexing techniques. [10 Marks]

2. (a) Explain convergence of voice, video and image into one flexible network. [10 Marks]
    (b) How convergence of these network application (voice, video and image) are implemented
          in the ATM network. [10 Marks]

3. (a) State the differences between synchronous and asynchronous communication. [10 Marks]
    (b) Describe a data communication model compare 2G, 3G and 4G wireless
         communication systems. [10 Marks]

4. (a) What is traffic management? Explain the different elements of traffic management. [10 Marks]
    (b) Explain the TMN(Telecommunication Management Network) with appropriate
         diagrams. [10 Marks]

5. (a) Explain any handoff algorithm for wireless technology. [7 Marks]
    (b) Why infra-red technology is used in wireless CAN? Describe in brief about the
           bluetooth technology. [13 Marks]
 
6. (a) How key management for symmetric encryption techniques is done using
          kerbemos? [10 Marks]
    (b) How is hash function advantageous over encryption for data integration? Explain
          Message Digit 5(MD5) algorithm for hash function. [10 Marks]  

7. Write short notes on any two of the following  :- [20 Marks]
      (a) FDMA/TDMA in GSM networks
      (b) Digital signatures and certificates
      (c) ISDN
      (d) Adhoc wireless network

Also see Convergence of technologies and networking in communication question papers for December 2011

CONVERGENCE OF TECHNOLOGIES AND NETWORKING IN COMMUNICATION (CTNC) DECEMBER 2011 SEMESTER 5TH INFORMATION TECHNOLOGY

CONVERGENCE OF TECHNOLOGIES AND NETWORKING IN COMMUNICATION (CTNC) DECEMBER 2011 SEMESTER 5TH INFORMATION TECHNOLOGY

                                           (3 Hours)                    [Total Marks:- 100]

1. Attempt the following :- [20 Marks]

    (a) What are the different between ASK, FSK, PSK digital modulation technology?

    (b) Why M-ary PSK schemes give a higher data rate? What are practical problems in 

          increasing the phases beyond a limit? 

     (c) Explain ISO-OSI layered architecture in brief.

     (d) What is the difference between virtual circuit switching, circuit switching and packet
           switching?

     (e) What is the importance of logical layers in Telecommunication Management Network(TMN)?

2. (a) Explain deferentially encoded phase shift keying (DEPSK) in detail. [10 Marks]

    (b) What is mean by Handoff? Explain how proper Handoff take place with some Handoff 

          algorithms? [10 Marks]

3. (a) Explain in detail block diagram of analog and digital communication system. [10 Marks]

    (b) What is basic difference between transparent bridging used in Multi-bridging in 

          Ethernet LANs? [10 Marks]

4. (a) Explain Code Division Multiple Acess Techniques. How spreading and scrambling take 

         place also explain Direct Sequence Spread Spectrum? [10 Marks]

    (b) Explain the merits and demerits of input buffering, output buffering and shared 

         buffering. [10 Marks]

5. (a) Explain ISDN architecture and how call is established as well as released in ISDN? 

         Also describe the protocol stack for ISDN? [10 Marks]

    (b) What is difference between traffic shaping and traffic policing? How can shaping avoid 

          policing? Explain with a simple example. [10 Marks]

6. (a) What is need for network management? Differentiate between the TMN functional Architecture 

          and TMN physical architecture. [10 Marks]

    (b) Explain in details digital signatures and certificates. [10 Marks]

7. Write short notes on any four of the following :- [20 Marks]

        (a) Kerberos

        (b) 3G UMTS network

        (c) Data multiplexing 

        (d) Bluetooth Technology 

        (e) Error correction and Detection Methods at data link layer

        (f) RSA Algorithm

Also see Convergence of technologies and networking in communication question papers for December 2012

CONVERGENCE OF TECHNOLOGIES AND NETWORKING IN COMMUNICATION (CTNC) DECEMBER 2012 SEMESTER 5TH INFORMATION TECHNOLOGY

CONVERGENCE OF TECHNOLOGIES AND NETWORKING IN COMMUNICATION (CTNC) DECEMBER 2012 SEMESTER 5TH INFORMATION TECHNOLOGY

 

Con. 9857-12                                                                                                     KR-5279

                                                                  (3 Hours)                              [Total Marks :- 100]

N.B.: (1)  Question No.1 is compulsory.
         (2) Answer any four questions from remaining.
         (3) Each question carries equal maximum marks.

1. (a) Describe the characteristics of 3G system. [5 Marks]
    (b) List the protocol/technologies along with the topology and supported area network. [5 Marks]
    (c) List the function performed by LLC sublayer. Draw its PDU format. [5 Marks]
    (d) Compare different multiplexing techniques. [5 Marks]

2. (a) Classify different switching architectures. Discuss one of them. [10 Marks]
    (b) Explain ISDN protocol stack in detail with neat sketch. [10 Marks]

3. (a) Explain ASK, FSK and PSK in detail. [10 Marks]
    (b) Descibe FDMA/TDMA and GSM networks. [10 Marks]

4. (a) What is traffic management? Explain the different element of Traffic Management. [10 Marks]
    (b) How key management for symmetric encryption techniques is done using
          kerberos? [10 Marks]

5. (a) Explain Telecommunication Management Network (TMN) with appropriate diagram. [10 Marks]
    (b) Discuss the benefits of spreading codes. What are the issue that still remain to be
          addressed by spreading codes? Describe how the process of scrambling is used to
          solve these problems. [10 Marks]

6. (a) With the help of neat diagram. Explain GSM architecture. [10 Marks]
    (b) Explain classification of signalling techniques. [10 Marks]

7. Write short notes on any two :- [20 Marks]
    (a) Handoff algorithms.
    (b) Firewalls.
    (c) Adhoc wireless networks.

Also see Convergence of technologies and networking in communication question papers for May 2013

S.E. (I. T.) WEB PROGRAMMING, Semester 4, May 2009

S.E. (I. T.) WEB PROGRAMMING, Semester 4, May 2009

Con. 3056-09.

VR – 3858

(3 Hours)

[Total Marks : 100]

N. B.: (1) Question no 1 is compulsory, solve any four question from remaining six questions.
(2) Assume suitable data where ever necessary.
(3) Figures to the right indicate full mark.

1. (a) What is CSS and what do you understand by term “cascading”? ---- (10 Marks)
(b) Write Java script to validate a form consisting of Name, Age, Address, Email id, Hobby (check- box), Gender (radio button), country (Drop doun menu). --- (10 Marks)

2. (a) Explain difference between Get and Post HTTP Method. ----(5 Marks)
(b) Explain tree tire architecture. --- (5 Marks)
(c) Explain DNS. --- (5 Marks)
(d) Explain function of web server --- (5 marks)

3. (a) Write a HTML code which include table, Hyperlink. Character formatting, ordered and unordered list to display your Resume. --- (10 Marks)
(b) Differences between XML and HTML. --- (5 Marks)
(c) What do you understand by Rich Internet Applications? --- (5 Marks)

4. (a) What do you mean by session management? How cookies are used to track a session? --- (10 marks)
(b) Write JSP code for password verification which take data from database. --- (5 Marks)
(c) What is RSS and how it works? --- (5 Marks)

5. (a) Discuss various stages of request Response life cycle in JSP. --- (10 Marks)
(b) Explain different ASP objects. --- (10 Marks)

6. (a) Explain JDBC API and JDBC drivers in details.--- (10 Marks)
(b) Explain SOA architecture. --- (10 Marks)

7. (a) Explain Servlet life cycle in detail. --- (10 Marks)
(b) Write ASP code to search specific record in a database and display the result in the form. --- (5 Marks)
(c) Explain XSL elements. --- (5 Marks)

Also see Web programming question papers for December 2013

Middleware and Enterprise Integration Technologies (MEIT) Semester 6 (DEC 2012)

Middleware and Enterprise Integration Technologies (MEIT) Semester 6 (Revised Course) (3 Hours) DEC 2012
KR-9149 [Total Marks : 100]
N.B:	(1)	.Question No. 1 is compulsory
	(2)	Answer any four out of remaining questions
1.	(a)	What are the features of Distributed Object System	05
	(b)	Differentiate between RMI and RPC	05
	(c)	Explain with an example, Service Oriented Architecture (SOA)	05
	(d)	Describe the steps involved in EJB deployment	05
2.		Consider a college course management system. The system maintains information about all courses, pre-requisites, faculty, grades, etc. For faculty, their qualifications and other details are to be maintained. Student details like names, courses registered, grades obtained, dates of course etc are also stored. Make any other reasonable assumptions.
	(a)	Give a DTD for the XML schema for the above system	10
	(b)	Find the following query in XQuery: Find all the students who scored an A grade in English course taught by Prof. Joshi 2010	10
3.	(a)	What is the use of IDL in CORBA? Explain with an examples	10
	(b)	Describe the CORBA architecture with the help of a block diagram	10
4.	(a)	Using an online banking system as an example describe the different types of enterprise beans needed for implementing an EJB application	10
	(b)	What is the use of POA in CORBA? How is it different from BOA?	10
5.	(a)	Explain the concept of a service in SOA with a simple example. How is a web service related to SOA	10
	(b)	Explain the concept of Apartments in COM	10
6.	(a)	What do you mean by multi-tier system architecture? Illustrate using an online movie booking system	10
	(b)	Describe the net architecture with the help of neat diagrams	10
7.		Write brief notes on:
	(a)	Overview of CORBA services	10
	(b)	(Distributed COM (DCOM) Architecture	10

Also see Middleware and enterprise integration technologies question papers for December 2010