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
MI0034
Winter 2015
1 a. Explain
the different components of Database Management System (DBMS)
b. With an
example explain the properties of DBMS
a. Various components of DBMS
b. Listing three important properties of
database
Explaining each property with an example
Answer:
A) components of Database Management
System
Database engine
Database engine is termed as the heart of the
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
3 Write
short notes on
a.
Cardinality ratio
b. Participation
constraints
a. Defining cardinality ratio
Explaining the four types of mapping
cardinalities example for each of the cardinality mapping
b. Explaining the two ways of participation
roles
Answer:
A) The cardinality ratio specifies the number of entities
to which another entity can be associated through a relationship set.
The different mapping cardinalities are of
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 SQL Server, Access, and so
on. When the
5 a. Explain
the two-phase locking protocol
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 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.
2. Shrinking
phase – In this
6 What is
client–server model ? Briefly explain the advantages of client–server model
a. Defining client-server model with
different parts
b. Listing 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
parts
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