functional-dependencies 1.0.0

Compute functional dependencies: implication, closure, synthesis

Overview

This package provides an Open Educational Resource (OER) to refresh prior knowledge about functional dependencies (FDs) and normalization of relational database schemata. Towards that goal, the package implements algorithms for the manipulation of functional dependencies; the package’s doc string explains the used vocabulary and contains examples.

Selected algorithms:

• FD.rminimize(): Return a minimal cover of r-minimal FDs
• FDSet.closure(): Return closure of attributes under given FDs
• FDSet.lminimize(): Return minimum subset of lhs that determines rhs
• FDSet.key(): Return a key
• FDSet.basis(): Return non-redundant r- and l-minimal basis
• RelSchema.synthesize(): Normalize via synthesis into set of 3NF schemata

Side goal

Besides, the package may serve as sample Python code that respects usual coding conventions, which are checked with pre-commit hooks. The configuration file .pre-commit-config.yaml specifies test tools used here.

Origin of code

The code here is based on that file, which will not be maintained any longer.

Changelog

Changelog information is based on Keep a Changelog, where version numbers adhere to Semantic Versioning.

[1.0.0] - 2020-12-22

No change in functionality.

[1.0.0-rc.1] - 2020-12-22

Initial release. Code from there packaged for independent distribution.