(See related pages)
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. |