# Automatic Database Normalisation for Data Frames

## Documentation for package ‘autodb’ version 3.3.0

- DESCRIPTION file.
- User guides, package vignettes and other documentation.
- Package NEWS.

## Help Pages

add_lookup | Add attribute lookup relations
attrs | Relational data attributes
attrs<- | Relational data attributes
attrs_order | Relational data attribute order
attrs_order<- | Relational data attribute order
autodb | Create a normalised database from a data frame
autokey | Create a relation from a data frame
autoref | Add foreign key references to a normalised database
create | Create instance of a schema
d2 | Generate D2 input text to plot objects
d2.data.frame | Generate D2 input text to plot a data frame
d2.database | Generate D2 input text to plot databases
d2.database_schema | Generate D2 input text to plot database schemas
d2.relation | Generate D2 input text to plot relations
d2.relation_schema | Generate D2 input text to plot relation schemas
database | Databases
database_schema | Database schemas
decompose | Decompose a data frame based on given normalised dependencies
dependant | Dependants
dependant<- | Dependants
detset | Determinant sets
detset<- | Determinant sets
df_anyDuplicated | Determine Duplicate Elements
df_duplicated | Determine Duplicate Elements
df_equiv | Test data frames for equivalence under row reordering
df_rbind | Combine R Objects by Rows or Columns
df_records | Determine Duplicate Elements
df_unique | Determine Duplicate Elements
discover | Dependency discovery with DFD
discover_keys | Key discovery with MCSS
functional_dependency | Functional dependency vectors
gv | Generate Graphviz input text to plot objects
gv.data.frame | Generate Graphviz input text to plot a data frame
gv.database | Generate Graphviz input text to plot databases
gv.database_schema | Generate Graphviz input text to plot database schemas
gv.relation | Generate Graphviz input text to plot relations
gv.relation_schema | Generate Graphviz input text to plot relation schemas
insert | Insert data
keys | Relational data keys
keys<- | Relational data keys
merge_empty_keys | Merge relation schemas with empty keys
merge_schemas | Merge relation schemas in given pairs
normalise | Create normalised database schemas from functional dependencies
nudge | Nudge meta-analysis data
records | Relational data records
records<- | Relational data records
reduce | Remove relations not linked to the main relations
reduce.database | Remove database relations not linked to the main relations
reduce.database_schema | Remove database schema relations not linked to the given relations
references | Schema references
references<- | Schema references
rejoin | Join a database into a data frame
relation | Relation vectors
relation_schema | Relation schema vectors
remove_extraneous | Remove extraneous components from functional dependencies
rename_attrs | Rename relational data attributes
subrelations | Database subrelations
subschemas | Schema subschemas
synthesise | Synthesise relation schemas from functional dependencies