From ternary relationship to relational tables: a case against common beliefs

All of RECERCAT

To access the full text documents, please follow this link: http://hdl.handle.net/2117/97609

Title:	From ternary relationship to relational tables: a case against common beliefs
Author:	Camps Pare, Rafael
Other authors:	Universitat Politècnica de Catalunya. Departament de Ciències de la Computació
Abstract:	The transformation from n-ary relationships to a relational database schema has never been really fully analyzed. This paper presents one of the several ternary cases ignored by the ER-to-RM literature. The case shows that the following common belief is wrong: Given a set of FDs over a table resulting in a non-3NF situation, it is always possible to obtain a fully equivalent set of 3NF tables, without adding other restrictions than candidate keys and inclusion dependencies.
Subject(s):	-Àrees temàtiques de la UPC::Informàtica -N-ary relationships -ER-to-RM -3NF
Rights:
Document type:	Article - Published version Report
Share: