Carregant...
Carregant...

Vés al contingut (premeu Retorn)

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

Autor
Camps, R.
Tipus d'activitat
Document cientificotècnic
Data
2002-01
Codi
LSI-02-2-R
Repositori
http://hdl.handle.net/2117/97609 Obrir en finestra nova
Resum
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.
Citació
Camps, R. "From ternary relationship to relational tables: a case against common beliefs". 2002.
Paraules clau
3NF, ER-to-RM, N-ary relationships

Participants

  • Camps Pare, Rafael  (autor)

Arxius