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
Question 1 Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? Question 2 With a necessary example explain (i)

Explain I command in QBE ? I : It is the command in QBE that is used to insert tuple (s) into the database

Enumerate or state the steps in creating a relevant database of a shop.

Which two files are used during operation of the DBMS? Data dictionary and transaction log are two files used during operation of the DBMS.

How is the database organised in Oracle? Database organized within Oracle in terms of table and table holds attributes and values. A database consists of one or more logical

find a name whose address is erode from student table

There are many simple and complex approaches to implement. These reports are based on some views or certain query. The following number of reports can be built. 1. The averag

What is the use of group by clause? Group by clause is used to be relevant aggregate functions to a set of tuples. The attributes given in the group by clause are used to shape

What do you mean through integrity constraints? Integrity Constraints -An integrity constraint is a condition specified on a database schema and restricts the data in which

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4