Transforming N-ary relationships to database schemas: an old and forgotten problem

The N-ary relationships, have been traditionally a source of confusion and still are. One important source of confusion is that the term cardinality in a relationship has several interpretations, two of them being very popular. But none of the two approaches, nor the two together, allow us to expres...

Descripción completa

Detalles Bibliográficos
Autor: Camps Pare, Rafael
Tipo de recurso: informe técnico
Fecha de publicación:2002
País:España
Institución:Universitat Politècnica de Catalunya (UPC)
Repositorio:UPCommons. Portal del coneixement obert de la UPC
Idioma:inglés
OAI Identifier:oai:upcommons.upc.edu:2117/97601
Acceso en línea:https://hdl.handle.net/2117/97601
Access Level:acceso abierto
Palabra clave:N-ary relationships
Cardinality
Database schemas
Relational database design
Functional dependencies
UML
SQL.
Àrees temàtiques de la UPC::Informàtica
id ES_8c7d3bd2adaa02c22c51d1f1df73ff7c
oai_identifier_str oai:upcommons.upc.edu:2117/97601
network_acronym_str ES
network_name_str España
repository_id_str
spelling Transforming N-ary relationships to database schemas: an old and forgotten problemCamps Pare, RafaelN-ary relationshipsCardinalityDatabase schemasRelational database designFunctional dependenciesUMLSQL.Àrees temàtiques de la UPC::InformàticaThe N-ary relationships, have been traditionally a source of confusion and still are. One important source of confusion is that the term cardinality in a relationship has several interpretations, two of them being very popular. But none of the two approaches, nor the two together, allow us to express all the possible cardinality patterns. The transformations from all the possible relationships to database schemas have never been described by the existing literature. Using the 14 ternary patterns as example, we discuss these transformations particularly the transformations from the patterns ignored in the literature.20022002-02-0120162016-12-01reporthttp://purl.org/coar/resource_type/c_93fcVoRhttp://purl.org/coar/version/c_970fb48d4fbd8a85info:eu-repo/semantics/reportapplication/pdfhttps://hdl.handle.net/2117/97601reponame:UPCommons. Portal del coneixement obert de la UPCinstname:Universitat Politècnica de Catalunya (UPC)Inglésengopen accesshttp://purl.org/coar/access_right/c_abf2info:eu-repo/semantics/openAccessoai:upcommons.upc.edu:2117/976012026-05-27T15:37:01Z
dc.title.none.fl_str_mv Transforming N-ary relationships to database schemas: an old and forgotten problem
title Transforming N-ary relationships to database schemas: an old and forgotten problem
spellingShingle Transforming N-ary relationships to database schemas: an old and forgotten problem
Camps Pare, Rafael
N-ary relationships
Cardinality
Database schemas
Relational database design
Functional dependencies
UML
SQL.
Àrees temàtiques de la UPC::Informàtica
title_short Transforming N-ary relationships to database schemas: an old and forgotten problem
title_full Transforming N-ary relationships to database schemas: an old and forgotten problem
title_fullStr Transforming N-ary relationships to database schemas: an old and forgotten problem
title_full_unstemmed Transforming N-ary relationships to database schemas: an old and forgotten problem
title_sort Transforming N-ary relationships to database schemas: an old and forgotten problem
dc.creator.none.fl_str_mv Camps Pare, Rafael
author Camps Pare, Rafael
author_facet Camps Pare, Rafael
author_role author
dc.subject.none.fl_str_mv N-ary relationships
Cardinality
Database schemas
Relational database design
Functional dependencies
UML
SQL.
Àrees temàtiques de la UPC::Informàtica
topic N-ary relationships
Cardinality
Database schemas
Relational database design
Functional dependencies
UML
SQL.
Àrees temàtiques de la UPC::Informàtica
description The N-ary relationships, have been traditionally a source of confusion and still are. One important source of confusion is that the term cardinality in a relationship has several interpretations, two of them being very popular. But none of the two approaches, nor the two together, allow us to express all the possible cardinality patterns. The transformations from all the possible relationships to database schemas have never been described by the existing literature. Using the 14 ternary patterns as example, we discuss these transformations particularly the transformations from the patterns ignored in the literature.
publishDate 2002
dc.date.none.fl_str_mv 2002
2002-02-01
2016
2016-12-01
dc.type.none.fl_str_mv report
http://purl.org/coar/resource_type/c_93fc
VoR
http://purl.org/coar/version/c_970fb48d4fbd8a85
dc.type.openaire.fl_str_mv info:eu-repo/semantics/report
format report
dc.identifier.none.fl_str_mv https://hdl.handle.net/2117/97601
url https://hdl.handle.net/2117/97601
dc.language.none.fl_str_mv Inglés
eng
language_invalid_str_mv Inglés
language eng
dc.rights.none.fl_str_mv open access
http://purl.org/coar/access_right/c_abf2
dc.rights.openaire.fl_str_mv info:eu-repo/semantics/openAccess
rights_invalid_str_mv open access
http://purl.org/coar/access_right/c_abf2
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.source.none.fl_str_mv reponame:UPCommons. Portal del coneixement obert de la UPC
instname:Universitat Politècnica de Catalunya (UPC)
instname_str Universitat Politècnica de Catalunya (UPC)
reponame_str UPCommons. Portal del coneixement obert de la UPC
collection UPCommons. Portal del coneixement obert de la UPC
repository.name.fl_str_mv
repository.mail.fl_str_mv
_version_ 1869412937343434753
score 15,300719

Similares en LA Referencia