Database Theory & Practice for Creative Enterprises

93-732

Units: 6

Description: Databases provide a powerful tool for any policy analyst and are the information backbones of organizations of all kinds. This course introduces the relational database model entity-relationship diagrams data flow diagrams structured query language query by example forms reports and macros using the Microsoft Access database package. Applications include data import cleaning and aggregation for policy analysis and database systems for delivery and management of services.

Learning Outcomes: Almost all databases used in organizations today are relational databases—the most flexible and easiest to use type of database. This course covers design and implementation of relational databases at the introductory level, including tables, forms, queries, and reports. At the end of the course, students will be able to: • Formulate basic and advanced relational database queries using a query tool such as Access’s Query by Example. • Describe the rationale for the basic design principals of relational databases such as referential integrity and foreign keys. • Interpret an entity relationship diagram for an existing relational database including participation and cardinality. • Create an entity relationship diagram based on an organization’s data and business rules. • Illustrate special cases of database designs including weak entities, generalization classes, and case life cycle representation. • Create a physical relational database design based on an entity relationship diagram. • Design and implement simple customized database user interfaces including forms and reports using a development tool. • Design and develop a personal-use database in Access.