article

Functional dependencies and constraints on Null values in database relations

Authors:

Paolo Atzeni,

Nicola M MorfuniAuthors Info & Claims

Information and Control, Volume 70, Issue 1

Pages 1 - 31

https://doi.org/10.1016/S0019-9958(86)80022-5

Published: 01 July 1986 Publication History

Abstract

No abstract available.

Cited By

View all

Zhang ZLink S(2024)Mixed Covers of Keys and Functional Dependencies for Maintaining the Integrity of Data under UpdatesProceedings of the VLDB Endowment10.14778/3654621.365462617:7(1578-1590)Online publication date: 1-Mar-2024
https://dl.acm.org/doi/10.14778/3654621.3654626
Link S(2023)Entity integrity management under data volume, variety and veracityKnowledge and Information Systems10.1007/s10115-022-01814-165:7(2895-2934)Online publication date: 25-Jan-2023
https://dl.acm.org/doi/10.1007/s10115-022-01814-1
Wei ZLink S(2021)Embedded Functional Dependencies and Data-completeness Tailored Database DesignACM Transactions on Database Systems10.1145/345051846:2(1-46)Online publication date: 29-May-2021
https://dl.acm.org/doi/10.1145/3450518
Show More Cited By

Index Terms

Functional dependencies and constraints on Null values in database relations
1. Information systems
  1. Data management systems
2. Software and its engineering
  1. Software notations and tools
    1. Context specific languages
  2. Software organization and properties
    1. Contextual software domains
      1. Operating systems
        Process management

Recommendations

Functional dependencies with null values, fuzzy values, and crisp values

Based on the concepts of the semantic proximity, we present a definition of the fuzzy functional dependency, We show that the inference rules for fuzzy functional dependencies, which are the same as Armstrong's axioms for the crisp case, are correct and ...
A complete axiomatization for functional and multivalued dependencies in database relations
SIGMOD '77: Proceedings of the 1977 ACM SIGMOD international conference on Management of data

We investigate the inference rules that can be applied to functional and multivalued dependencies that exist in a database relation. Three types of rules are discussed. First, we list the well known rules for functional dependencies. Then we investigate ...
Synthesizing third normal form relations from functional dependencies

It has been proposed that the description of a relational database can be formulated as a set of functional relationships among database attributes. These functional relationships can then be used to synthesize algorithmically a relational scheme. It is ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

Information and Control Volume 70, Issue 1

July 1986

95 pages

ISSN:0019-9958

Editor:
Albert R Meyer

Issue’s Table of Contents

Publisher

Academic Press Professional, Inc.

United States

Publication History

Published: 01 July 1986

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

42
Total Citations
View Citations
0
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 21 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Zhang ZLink S(2024)Mixed Covers of Keys and Functional Dependencies for Maintaining the Integrity of Data under UpdatesProceedings of the VLDB Endowment10.14778/3654621.365462617:7(1578-1590)Online publication date: 1-Mar-2024
https://dl.acm.org/doi/10.14778/3654621.3654626
Link S(2023)Entity integrity management under data volume, variety and veracityKnowledge and Information Systems10.1007/s10115-022-01814-165:7(2895-2934)Online publication date: 25-Jan-2023
https://dl.acm.org/doi/10.1007/s10115-022-01814-1
Wei ZLink S(2021)Embedded Functional Dependencies and Data-completeness Tailored Database DesignACM Transactions on Database Systems10.1145/345051846:2(1-46)Online publication date: 29-May-2021
https://dl.acm.org/doi/10.1145/3450518
Kossmann JPapenbrock TNaumann F(2021)Data dependencies for query optimization: a surveyThe VLDB Journal — The International Journal on Very Large Data Bases10.1007/s00778-021-00676-331:1(1-22)Online publication date: 14-Jun-2021
https://dl.acm.org/doi/10.1007/s00778-021-00676-3
Birnick JBläsius TFriedrich TNaumann FPapenbrock TSchirneck M(2020)Hitting set enumeration with partial information for unique column combination discoveryProceedings of the VLDB Endowment10.14778/3407790.340782413:12(2270-2283)Online publication date: 14-Sep-2020
https://dl.acm.org/doi/10.14778/3407790.3407824
Wei ZLink S(2019)Embedded functional dependencies and data-completeness tailored database designProceedings of the VLDB Endowment10.14778/3342263.334262612:11(1458-1470)Online publication date: 1-Jul-2019
https://dl.acm.org/doi/10.14778/3342263.3342626
Lehmberg OBizer CAkerkar RJung J(2019)Synthesizing N-ary Relations from Web TablesProceedings of the 9th International Conference on Web Intelligence, Mining and Semantics10.1145/3326467.3326480(1-12)Online publication date: 26-Jun-2019
https://dl.acm.org/doi/10.1145/3326467.3326480
Niewerth MSchwentick T(2018)Reasoning About XML Constraints Based on XML-to-Relational MappingsTheory of Computing Systems10.1007/s00224-018-9846-562:8(1826-1879)Online publication date: 1-Nov-2018
https://dl.acm.org/doi/10.1007/s00224-018-9846-5
Koehler HLink S(2017)Inclusion dependencies and their interaction with functional dependencies in SQLJournal of Computer and System Sciences10.1016/j.jcss.2016.11.00485:C(104-131)Online publication date: 1-May-2017
https://dl.acm.org/doi/10.1016/j.jcss.2016.11.004
Köhler HLink SÖzcan FKoutrika GMadden S(2016)SQL Schema DesignProceedings of the 2016 International Conference on Management of Data10.1145/2882903.2915239(267-279)Online publication date: 26-Jun-2016
https://dl.acm.org/doi/10.1145/2882903.2915239
Show More Cited By

View Options

View options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Abstract

Cited By

Index Terms

Recommendations

Functional dependencies with null values, fuzzy values, and crisp values

A complete axiomatization for functional and multivalued dependencies in database relations

Synthesizing third normal form relations from functional dependencies

Comments

Information

Published In

Publisher

Publication History

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

View options

Login options

Full Access

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations