DM-03 - Relational DBMS

- Explain the advantage of the relational model over earlier database structures including spreadsheets
- Define the basic terms used in relational database management systems (e.g., tuple, relation, foreign key, SQL, relational join)
- Discuss the efficiency and costs of normalization
- Describe the entity-relationship diagram approach to data modeling
- Explain how entity-relationship diagrams are translated into relational tables
- Create an SQL query that extracts data from related tables
- Describe the problems associated with failure to follow the first and second normal forms (including data confusion, redundancy, and retrieval difficulties)
- Demonstrate how search and relational join operations provide results for a typical GIS query and other simple operations using the relational DBMS within a GIS software application
DM-04 - Object-oriented DBMS