Introduction to Database Management
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 by example, forms, 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: Formulate basic and advanced relational database queries using a query tool such as Access’s Query by Example. Create database queries using Structured Query Language (SQL) 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. 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. Use macros to automate the use of Access and Excel for data analysis.