This course examines issues in choosing a FOCUS database design and shows you how to implement efficient structures that allow for economical storage and faster data retrieval. Data relationships and file description syntax are discussed in-depth, and exercises such as designing a new database and redesigning an existing one to improve its performance are included.

Topics Include:

	File design
	Physical vs. logical designs
	File size analysis
	Large file considerations
	Data normalization
	Prototyping
	Handling missing data
	Recursive and alternate file views
	Index use for faster data retrieval
	Dynamic vs. static cross-referencing

Course 111 and knowledge of JOIN