Show simple item record

dc.contributor.authorStanger, Nigelen_NZ
dc.date.available2011-04-07T03:06:34Z
dc.date.copyright1999-12en_NZ
dc.identifier.citationStanger, N. (1999). Modifications to Smith’s method for deriving normalised relations from a functional dependency diagram (Information Science Discussion Papers Series No. 99/23). University of Otago. Retrieved from http://hdl.handle.net/10523/1105en
dc.identifier.urihttp://hdl.handle.net/10523/1105
dc.description.abstractSmith’s method is a formal technique for deriving a set of normalised relations from a functional dependency diagram (FDD). Smith’s original rules for deriving these relations are incomplete, as they do not fully address the issue of determining the foreign key links between relations. In addition, one of the rules for deriving foreign keys can produce incorrect results, while the other rule is difficult to automate. In this paper are described solutions these issues.en_NZ
dc.format.mimetypeapplication/pdf
dc.publisherUniversity of Otagoen_NZ
dc.relation.ispartofseriesInformation Science Discussion Papers Seriesen_NZ
dc.subjectnormalisationen_NZ
dc.subjectfunctional dependenciesen_NZ
dc.subjectrelational modelen_NZ
dc.subjectdata model translationen_NZ
dc.subject.lcshQA76 Computer softwareen_NZ
dc.titleModifications to Smith’s method for deriving normalised relations from a functional dependency diagramen_NZ
dc.typeDiscussion Paperen_NZ
dc.description.versionUnpublisheden_NZ
otago.bitstream.pages15en_NZ
otago.date.accession2010-11-12 03:22:15en_NZ
otago.schoolInformation Scienceen_NZ
otago.openaccessOpen
otago.place.publicationDunedin, New Zealanden_NZ
dc.identifier.eprints1006en_NZ
otago.school.eprintsDatabase Research Centreen_NZ
otago.school.eprintsInformation Scienceen_NZ
dc.description.referencesArmstrong, W. (1974). Dependency structures of data base relationships, in J. L. Rosenfeld (ed.), IFIP Congress ’74 (Information Processing ’74), North-Holland, Stockholm, Sweden, pp. 580–583. Beeri, C., Fagin, R. and Howard, J. H. (1977). A complete axiomatization for functional and multivalued dependencies in database relations, in D. C. Smith (ed.), 1977 ACM SIGMOD International Conference on Management of Data, ACM, Toronto, Canada, pp. 47–61. Date, C. (1995). An Introduction to Database Systems, sixth edn, Addison-Wesley, Reading, Massachusetts. Elmasri, R. and Navathe, S. B. (1994). Fundamentals of Database Systems, second edn, Benjamin/Cummings, Redwood City, California. Smith, H. C. (1985). Database design: Composing fully normalized tables from a rigorous dependency diagram, Communications of the ACM 28(8): 826–838. Stanger, N. (1999). Using Multiple Representations Within a Viewpoint, PhD thesis, Department of Information Science, University of Otago, Dunedin, New Zealand. Stanger, N. and Pascoe, R. (1997a). Environments for viewpoint representations, in R. Galliers, S. Carlsson, C. Loebbecke, C. Murphy, H. Hansen and R. O’Callaghan (eds), Fifth European Conference on Information Systems (ECIS’97), Vol. I, Cork Publishing, Cork, Ireland, pp. 367–382. Stanger, N. and Pascoe, R. (1997b). Exploiting the advantages of object-oriented programming in the implementation of a database design environment, Information Science Discussion Paper 97/08, Department of Information Science, University of Otago, Dunedin, New Zealand. URL: http://divcom.otago.ac.nz/infosci/publctns/complete/papers/dp9708ns.zip Stanger, N. and Pascoe, R. (1997c). Exploiting the advantages of object-oriented programming in the implementation of a database design environment, Joint 1997 Asia Pacific Software Engineering Conference and International Computer Science Conference (APSEC’97/ICSC’97), IEEE Press, Hong Kong. URL: http://divcom.otago.ac.nz/infosci/darc/publications/APSEC97.pdfen_NZ
otago.relation.number99/23en_NZ
 Find in your library

Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record