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
No comments:
Post a Comment