MI0034 – DATABASE MANAGEMENT SYSTEM

Dear students get fully solved  SMU MBA assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601

ASSIGNMENT

DRIVE	WINTER 2015
PROGRAM	MBADS (SEM 3/SEM 5)MBAFLEX/ MBA (SEM 3)
SUBJECT CODE & NAME	MI0034 – DATABASE MANAGEMENT SYSTEM
BK ID	B1966
CREDITS	4
MARKS	60

Note: Answer all questions. Kindly note that answers for 10 marks questions should be approximately of 400 words. Each question is followed by evaluation scheme.

Question.1. a. Explain the different components of Database Management System (DBMS)

Answer: Components of a DBMS

The DBMS accepts the SQL commands generated from a variety of user interfaces, produces query evaluation plans, executes these plans against the database, and returns the answers. As shown, the major software modules or components of DBMS are as follows:

(i) Query processor: The query processor transforms user queries into a series of low level instructions. It is used to interpret the online user's query and convert it into an efficient series of operations in a form capable of being sent to the run time data manager for execution. The query processor uses the data dictionary to find the

b. With an example explain the properties of DBMS

Answer:A typical structure of a DBMS with its components and relationships between them is show. The DBMS software is partitioned into several modules. Each module or component is assigned a specific operation to perform. Some of the functions of the DBMS are supported by operating systems (OS) to provide basic services and DBMS is built on top of it. The physical data and system catalog are stored on a physical disk. Access to the disk is controlled primarily by as, which schedules disk input/output. Therefore, while designing a DBMS its interface with the as must be taken into account.

Question.2. Explain the different operations of relational algebra with suitable examples.

Answer:Relational database systems are expected to be equipped with a query language that can assist its users to query the database instances. There are two kinds of query languages − relational algebra and relational calculus.

Relational Algebra

Relational algebra is a procedural query language, which takes instances of relations as input and yields instances of relations as output. It uses operators to perform queries. An operator can be either unary or binary. They accept

Question.3. Write short notes on

a. Cardinality ratio

Answer:Mapping cardinalities, or cardinality ratios, express the number of entities to which another entity can be associated with via a relationship set. They are most useful in describing binary relationship sets, however, they can be used to describe relationships sets involving more than two entity sets.

One-to-One: An entity in A is associated with, at most, one entity in B, and an entity in B is associated with, at most, one entity in A.

b. Participation constraints

Answer:Public participation is a political principle or practice, and may also be recognised as a right (right to public participation). The terms public participation, often called P2 by practitioners, is sometimes used interchangeably with the concept or practice of stakeholder engagement and/or popular participation.

Generally public participation seeks and

Question.4. a. Define SQL

Answer:Structured Query Language (SQL) is a standard computer language for relational database management and data manipulation. SQL is used to query, insert, update and modify data. Most relational databases support SQL, which is an added benefit for database administrators (DBAs), as they are often required to support databases across several different platforms.

First developed in the early 1970s at IBM by

b. Explain the different types of SQL

Answer:SQL is Structured Query Language is a database computer language designed for managing data in relational database management systems (RDBMS).

PostgreSQL is an object-relational database management system (ORDBMS). It is released under a BSD-style license and is thus free software. As with many other open-source programs, PostgreSQL is not controlled by any single company, but has a global community of developers and companies to develop it.

Question.5. a. Explain the two-phase locking protocol

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:

b. Elaborate advantages and disadvantages of Distributed database management system

Answer:The distribution of data and applications has potential advantages over traditional centralized database systems. Unfortunately, there are also disadvantages; in this section we review the advantages and disadvantages of DDBMS.

There are following advantages of DDBMs:

Question.6. What is client–server model? Briefly explain the advantages of client–server model

a. Defining client-server model with different parts

Answer:The client–server model of computing is a distributed application structure that partitions tasks or workloads between the providers of a resource or service, called servers, and service requesters, called clients. Often clients and servers communicate over a computer network on separate hardware, but both client and server may reside in the same system. A server host runs one or more server programs which share their

b. Listing 3 advantages of client–server model

Answer:In general, a service is an abstraction of computer resources and a client does not have to be concerned with how the server performs while fulfilling the request and delivering the response. The client only has to understand the response based on the well-known application protocol, i.e. the content and the formatting of the data for the requested service.  Clients and servers exchange messages in a request–response messaging pattern: The client sends a request, and the server returns a response. This exchange of messages is an example of inter-process communication. To communicate, the computers must have a common language, and they must follow rules so that both the client and the server know what to expect

Dear students get fully solved  SMU MBA assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601