Show simple item record

dc.contributor.authorAlexander, John Lindsay
dc.date.accessioned2016-08-21T22:49:04Z
dc.date.available2016-08-21T22:49:04Z
dc.date.issued1987
dc.identifier.urihttp://hdl.handle.net/10179/8549
dc.description.abstractThe relational Data Base Management System model has steadily acquired increasing acceptance over the years since it was first introduced in 1970, yet few – if any – of the many relational products currently available support the fundamental concepts of domains and the integrity constraints of primary and foreign keys. Over more recent years the SQL Relational Database Sub-Language has found most favour among users and vendors alike, and a standard for SQL has recently been produced. This standard provides no support for domains or foreign keys, and only indirect support for primary keys. This thesis first reviews MURDER, the relational dabatase management system used for teaching purposes at Massey, and then describes an implementation of the domain and key concepts, highlighting some of the problem areas still to be resolved. Also described is an implementation of the query and update facilities of SQL, including some extensions which it is claimed increase its functionality. Finally, refinements to the language definition are suggested, to remove some redundancies and ambiguities.en_US
dc.language.isoenen_US
dc.publisherMassey Universityen_US
dc.rightsThe Authoren_US
dc.subjectRelational databasesen_US
dc.subjectSQL (Computer program language)en_US
dc.titleAn implementation of domains and keys in SQL : a thesis presented in fulfilment of the requirements for the degree Master of Philosophy at Massey Universityen_US
dc.typeThesisen_US
thesis.degree.disciplinePhilosophyen_US
thesis.degree.grantorMassey Universityen_US
thesis.degree.levelMastersen_US
thesis.degree.nameMaster of Philosophy (M. Phil.)en_US


Files in this item

Icon
Icon

This item appears in the following Collection(s)

Show simple item record