List and describe the different types of indexes, Database Management System

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

Question 2 Consider a book is written by a particular author. And you have to explain to someone about 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.

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

Posted Date: 11/13/2013 5:37:22 AM | Location : United States







Related Discussions:- List and describe the different types of indexes, Assignment Help, Ask Question on List and describe the different types of indexes, Get Answer, Expert's Help, List and describe the different types of indexes Discussions

Write discussion on List and describe the different types of indexes
Your posts are moderated
Related Questions
Explain Interblock gap? Interblock Gap - A track of a disk is separated into equal-sized disk blocks. Blocks are separated through fixed-size gaps, called as interblock gaps th

What does authentication refer? Authentication refers to the task of verifying the uniqueness of a person.

State as Location within a Program In this traditional approach, location of control inside a program totally defines the program state. Any finite state machine may be implem

Although, the essential features of E-R diagrams are enough to design many database situations. Though, with more difficult relations and advanced database applications, it is need

Types of data independence Data independence can be classified into the following two types: Physical Data Independence: This means that for any change made in the physi

Domain Constraint It shows that each attribute in a relation has to contain an atomic value only from the corresponding domains. The data types associated with commercial RDBMS

What is the need of a log in a DBMS? Briefly describe the various types of records that are normally present in a log.            Ans:  The system log, which is generally writt

Discuss the mechanism to read data from and write to a disk? Disk read/write heads are mechanisms in which read data from or write data to disk drives. The heads have gone by

1. Staff(staffID, firstName, lastName, availabilityID, experience, phone, mobile, email); 2. Availability(availabilityID, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday,

Using Column aliases Example: To print column names as NAME and ANNUAL SALARY SELECT ENAME "NAME", SAL*12 "ANNUAL SALARY" FROM EMP;