DATABASE DESIGN

1. Compare and contrast conventional files and modern, relational databases.
2. Define and give examples of fields, records, files, and databases.
3. Describe a modern data architecture that includes files, operational databases, data warehouses, personal databases, and work group databases.
4. Compare the roles of systems analyst, database administrator, and data administrator as they relate to databases.
5. Describe the architecture of a database management system
6. Describe how a relational database implements entities, attributes, and relationships from a logical data model.
7. Transform a logical data model into a physical, relational database schema.
8. Generate SQL code to create the database structure in a schema.

Download PDF:  14_DATABASE DESIGN (size 983 KB)