Data storage is a critical component of most information systems. This chapter teaches
the design and construction of physical databases. You will know that you have mastered
the tools and techniques of database design when you can:
Compare and contrast conventional files and modern, relational databases.
Define and give examples of fields, records, files, and databases.
Describe a modern data architecture that includes files, operational databases, data
warehouses, personal databases, and work group databases.
Compare the roles of systems analyst, data administrator, and database
administrator as they relate to databases.
Describe the architecture of a database management system.
Describe how a relational database implements entities, attributes, and relationships
from a logical data model.
Transform a logical data model into a physical, relational database schema.
Generate SQL code to create the database structures in a schema.
To learn more about the book this website supports, please visit its Information Center.