MCA (Revised) Term-End Examination December, 2OO8 MCS-04it: ADVANGEDDATABASEDESIGN Time : 3 hours

Maximum Marks: 700

Note : Questionnumber 7 is compulsory. Answer any three questionsfrom the rest. 1.

(a) Consider the following relation R (A, B, C) : R

A 1 4 5 5

B

c

2 2

3

3 3

3 4

3

Which of the following dependenciesdoes not hold ? Give reasons.

(i) A+B (ii)A++B (b) What is a data warehouse ? Describe the processof ETL for a data warehouse. MCS-043

1

5

P.T.O.

(c) What is timestamp ordering ? Explain timestamp based protocol for serializable schedule. Consider the following requirements: A A car or truck can be a registered-vehicte. person, bank or company can own a registered vehicle. Model this requirement using EER diagram. Consider the following relations': EMPLOYEE (Eno, Ename, Address,Phone, Salary, Dnum) DEPT (Dnum, Dlocation, Dname) PROJECT (Pno, Dname, Dnum) Find the names of employeesusing relational algebra who work on all projects controlled by Department Number 5. How will you enforce Referential Integrity Constraint in Oracle ? Explain with the help of one example. Create an object-oriented database using ODL for' the following schema. Make suitable assumptionsabout attributes.

(h) What

are

the

common database security

failures ? What are the SQL commands for granting permission ? Why are statistical databasesmore prone to disclosure? Explain with the help of an example. 2.

(a) What is the significanceof cursorsin embedded SQL ? Explain with the help of an example. (b) What

are mobile databases ? Explain the

characteristicsof mobile databases. (c) What do you mean by deadlock ? How can we prevent them ? Write an algorithm that checks .

whether the concurrently executing transactions are in deadlock

3.

10

(a) What is data mining ? How is it different from OLTP ? What is classificationin context of data mining ? (b) What are data-maits ? What is the significance of creating them ? (c) What is XML ? How

is it different from

HTML ? What are the advantagesof XML ? Create an XML schema for list of studentsand their marks MCS-043

70

P.T.O.

4.

(a) Compare , and contrast Relational database management systems, Object-relational databasemanagementsystems,Object-oriented database management systems. Suggest one application for each of managementsystems.

these database

70

(b) Explain Join Dependencywith the help- of an example. To which normal form does it correspond ? Functional dependencies and multivalued dependenciesare special type of Join dependencies.Justify. 5.

10

(a) Explain the centralized Two-phase Commit Protocol in Distributed Environment. Give the algorithm for both coordinaiorand participants. 12 (b) Develop a query plan for the following query and compute its cost : ,SALARY

> 4OOOO(EMPLOYEE X DEPARTMEM'

Make suitable assumptions of your own about the relation schema as well as the database statistics. I

MC5-043

MCA (Revised) Term-End Examination rl

December,2008

cr) (o O

MCS-051 : ADVANCED INTERNET TECHNOLOGIES Maximum Marks : LA0

Time':3 hours

Note : Questionnumberf. is compulsory.Attemptany three questions from the rest. t.

(u) Write a MDB (MessageDriven Bean) for news agency that has to capture the data from various news sources. The newly written MDB should accept the XML format of the news. The XML data needs to be parsed and stored in the database. The news format is as follows :



(news-content> (b)

What is Java Servlet ? Draw, to represent the different phases of servlet life cycle.

(c)

Explain the different types of Enterprise beans.

(d)

Explain SessionBeansand Define their life cycle.

(e)

\A/hat is a custom tags in ISP ? What are the components that make up a tag library in ISP ?

z.

D

.t.

(0

What are the different recovery procedures in security implementatron ?

(a)

What do you mean by sessiontracking ? Also, explain in brief different ways to handle sessiontracking in servlet.

10

(b)

Explain SSL and TLS with their working and .security measures.

10

(a)

Differentiate between the following :

(b)

(i)

GET and POST

(tl)

Context init Parameter and Servlet init Parameter

(rit)

Servlet Engines and Servlet Chaining

(iv)

Data Integrity and System Integrity

Create a custom JSPtags named as " Sorted t 0 Iterate Tags' that can iterate or process any java collection. For example it should accept the list of telephone numbers and print them in sorted manner.

4.

(a)

Write an application to create a XML document from a telephone directory database. The XML document should

10

contain the name of a customer, address, telephone number and the last twelve months bill payment summary. (b)

c.

Explain database handling in JSP using Vpe 2 and type 4 drivers.

10

(u) What are the different types of implicit

10

objectsused in JSP? Explain all in brief. What are the different design and developmentGoalsfor XML and explain the

10

(b)

usage of XSD/DTD in XMl.documents. -oOo-