Introduction to Database Management
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.
- 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 using a development tool.