MI0034 –Database Management Systems

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id

->  help.mbaassignments@gmail.com

or

call us at -> 08263069601

Summer 2013

Master of Business Administration- MBA Semester 3

MI0034 –Database Management Systems-4 Credits

(Book ID: B1217)

Assignment (60 marks)

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

Q1. Suppose the employee name, employee id, designation, salary, attendance and address of any employee has to be stored in a database. You can store these data in a sequential address book or it can be stored on a hard disk, using a computer and software like Microsoft Excel. Using this example define a database. List and explain the various procedures carried on in a DBMS with a detailed example of the database.

Answer : Database :

A database is an organized collection of data. The data is typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with

Q2. What are the different types of interfaces provided by DBMS?)

Answer : Types of interfaces provided by DBMS :

A database supports a number of user groups, the DBMS must have languages and interfaces that support each user group. A DBMS interface is the abstraction of a piece of functionality of a DBMS. It usually refers to the communication boundary between the DBMS and clients or to the abstraction provided by a component within a DBMS. A DBMS interface hides the implementation of the functionality of the component it encapsulates. DBMS

Q3. Level 2 cache has got higher latency than Level 1 by 2 times to 10 times in 512 KiB or more. Its value is nearer to kilobyte. This is one of the levels of memory hierarchy. Define memory hierarchy. What are the other levels in memory hierarchy? Explain in one life each for each of them.

Answer : Memory hierarchy :

The term memory hierarchy is used in computer architecture when discussing performance issues in computer architectural design, algorithm predictions, and the lower level programming constructs such as involving locality of reference. A "memory hierarchy" in computer storage distinguishes each level in the "hierarchy" by response time. Since response time,

 Q4. Indexes are usually defines on a single field of a file called an indexing field. List and describe the different types of indexes

Answer : A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of slower writes and the use of more storage space. Indexes can be created using one or more columns of a database table, providing the basis for both rapid random lookups and efficient access of ordered records.

Types of indexes :

1. Bitmap index

2. Dense index

Q5. Consider a book is written by a particular author. And you have to explain to some one the relationship that exists between the author and the book. Normally you can draw a diagram and show the relation. These diagrams are called entity-relationship diagram in which book is one entity, author is one entity, and the relationship that exists between the two entities is written. Likewise explain the various notations used to represent the ER diagram.

Answer : Notations used to represent ER diagrams :

There is no standard for representing data objects in ER diagrams. Each modeling methodology uses its own notation. All notational styles represent entities as rectangular boxes and relationships as lines connecting boxes. Each style uses a special set of symbols to represent the cardinality of connection. The symbols used for the basic ER constructs are:

• Entities are represented by labeled rectangles. The label is the name of the entity. Entity names should be singular nouns.

• Attributes are represented by Ellipses.

Q6. Consider a banking database (select the tables and fields of your choice). Now apply all the operations of relational algebra and find the result.

Answer :  Banking database  :

A database consists of multiple relations Information about an enterprise is broken up into parts, with  each relation storing one part of the information

account :   stores information about accounts
depositor : stores information about which customer  owns which account
customer : stores information about

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id

->  help.mbaassignments@gmail.com

or

call us at -> 08263069601