SQL/N AND MODES OF ASSOCIATION IN RELATIONAL DATA BASES

Simple item page
dc.contributor.authorBradley, Jameseng
dc.date.accessioned2008-02-27T22:57:17Z
dc.date.available2008-02-27T22:57:17Z
dc.date.computerscience1999-05-27eng
dc.date.issued1984-04-01eng
dc.description.abstractNon cyclic associations in relational data bases are classified into primitive and non primitive associations. A primitive association exists between a pair of relations if an association formula 0 holds, and involves only attributes from these relations. A non primitive association requires the association formula to involve attributes from intermediate relations in addition. Primitive associations comprise primary, secondary and generalized associations. Primary associations lead to FDs, secondary associations to embedded MVDs, and generalized associations to generalized dependencies. Non primitive associations comprise 1:n, n:m, and obscure associations. For any association class it is possible to define one or more association modes using either biconditional or implicational mode generators. Six types of associative conditions are defined on the basis of how associations are used in natural languages. Two types of associative conditions permit the use of natural quantifiers. SQL/N permits all six types of conditions. Association modes permit specification of any class of association with the associative conditions allowed in SQL/N. SQL/N is an extended version of SQL that is upward compatible with it. SQL does not permit all six associative condition types with any association.eng
dc.description.notesWe are currently acquiring citations for the work deposited into this collection. We recognize the distribution rights of this item may have been assigned to another entity, other than the author(s) of the work.If you can provide the citation for this work or you think you own the distribution rights to this work please contact the Institutional Repository Administrator at digitize@ucalgary.caeng
dc.identifier.department1984-145-3eng
dc.identifier.doihttp://dx.doi.org/10.11575/PRISM/30465
dc.identifier.urihttp://hdl.handle.net/1880/46270
dc.language.isoEngeng
dc.publisher.corporateUniversity of Calgaryeng
dc.publisher.facultyScienceeng
dc.subjectComputer Scienceeng
dc.titleSQL/N AND MODES OF ASSOCIATION IN RELATIONAL DATA BASESeng
dc.typeunknown
thesis.degree.disciplineComputer Scienceeng
Files
License bundle
Now showing 1 - 1 of 1
Thumbnail Image
Name:
license.txt
Size:
1.86 KB
Format:
Plain Text
Description:
Download
Collections
Science Research & Publications