MCA3020 – Advanced Database Management System

Dear students get fully solved assignments

call us at :- 08263069601 

            or

mail us at  help.mbaassignments@gmail.com

July 2012

Masters in Computer Application (MCA) - Semester 3

MCA3020 – Advanced Database Management System – 4 Credits

(Book ID: B1649)

Assignment Set – 1 (60 Marks)

Answer All the Questions. Each question carries equal marks. (6 x 10 = 60)

1. What are the various types of database management system? Briefly explain.

Answer : Types of Database Management Systems

DBMSs come in many shapes and sizes. For a few hundred dollars, you can purchase a DBMS for your desktop computer. For larger computer systems, much more expensive DBMSs are required. Many mainframe-based DBMSs are leased by organizations. DBMSs of this scale are highly sophisticated and would be extremely

2. Explain with examples different SQL commands used for creating and deleting relations. Write a short note on ACID properties of transaction model.

Answer : SQL Commands:

SQL commands are instructions used to communicate with the database to perform specific task that work with data. SQL commands can be used not only for searching the database but also to perform various other functions like, for

3. Define functional dependency. Give examples. Also Explain 2nd and 3rd normal Forms.

Answer : In relational database theory, a functional dependency is a constraint between two sets of attributes in a relation from a database.

Given a relation R, a set of attributes X in R is said to functionally determine another set of attributes Y, also in R, (written X → Y) if, and only if, each X value is associated with precisely one Y value; R is then said

4. Explain the various heuristics involved in query optimization. Also explain the various algorithms for executing query operations.

Answer : A query expressed in a high-level query language such as SQL must first be scanned, parsed, and validated. The scanner identifies the language tokens—such as SQL keywords, attribute names, and relation names—in the text of the query, whereas the parser checks the query syntax to determine whether it is formulated according to the

5. Discuss the One-Pass algorithm for database. Also Explain the eddy architecture and how it allows for extreme flexibility

Answer : In computing, a one-pass algorithm is one which reads its input exactly once, in order, without unbounded buffering. A one-pass algorithm generally requires O(n) (see 'big O' notation) time and less than O(n) storage (typically O(1)), where n is the size of the input.

Basically one-pass algorithm operates as follows: (1) the object descriptions are processed serially; (2) the first object becomes the cluster representative of the first cluster; (3) each subsequent object is matched against all cluster

6. How is two phase locking method used to ensure serializability? Illustrate.

Answer : In databases and transaction processing, two-phase locking (2PL) is a concurrency control method that guarantees serializability. It is also the name of the resulting set of database transaction schedules (histories). The protocol utilizes locks, applied by a transaction to data, which may block (interpreted as signals to stop) other transactions from accessing the same data during the transaction's life.

By the 2PL protocol locks are applied and removed in two phases:

July 2012

Masters in Computer Application (MCA) - Semester 3

MCA3020 – Advanced Database Management System – 4 Credits

(Book ID: B1649)

Assignment Set – 2 (60 Marks)

Answer All the Questions. Each question carries equal marks. (6 x 10 = 60)

1. Explain the concept of serialisability and Recoverability. Illustrate how to manage rollbacks by locking.

Answer : Serializability And Recoverability

Serializability

Serializability is the classical concurrency scheme. This helps to ensures that a schedule with regard to performing executing concurrent

2. What are the different types of partitioning techniques? Describe in detail.

Answer : Data partitioning and collecting in Data stage

Partitioning mechanism divides a portion of data into smaller segments, which is then processed independently by each node in parallel. It helps make a benefit of parallel architectures like SMP, MPP, Grid computing and Clusters.

Collecting is the opposite of partitioning and can be defined as a process of bringing back data partitions into a single sequential stream (one data partition).

Data partitioning methods

3. Discuss the concept of Type Hierarchies and Inheritance with example. Also illustrate multiple inheritances.

Answer : As the third topic in my article series Introduction to Object-Oriented Programming in Lab VIEW I’ll talk about inheritance and conceptual hierarchies in object oriented programming.

Hierarchies of real-world objects

Object of the real world often form

4. Explain the functions and components of DDBMS.

Answer : There are many functions a Database Management System (DBMS) serves that are key components to the operation of database management. When deciding to implement a DBMS in your business, first you must decide what type of DBMS you want. Common types of DBMS are the relational, network, hierarchy and object oriented models. Each kind of database structure has its own pros and cons.

5. Differentiate between RDBMS, OODBMS and ORDBMS.

Answer : The presentation of the similarities and differences between relational modelling of data and the object oriented modelling of data is of great importance both for data base designers and for users. By being well acquainted with the relational model and by noting the similarities and differences between the two approaches to data modelling, designers will be able to turn into account and to make use of the already acquired experience as an important basis for understanding and learning the methodology of designing object oriented databases. At the time if designers know the similarities and differences between these two approaches they have the possibility to convert a relational model into an object orie

6. What are the advantages and disadvantages of Loral query language? Discuss. What is active database? Explain what are the active rules for oracle?

Answer : Modelling and Querying XML Repositories as Object Databases

The DTD is a natural candidate to represent the type of a document. However, XML DTDs do mix together both a description of the logical features of the document, with rather ''physical'' ones (such as, for example, entities, which can be more appropriately considered as storage units or macros rather than structural

Dear students get fully solved assignments

call us at :- 08263069601 

            or

mail us at  help.mbaassignments@gmail.com