Live briefing
Everything about Functional dependency
Relational database theory concept
In relational database theory, a functional dependency (FD) is constraint between two attribute sets, whereby values in one set determine the values of the other set. A functional dependency between a determinant set X and a dependent set Y can be described as follows: Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Functional dependencyA 5-minute orientation
- Skim a recent paper: Plant Protein versus Dairy Proteins: A pH-Dependency Investigation on Their Structure and Functional PropertiesInfluential work since 2022
- Pick up a classic book: Reconnecting languageThe most-reprinted book on the subject
- Read the landmark paper: Density-Functional Theory for Time-Dependent SystemsCited 8,570 times
- Go sideways: Relational modelA closely related topic
- Go sideways: Chase (algorithm)A closely related topic
📖 Definitions
Noun Given a relation R and two sets of attributes X,Y⊆R, a constraint X→Y where each X value in R is associated with precisely one Y value in R.
🏆 Landmark papers (most cited)
Density-Functional Theory for Time-Dependent Systems
Treatment of electronic excitations within the adiabatic approximation of time dependent density functional theory
Functional dependency discovery
Newly Reported Chronic Conditions and Onset of Functional Dependency
Scale dependency and functional response in moose habitat selection
Graph Algorithms for Functional Dependency Manipulation
Mining conditional functional dependency rules on big data
Using Dependency Structures for Prioritization of Functional Test Suites
🆕 Influential since 2022
Plant Protein versus Dairy Proteins: A pH-Dependency Investigation on Their Structure and Functional Properties
Predicting functional dependency using machine learning among a middle-aged and older Chinese population
Extreme temperature events, functional dependency, and cardiometabolic multimorbidity: Insights from a national cohort study in China
Functional convergence underground? The scale‐dependency of community assembly processes in European cave spiders
Nucleotide dependency analysis of genomic language models detects functional elements
📚 Books worth reading
Reconnecting languageA. M. Simon-Vandenbergen, Kristin Davidse · 1997- 📕[Computational modeling of properties]Judy R. Franz · 1994
- 📕Dependent types and explicit substitutionsCésar Muñoz · 1999
- 📕Studies of the intrinsic complexities of magnetotail ion distributionsMaha Ashour-Abdalla · 1998
- 📕The large discretization step method for time-dependent partial differential equationsZigo Haras · 1995
Mandatory Package College Algebra with Trigonometry with Smart CD (Mac)Raymond A. Barnett, Michael R. Ziegler · 2000
Mandatory Package College Algebra with Trigonometry with Smart CD (Windows)Raymond A. Barnett, Michael R. Ziegler · 2000- 📕Random MatricesAlexei Borodin, Ivan Corwin · 2020
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Relational model The relational model (RM) is an approach to managing data using a structure and language consistent with first-order predicate logic, first described in…
- Chase (algorithm) The chase is a simple fixed-point algorithm testing and enforcing implication of data dependencies in database systems. It plays important roles in database…
- Armstrong's axioms Armstrong's axioms are a set of axioms (or, more precisely, inference rules) used to infer all the functional dependencies on a relational database. They…
- Third normal form Third normal form (3NF) is a level of database normalization defined by English computer scientist Edgar F. Codd. A relation (or table, in SQL) is in third…
- Multivalued dependency In database theory, a multivalued dependency is a full constraint between two sets of attributes in a relation. In contrast to the functional dependency…
- Candidate key A candidate key, or simply a key, of a relational database is any set of columns that have a unique combination of values in each row, with the additional…
- Fourth normal form Fourth normal form (4NF) is a normal form used in database normalization. Introduced by Ronald Fagin in 1977, 4NF is the next level of normalization after…
- Lift (mathematics) In category theory, a branch of mathematics, given a morphism f: X → Y and a morphism g: Z → Y, a lift or lifting of f to Z is a morphism h: X → Z such…