Information Systems Education Journal

Volume 16

V16 N2 Pages 18-24

April 2018

Dragon Air: A Database Design Case

Donald Edward Wynn
University of Dayton
Dayton, OH 45469, USA

Abstract: This case describes a real-world scenario based on a fictional new commuter airline seeking to develop a database to support their operations. Students are asked to design and develop a database to allow the airline to track flights, passengers, bookings, and more, based on a set of business rules, default data, and other requirements. The case is designed to be a relatively stringent test of the group’s abilities, with significant detail included in the case materials, along with a number of challenge tasks for advanced classes, groups, or individuals. The case has been designed for use as a semester-long group project in a Database Management course, focusing on reinforcing the students’ skills in entity relationship diagrams (ERDs) and SQL coding.

Keywords: Database management

Download this article: ISEDJ - V16 N2 Page 18.pdf

Recommended Citation: Wynn, D. E. (2018). Dragon Air: A Database Design Case. Information Systems Education Journal, 16(2) pp 18-24. ISSN: 1545-679X. (A preliminary version appears in The Proceedings of EDSIGCON 2017)