Sep 24: Functional Dependencies

Learning Objectives

After today's class, you should be able to:

• Explain anomalies that can occur when redundant data is stored.
• Give everyday examples of functional dependencies in databases.

Lesson Outline

PostgreSQL [25 min]

• Pronounced "post-gres-Q-L"
  • See https://www.postgresql.org/about/
• PostgreSQL vs MySQL (Integrate.io blog)
  • For Example: Data Types
  • However: DB-Engines Ranking
• pgAdmin – PostgreSQL Tools
  • Exploring what's in the menus
  • Clicking the tabs for an object

Lecture Slides [40 min]

• Functional Dependencies
• Includes three short exercises

Python Example [10 min]

• funcdep.py – discover potential FD's
• Uses colorama, itertools, and psycopg

Your To-Do List

• Read zyBook sections 5.1 – 5.2 (today's topic)
• Read zyBook sections 3.10 – 3.12 (Thu's topic)
• Start working on GP2 (due Monday)