On the Satisfiability of Dependency Constraints in Entity-Relationship Schemata
Summary: Recasts ER cardinality-ratio dependency satisfiability as “strong satisfiability,” excluding schemas forcing entities or relationships empty. Characterizes it exactly via feasibility of a linear inequality system and identifies constraint sets causing failure. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Maurizio Lenzerini (Sapienza University)
- 2. Paolo Nobili (Institute of Systems Analysis and Computer Science, National Research Council of Italy)
BibTeX Citation
@article{lenzerini_vldb87,
title = {{On the Satisfiability of Dependency Constraints in Entity-Relationship Schemata}},
author = {Lenzerini, Maurizio and Nobili, Paolo},
journal = {PVLDB},
series = {{VLDB} '87},
pages = {147},
year = {1987}
}Incoming Citations (Sorted by Pagerank)
Showing 2 of 2 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 9,985 | Projection-Compliant Database Generation | 2022 | VLDB | 5.1842045e-05 |
| 13,140 | A Deductive Method for Entity-Relationship Modeling (Extended Abstract) | 1989 | VLDB | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 0 of 0 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 203 | Dependency Inference | 1987 | VLDB |
| 2 | 4,843 | Notions of Dependency Satisfaction | 1982 | PODS |
| 3 | 13,260 | A Systematic Approach to Relational Database Theory | 1982 | SIGMOD |
| 4 | 13,259 | A Theory Of Data Dependencies Over Relational Expressions | 1982 | PODS |
| 5 | 1,630 | On the Decidability of Query Containment under Constraints | 1998 | PODS |
| 6 | 3,222 | Comprehensive Approach to the Design of Relational Database Schemes | 1984 | VLDB |
| 7 | 4,094 | Formal Limits on the Automatic Generation and Maintenance of Integrity Constraints | 1987 | PODS |
| 8 | 3,750 | Dependency Satisfaction in Databases with Incomplete Information | 1984 | VLDB |
| 9 | 874 | On the Decidability and Complexity of Query Answering over Inconsistent and Incomplete Databases | 2003 | PODS |
| 10 | 8,506 | Checking Consistency of Database Constraints: a Logical Basis | 1986 | VLDB |