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. http://isedj.org/2018-16/ ISSN: 1545-679X. (A preliminary version appears in The Proceedings of EDSIGCON 2017)