Courses

Introduction to Database Management (90-728)

Most organizations depend on databases for delivery of goods and services, allocation of 
resources, and support of management decision making and policy analysis. Policy analysts 
and managers also find database packages like Microsoft Access valuable for personal use, 
especially in getting data ready for use.


Learning Objectives: 

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.

  • Units
    6
1