EEN523 Study Guide for test 11-2-1899
(Reccommended book: Database Systems, a practical approach to design,
implementation, and management, Begg & Connolly, Addison-Wesley,
1998, ISBN 0-201-34287-1)
The manual for our version of SQL is also on-line and
available here.
Only general guidance, no warranties expressed or implied.
- SQL basic operations
- Creating tables,
- Inserting data,
- Select commands, and sensible design of query expressions
- The importance of indexes, what they are, how they work,
- What cursors are and why they are needed.
- Physical and Logical File Formats
- Terminology: track, sector, block, cluster, surface, cylinder, etc.
- Structure of disc, FAT vs. free-list, etc.
- Influences on access time for disc blocks,
- Primitive disc organisation: continuous run block allocation and Condensing
- Structure of Files:
- Header blocks and their contents,
- Single-level, two-level, and multi-level indexes,
- Calculating maximum supported file-sizes
- Calculating reasonably expectable data access times