Lucky Leprechaun Players Club: a database design case
by Siva Sankaran; Thomas Wedel
International Journal of Teaching and Case Studies (IJTCS), Vol. 5, No. 3/4, 2014

Abstract: The importance of case studies as part of an active learning approach for teaching systems analysis and database design in information system classes has long been recognised. Appropriate case studies challenge students to think analytically and apply information systems theory and practice to real-world situations. This paper presents a case study that assists students in perfecting their data flow diagram development and data modelling skills. Students utilise their data flow analysis and modelling skills to develop an appropriate database design for a fictional casino. Student deliverables include data flow and entity-relationship diagrams, data dictionary and normalised tables. A symbol in the form of a clock-face is proposed as a useful approach to represent time-triggered processes along with how such processes can be described in a data dictionary. Student feedback indicates that the case is realistic, engaging and challenging without being excessively complex.

Online publication date: Thu, 26-Feb-2015

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.

Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Teaching and Case Studies (IJTCS):
Login with your Inderscience username and password:

    Username:        Password:         

Forgotten your password?

Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.

If you still need assistance, please email