{"id":{"repo_id":"mcmaster","oai_identifier":"oai:macsphere.mcmaster.ca:11375/11862"},"canonical_url":"https://search.ndltd.org/etd/mcmaster/oai:macsphere.mcmaster.ca:11375/11862","repository":{"repo_id":"mcmaster","name":"McMaster University","base_url":"https://macsphere.mcmaster.ca/server/oai/request"},"display":{"title":"A Suite of Case Studies in Relational Database Design","abstract":"<p>Typical relational database design examples in textbooks and undergraduate courses are small and do not provide any real opportunity to practice the design, they simply illustrate and illuminate the principles. On the other end of the spectrum are typical industrial databases whose designs are complex and extensive, and so not suitable as a project for a one term database course. The objective of this thesis is to design and develop a collection of ten projects that would be usable as term projects in relational database system design for a typical undergraduate database course. To this end a suite of ten case studies are presented. Each project is taken from its informal specification to a relational schema using entity-relationship modeling and its translation to relational model, to database schema, to implementation of the database, to interactive SQL querying of the installed database and finished with a simple application programmed in C using the installed database and accessing it via embedded SQL.</p>","abstract_html":"&lt;p&gt;Typical relational database design examples in textbooks and undergraduate courses are small and do not provide any real opportunity to practice the design, they simply illustrate and illuminate the principles. On the other end of the spectrum are typical industrial databases whose designs are complex and extensive, and so not suitable as a project for a one term database course. The objective of this thesis is to design and develop a collection of ten projects that would be usable as term projects in relational database system design for a typical undergraduate database course. To this end a suite of ten case studies are presented. Each project is taken from its informal specification to a relational schema using entity-relationship modeling and its translation to relational model, to database schema, to implementation of the database, to interactive SQL querying of the installed database and finished with a simple application programmed in C using the installed database and accessing it via embedded SQL.&lt;/p&gt;","abstract_has_math":false,"creators":["Zhang, Weiguang"],"institution":null,"degree_name":null,"degree_level":null,"degree_discipline":null,"degree_department":"Computing and Software","school":null,"contributors":[],"advisors":["Deza, Antoine","Franek, Frantisek"],"committee_chairs":[],"committee_members":[],"year":2012,"date_issued":"2012-04","date_published":"2012-04","updated_at":"2026-11-18T19:38:03Z","subjects":[],"languages":[],"rights":[],"rights_urls":[],"identifier_entries":[{"key":"dc:identifier.uri","label":"Identifier URI","values":["https://doi.org/10.71548/19843"],"render_values":[{"text":"https://doi.org/10.71548/19843","href":"https://doi.org/10.71548/19843","code":true}]},{"key":"dc:identifier.other","label":"Dc Identifier Other","values":["opendissertations/6798","7822","2469335"],"render_values":[{"text":"opendissertations/6798","href":null,"code":true},{"text":"7822","href":null,"code":true},{"text":"2469335","href":null,"code":true}]}],"person_identifier_entries":[]},"links":{"outbound_url":"http://hdl.handle.net/11375/11862","outbound_label":"Handle","outbound_source":"dc:identifier.uri","record_url":"http://hdl.handle.net/11375/11862","record_label":"Repository record","record_kind":"handle","record_source":"dc:identifier.uri","download_url":null,"download_label":null,"download_source":null,"access_status":null,"embargo_until":null,"access_note":null},"source_record":{"url":"https://macsphere.mcmaster.ca/server/oai/request?verb=GetRecord&metadataPrefix=dim&identifier=oai%3Amacsphere.mcmaster.ca%3A11375%2F11862","prefix":"dim"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:contributor.advisor","label":"Advisor","values":["Deza, Antoine","Franek, Frantisek"]},{"key":"dc:contributor.department","label":"Department","values":["Computing and Software"]},{"key":"dc:creator","label":"Author","values":["Zhang, Weiguang"]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"dc:date.accessioned","label":"Dc Date Accessioned","values":["2014-06-18T16:57:12Z"]},{"key":"dc:date.available","label":"Dc Date Available","values":["2014-06-18T16:57:12Z"]},{"key":"dc:date.created","label":"Dc Date Created","values":["2012-01-24"]},{"key":"dc:date.issued","label":"Date","values":["2012-04"]},{"key":"dc:type","label":"Dc Type","values":["thesis"]}]},{"id":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier.other","label":"Dc Identifier Other","values":["opendissertations/6798","7822","2469335"]},{"key":"dc:identifier.uri","label":"Identifier URI","values":["http://hdl.handle.net/11375/11862","https://doi.org/10.71548/19843"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description.abstract","label":"Abstract","values":["<p>Typical relational database design examples in textbooks and undergraduate courses are small and do not provide any real opportunity to practice the design, they simply illustrate and illuminate the principles. On the other end of the spectrum are typical industrial databases whose designs are complex and extensive, and so not suitable as a project for a one term database course. The objective of this thesis is to design and develop a collection of ten projects that would be usable as term projects in relational database system design for a typical undergraduate database course. To this end a suite of ten case studies are presented. Each project is taken from its informal specification to a relational schema using entity-relationship modeling and its translation to relational model, to database schema, to implementation of the database, to interactive SQL querying of the installed database and finished with a simple application programmed in C using the installed database and accessing it via embedded SQL.</p>"]},{"key":"dc:description.degree","label":"Dc Description Degree","values":["Master of Science (MSc)"]},{"key":"dc:title","label":"Title","values":["A Suite of Case Studies in Relational Database Design"]},{"key":"others:access_status","label":"Others Access Status","values":["open.access"]}]}],"canonical_facts":{"dc:contributor.advisor":["Deza, Antoine","Franek, Frantisek"],"dc:contributor.department":["Computing and Software"],"dc:creator":["Zhang, Weiguang"],"dc:date.accessioned":["2014-06-18T16:57:12Z"],"dc:date.available":["2014-06-18T16:57:12Z"],"dc:date.created":["2012-01-24"],"dc:date.issued":["2012-04"],"dc:description.abstract":["<p>Typical relational database design examples in textbooks and undergraduate courses are small and do not provide any real opportunity to practice the design, they simply illustrate and illuminate the principles. On the other end of the spectrum are typical industrial databases whose designs are complex and extensive, and so not suitable as a project for a one term database course. The objective of this thesis is to design and develop a collection of ten projects that would be usable as term projects in relational database system design for a typical undergraduate database course. To this end a suite of ten case studies are presented. Each project is taken from its informal specification to a relational schema using entity-relationship modeling and its translation to relational model, to database schema, to implementation of the database, to interactive SQL querying of the installed database and finished with a simple application programmed in C using the installed database and accessing it via embedded SQL.</p>"],"dc:description.degree":["Master of Science (MSc)"],"dc:identifier.other":["opendissertations/6798","7822","2469335"],"dc:identifier.uri":["http://hdl.handle.net/11375/11862","https://doi.org/10.71548/19843"],"dc:title":["A Suite of Case Studies in Relational Database Design"],"dc:type":["thesis"],"others:access_status":["open.access"]},"updated_at":"2026-11-18T19:38:03Z"}