An implementation of domains and keys in SQL : a thesis presented in fulfilment of the requirements for the degree Master of Philosophy at Massey University

Simple item page
dc.contributor.authorAlexander, John Lindsay
dc.date.accessioned2016-08-21T22:49:04Z
dc.date.available2016-08-21T22:49:04Z
dc.date.issued1987
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.identifier.urihttp://hdl.handle.net/10179/8549
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
massey.contributor.authorAlexander, John Lindsayen_US
thesis.degree.disciplinePhilosophyen_US
thesis.degree.grantorMassey Universityen_US
thesis.degree.levelMastersen_US
thesis.degree.nameMaster of Philosophy (M. Phil.)en_US
Files
Original bundle
Now showing 1 - 2 of 2
Thumbnail Image
Name:
01_front.pdf
Size:
606.45 KB
Format:
Adobe Portable Document Format
Description:
Download
Thumbnail Image
Name:
02_whole.pdf
Size:
25.39 MB
Format:
Adobe Portable Document Format
Description:
Download
License bundle
Now showing 1 - 1 of 1
Thumbnail Image
Name:
license.txt
Size:
804 B
Format:
Item-specific license agreed upon to submission
Description:
Download
Collections
Theses and Dissertations