# SMU MBA ASSIGNMENTS

## SEM 3 SMU MBA SUMMER 2015 MI0034 – DATABASE MANAGEMENT SYSTEM

SMU MBA SUMMER 2015 -2016

Dear Students,

SMU MBA SUMMER   2015-2016 Assignments are available. For Booking ,Kindly mail us on kvsude@gmail.com OR call us to +91 9995105420  or S M S your “ Email ID ” us in the following Format  “  On +91 9995105420 we will reach back you with in 24H ”

DRIVE- SUMMER 2015

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.

1. List and explain the properties of DBMS

Ans:

1. 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

1. Domain
2. Degree of relation
3. Entity set
4. Primary key
5. tuple

Ans:

1. 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

1. cardinality ratio
2. participation constraints

Ans:

1. 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.

1. What are free and bound variables?

Ans:

1. Listing minimum 2 rules and 4 sub-rules under second rule:
2. Every atom is a formula.

1. 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.

1. Elaborate advantages of Distributed database management systems

Ans:

1. 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

1. What are the disadvantages of ODBMS

Ans:

1. 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

SMU MBA SUMMER 2015 -2016

Dear Students,

SMU MBA SUMMER   2015-2016 Assignments are available. For Booking ,Kindly mail us on kvsude@gmail.com OR call us to +91 9995105420  or S M S your “ Email ID ” us in the following Format  “  On +91 9995105420 we will reach back you with in 24H ”