MI0034-Database Management System

Spring-2016

Get solved assignments at nominal price of Rs.125 each.

Mail us at: subjects4u@gmail.com or contact at

09882243490

Master of Business Administration- MBA Semester 3

MI0034-Database Management System

(Book ID: B1966)

Assignment (60 Marks)

Note: Answer all questions must be written within 300 to 400 words each. Each Question carries 10 marks 6 X 10=60

Q1. What is Database Management System (DBMS)? Briefly explain the important properties of database.

Explain Database Management System - 4

Important properties of database - 6

Answer. The major component in the database is “data.” Data is a raw fact that can be recorded and has specific meaning. The processed data is called information. For example, the combination of letters “E” “L” “E” “P” “H” “A” “N” “T” has no meaning to us unless it is used as a noun word “Elephant.” Here, the letter “E” is a data and “Elephant” is information. The collection of data in rows and columns is called database.

Q2. Explain the different operations of relational algebra with suitable examples.

Answer. Relational Algebra

Relational algebra is a language in which one relation gets defined by another relation without the original relation getting changed. There are many operations that work with relational algebra. Some of them are given below:

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

Define client-server model with different parts - 7

List 3 advantages of client-server model - 3

Answer. Client–server model

The client–server model is basic to distributed systems; it allows clients to make requests that are routed to the appropriate server in the form of transactions. The client–server model consists of three parts.

1. Client – The client is the machine (workstation or PC) running the frontend applications. It interacts with a user through the keyboard, display and mouse. The client has no direct data access responsibilities. The client machine provides front-end application software for accessing the data on the server. The clients initiate transactions and the server processes the transactions.

Q4. a. Define SQL

b. Explain the different types of SQL

Answer. a. SQL is a relational database language used to communicate with a database. The American National Standards Institute declared the standard language for RDBMS. Accordingly, the common relational database management systems that SQL uses are Oracle, Sybase, Microsoft SQL Server, Access, and so on. When the database is structured using the relational data model, SQL is a suitable language because SQL is

Q5. a. Explain the two-phase locking protocol with various phases.

b. Elaborate advantages and disadvantages of Distributed database management system.

Answer. a. The two-phase locking protocol

The two-phase locking protocol is a process to access the shared resources as their own without creating deadlocks. This process consists of two phases.

1. Growing phase – In this phase, the transaction may acquire lock, but may not release any locks. Therefore, this phase is also called as resource acquisition activity.

Q6. Briefly explain the basic concepts of object-oriented data model.

Answer. A data model is a logic organisation of the real-world objects (entities), constraints put on them and the relationships that exists among objects.

The basic concepts of object-oriented data model are the following:

Object identity

Any real-world entity is uniformly modelled as an object. They are attached with a unique ID which is used to refer the object for retrieval. You can see an object retaining its identity even if some or all of the values of variables or definitions of methods change over time. This concept of object identity is necessary in

Spring-2016

Get solved assignments at nominal price of Rs.125 each.

Mail us at: subjects4u@gmail.com or contact at

09882243490