MI0034 – DATABASE MANAGEMENT SYSTEM

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601

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
CREDITS	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. 1. Write short notes on

a. Latency and seek:The seek time of a hard disk measures the amount of time required for the read/write heads to move between tracks over the surfaces of the platters. Seek time is one of the most commonly discussed metrics for hard disks, and it is one of the most important positioning performance specifications. However, using this number to compare drives can be somewhat

b. RAID:RAID (originally redundant array of inexpensive disks; now commonly redundant array of independent disks) is a data storage virtualization technology that combines multiple disk drive components into a single logical unit for the purposes of data redundancy or performance improvement. Data is distributed across the drives in one of several ways, referred to as RAID levels,

c. Blu-ray Disk drive:Blu-ray Disc (BD) is a digital optical disc data storage format designed to supersede the DVD format, in that it is capable of storing high-definition video resolution (1080p). The plastic disc is 120 mm in diameter and 1.2 mm thick, the same size as DVDs and CDs.

d. Variable length records:It is a record that has at least one variable-length field. The length of the entire record, therefore, varies according to what data is placed in the variable-length field. Variable-length fields are useful because they save space. Suppose, for example, that you want to define a

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

Answer:Normalization is a process of reducing redundancies of data in a database. Normalization is a technique that is used when designing and redesigning a database. Normalization is a process or set of guidelines used to optimally design a database to reduce redundant data. The actual guidelines of normalization, called normal forms, will be discussed later in this hour. It was a difficult decision to decide whether to cover normalization in this book because of the complexity involved in understanding the rules of the normal forms this early on in your SQL journey. However, normalization is an important process that, i

Q. 3. Elaborate the different types of schema-based constraints

Answer:Data are actually stored as bits, or numbers and strings, but it is difficult to work with data at this level.

It is necessary to view data at different levels of abstraction.Diagram to show the 3 level of adatabase architecture.

Schema:

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

INSERT INTO

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

Many of us who work in the computing industry, quickly realize, that technical skills are just one part of this competitive game. Softer aspects such as design and communication skills are all just as critical. A popular perception is that creativity has not been sufficiently noticeable in the Indian software space – though this is gradually changing. It is relatively easy to find good programmers in

c. Display the name of the highest scorer in the class.

High score tables should be persistent which means the data should not be lost when the game is closed and re-opened at a later time. Therefore the high score table needs to be stored to disk, and our first task is to figure out where to store them.

In Windows, there are three recommended storage locations (the full list can be found in MSDN’s KNOWNFOLDERID documentation):

d. For every project located in “London”, list the project number, the controlling department number and the department manager’s last name, address and birth date

Answer:We can also use the update command in the following way

UPDATE GM_ENGINEER2011

SET (ENGG_FNAME,ENGG_LNAME) =

Q. 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?

Answer:A centralized distributed database management system (DDBMS) manages the database as if it were all stored on the same computer. The DDBMS synchronizes all the data periodically and, in cases where multiple users must access the same data, ensures that updates and deletes performed on the data at one location will be automatically reflected in the data stored elsewhere.

Q. 6. Write short notes on

a. Inheritance: In object-oriented programming (OOP), inheritance is when an object or class is based on another object or class, using the same implementation (inheriting from a class) specifying implementation to maintain the same behavior (realizing an interface; inheriting behavior). It is a mechanism for code reuse and to allow independent extensions of the original software via public classes and interfaces. The

b. Relationships:It is a connection between variables, such as a correlation, or between people, such as a marriage.  A good relationship is more than something we want—it’s something we need to be our happiest,

c. Object classes: All LDAP entries in the directory are typed. That is, each entry belongs to object classes that identify the type of data represented by the entry. The object class specifies the mandatory and optional attributes that can be associated with an entry of that class.

The object classes for all objects in

d. Object Relational Database Management System:An object relational database management system (ORDBMS) is a database management system with that is similar to a relational database, except that it has an object-oriented database model. This system supports objects, classes and inheritance in database schemas and

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601