One of the fundamental principles of the database approach is that a database allows a
nonredundant, unified representation of all data managed in an organization. This is …

A database design methodology is defined for the design of large relational databases. First,
the data requirements are conceptualized using an extended entity-relationship model, with …

This database theory book provides a focused presentation of the core material on relational
databases, and presents a number of advanced topics in a unified framework. Some of the …

Database Management Systems provides comprehensive and up-to-date coverage of the
fundamentals of database systems. Coherent explanations and practical examples have …

AfSSTRACT: Many real-world situations can be captured by a set of functional
dependencies and a single join dependency of a particular form called acyclic [B..]. The join …

Presented is a computation method—the chase—for testing implication of data
dependencies by a set of data dependencies. The chase operates on tableaux similar to …

A new type of dependency, which includes the well-known functional dependencies as a
special case, is defined for relational databases. By using this concept, a new (“fourth”) …

A class of dependencies, tuple and equality generating dependencies, is defined, and the
chase process is generalized to deal with these dependenetes. For total dependencies the …

Problems related to functional dependencies and the algorithmic design of relational
schemas are examined. Specifically, the following results are presented:(1) a tree model of …

Answering queries in a relational database often requires that the natural join of two or more
relations be computed. However, the result of a join may not be what one expects. In this …