MI0034 –Database Management System

Dear students get fully solved assignments

call us at :- 08263069601 

            or

mail us at  help.mbaassignments@gmail.com

Spring/Feb 2013

Master of Business Administration- MBA Semester 3

MI0034 –Database Management System-4 Credits

(Book ID: B1217)

Assignment Set -1 (60 marks)

Note: Assignment Set -1 must be written within 6-8 pages. Answer all questions.

Q1. Define Data Model & discuss the categories of Data Models? What is the difference between logical data Independence & Physical Data Independence? 10 marks (350-400 words)

Answer : A database model is a theory or specification describing how a database is structured and used. Several such models like Hierarchical model, Network model, Relational model etc., have been suggested.

Data Model, Schemas and Instances:

Data Model  :

It is a set of Concepts for viewing a set of data

Q2. What is a B+Trees? Describe the structure of both internal and leaf nodes of a B+Tree?10 marks (350-400 words)

Answer :  In computer science, a B-tree is a tree data structure that keeps data sorted and allows searches, sequential access, insertions, and deletions in logarithmic time. The B-tree is a generalization of a binary search tree in that a node can have more than two children. (Comer 1979, p. 123) Unlike self-balancing binary search trees, the B-tree is optimized for systems that read and write large blocks of data. It is commonly used in databases and file systems.

Q3. Describe Projection operation, Set theoretic operation & join operation? 10 marks (350-400 words)

Answer :  Project operation:

Projection operation is used to select only few columns from a table. the mathematical symbol p<ATTRIBUTE LIST>(<relation>)

Here, <attribute list> is a list of attributes from the relation r hence the degree (number of columns) of the result is equal to

Q4. Discuss Multi Table Queries? 10 marks (350-400 words)

Answer :  Multi Table Queries

 So far the queries that we have discussed were containing only one table in the clause. There are many occasions in the database applications where we need to retrieve data from more than one table. This section addresses these kinds of queries.

SIMPLE EQUI-JOINS:

Q5. Discuss Transaction Processing Concept? 10.2 Describe properties of Transactions? 10 marks (350-400 words)

Answer : Transaction management is the ability of a database management system to manage the varioustransactions that occur within the system. Transaction is a set of program statements or collections of operations that

Q6. Describe the advantage of Distributed database? What is Client/server Model? Discuss briefly the security and Internet violation? 10 marks (350-400 words)

Answer : In a centralized database system, all system components such as data, DBMS software, storage devices reside at a single computer or site, where as in distributed database system data is spread over one or more computer connected by a network. Distributed database is thus a set of databases stored on multiple computers but it appears to a user as single database. The data on several computers can be simultaneously accessed and modified (data from local and remote databases) using a network.

Dear students get fully solved assignments

call us at :- 08263069601 

            or

mail us at  help.mbaassignments@gmail.com