Get fully solved assignment. Buy online from website
online store
or
plz drop a mail with your sub code
we will revert you within 2-3 hour or immediate
Charges rs
125/subject and rs 700/semester only.
if urgent then call us on 08791490301, 08273413412
DRIVE
SPRING 2016
PROGRAM
MASTER OF BUSINESS ADMINISTRATION (MBA)
SEMESTER
III
SUBJECT CODE
& NAME MI0034 – DATABASE MANAGEMENT SYSTEM
1 What is Database Management System
(DBMS)? Briefly explain the important properties of database.
Explain
Database Management System
Important
properties of database
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
2 Explain the different operations of
relational algebra with suitable examples.
Explaining
the various operations of relational algebra with an example
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:
Ø
Selection (
3 What is
client–server model ? Briefly explain the advantages of client–server model.
Define
client-server model with different parts
List
3 advantages of client-server model
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
4 a. Define SQL
b. Explain the different types of SQL
a.
Defining SQL
b.
Defining four 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
5 a. Explain the two-phase locking
protocol with various phases
b. Elaborate advantages and
disadvantages of Distributed database management system
a.
Explaining two phase locking protocol with various phases
b.
Explaining four advantages and four 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
6 Briefly explain the basic concepts of
object-oriented data model.
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
Get fully solved assignment. Buy online from website
online store
or
plz drop a mail with your sub code
we will revert you within 2-3 hour or immediate
Charges rs
125/subject and rs 700/semester only.
if urgent then call us on 08791490301, 08273413412
No comments:
Post a Comment