Back to search

McMaster University

A Suite of Case Studies in Relational Database Design

Abstract

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>

Degree

thesis:*
Department dc:contributor.department
Computing and Software
Year dc:date.issued
2012

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Zhang, Weiguang
Advisors dc:contributor.advisor
  • Deza, Antoine
  • Franek, Frantisek

Identifiers

dc:identifier.*
Dc Identifier Other
opendissertations/6798
7822
2469335

Chain of custody

source
Harvested from
McMaster University
Base URL
macsphere.mcmaster.ca/server/oai/request
Last updated
2026-11-18
Source record
OAI-PMH GetRecord
related terms
citation

Zhang, Weiguang. A Suite of Case Studies in Relational Database Design. 2012. http://hdl.handle.net/11375/11862