Databases

1. Describe how data is organized: characters, fields, records, and files.
2. Understand the difference between batch processing and real-time processing.
3. Describe the difference between master files and transaction files.
4. Define and describe the three types of file organizations: sequential, direct, and index sequential.
5. Describe the advantages of a database.
6. Describe the two essential parts of of a database management system (DBMS).
7. Describe four ways of organizing a DBMS: hierarchical, network, relational, and object-oriented.
8. Distinguish among individual, company, distributed, and proprietary databases.
9. Discuss some issues of productivity and security.
        

Key Terms

batch processing	direct file organization	parent node
character	distributed database	pointer
child node	field	processing rights
common operational database	file	proprietary database
common user database	hashing	query language
company database	hierarchical database	real-time processing
database	index sequential file organization	record
database administrator (DBA)	individual database	relation
database management system (DBMS)	key field	relational database
data dictionary	master file	sequential file organization
data integrity	microcomputer database	structured query language (SQL)
data mining	network database	transaction file
data redundancy	nodes
data warehouse	object-oriented database

<  Previous Page                             Next Page >