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-
SUMMER 2015
PROGRAM-
MBADS (SEM 3/SEM 5)
MBAFLEX/
MBA (SEM 3)
SUBJECT
CODE & NAME
MI0034
– DATABASE MANAGEMENT SYSTEM
Qus:1
a. Database management system acts as intermediary agent between programs and
the data. Explain various procedures carried on in a DBMS with example.
b.
List and explain the properties of DBMS
Ans:
a.
Explaining the three procedures carried on in a DBMS:
Various
procedures carried on in a DBMS
1.
The
process of specifying the data types, structures and constraints is called
defining the
Qus:2
Explain the following terminology with an example
a. Domain
b. Degree of relation
c. Entity set
d. Primary key
e. tuple
Ans:
a.
meaning of domain &example for domain:
A domain D is a
set of atomic values. For each attribute, there is a set of permitted values
called the domain of that attribute.
For example: For
the attribute empname, the domain is the set of all empnames.
Qus:3
Write short notes on
a. cardinality ratio
b. participation constraints
Ans:
a.
defining cardinality ratio:
Explaining
the four types of mapping cardinalities:
They are as
follows:
·
One-to-one
·
One-to-many
·
Many-to-one
Qus:4
a. A WFF is constructed from one or more atoms connected via Boolean operators
(AND, OR, NOT) and quantifiers. List the rules for WFF for all quantifiers.
b.
What are free and bound variables?
Ans:
a.
Listing minimum 2 rules and 4 sub-rules under second rule:
1. Every atom is
a formula.
2.
If
F1 and F2 are formulas, then so are (F1 and F2), not (F1), and not (F2). The
truth values of these
Qus:5
a. Describe two phase locking. Elaborate the terminologies used in two phase
locking.
b.
Elaborate advantages of Distributed database management systems
Ans:
a.
Describing two phase locking:
This process
consists of two phases.
1.
Growing phase
2.
Shrinking phase
Qus:6
a. What are the advantages in using object oriented database management systems
(ODBMS) over relational database management systems
b.
What are the disadvantages of ODBMS
Ans:
a.
Listing 8 advantages of ODBMS:
There are many
advantages in using ODBMS over RDBMS. They are as follows:
·
Objects
don’t require assembly and disassembly, and thereby saves coding time and
execution time to assemble or disassemble objects.
·
ODBMS
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