All Questions
3 questions
0
votes
1
answer
187
views
How is B-Tree used in DBMS-s if WHERE condition can be anything?
The most of the database management systems use B-tree as a data structure for increasing the performance.
Let's imagine that we have a table users with the following columns: id (int), name (string), ...
- 111
-2
votes
1
answer
141
views
In DBMS are Secondary Indices ordered?
I've read that the Heap File Organization is usually used to structure a secondary index. This makes me suspect that usually, a secondary index is unordered, as opposed to the primary index, that is ...
- 113
-3
votes
1
answer
4k
views
How to draw an E-R diagram?
I am learning DBMS in my college. Recently I was given an assignment to draw a E-R Model of a Bus Reservation system which handles Reservations, Ticketing and cancellations.
I understand the theory ...
- 751