ASSIGNMENT

DRIVE SPRING DRIVE 2015

PROGRAM MBADS (SEM 3/SEM 5)

MBAFLEX/ MBA (SEM 3)

PGDISMN (SEM 1)

SUBJECT CODE &

NAME

MI0034 DATABASE MANAGEMENT SYSTEM

BK ID B1966

CREDIT 4

MARKS 60

Note: Answer all questions. Kindly note that answers for 10 marks questions should be approximately of 400 words. Each question is followed by evaluation scheme.

Q.No Questions Marks Total Marks

1 Write short notes on a. Latency and seek b. RAID c. Blu-ray Disk drive d. Variable length records

a. Latency and seek 2

10 b. RAID 3

c. Blu-ray Disk drive 3 d. Variable length records 2

2 Explain various forms of Normalization with an example of employee database

Constructing an un-normalized normal form 2

10 Converting the un-normalized normal form to

different normal forms with an explanation

8

3 Elaborate the different types of schema-based constraints

Listing and explaining 5 different types of

constraints

10

10

4 Write SQL commands for the following queries

a. List all the employees from a employee database whose salary falls in the range from Rs. 25,000 to Rs. 35,000

b. If there are two tables STUDENT and SUBJECT, display the list of students who have opted for computer subject.

c. Display the name of the highest scorer in the class. d. For every project located in London, list the project number, the controlling

department number and the department managers last name, address and birth date

a. SQL command using Between and OR operator

2

10

b. SQL command using single-row nested queries

3

c. SQL command using multiple-row nested queries

2

d. SQL command using mix of algebraic operators

3

5 a. List the advantages of Distributed Database Management System (DDBMS) b. List the disadvantages of DDBMS c. What is data fragmentation and data replication?

a. Listing advantages of DDBMS 2 10

b. Listing disadvantages of DDBMS 2

c. Explaining data fragmentation 3

Explaining data replication 3

6 Write short notes on

a. Inheritance b. Relationships c. Object classes d. Object Relational Database Management System

a. Inheritance 2

10 b. Relationships 3 c. Object classes 2 d. Object Relational Database Management

System 3