ISEDJ

Information Systems Education Journal

Volume 14

V14 N2 Pages 58-63

March 2016

Teaching Case

Front-End and Back-End Database Design and Development: Scholar’s Academy Case Study

Rachida F. Parks
University of Arkansas at Little Rock
Little Rock, AR 72204, USA

Chelsea Hall
University of Arkansas at Little Rock
Little Rock, AR 72204, USA


Abstract: This case study consists of a real database project for a charter school – Scholar’s Academy – and provides background information on the school and its cafeteria processing system. Also included are functional requirements, and some illustrative data. Students are tasked with the design and development of a database for the purpose of improving the current process of keeping track of students’ meals. Skills to be learned include logical database modeling and design, physical design and implementation using both ACCESS (front end) and SQL Server (back end) Databases. Queries, forms and reports are to be developed in ACCESS while the tables will be created in SQL Server. This Case study targets students with no prior programming or database experience. However, more advanced students can further explore the intricacies of an enterprise level database management system (e.g., SQL Server).

Keywords: Teaching Case, Database Management, SQL Server, Access

Download this article: ISEDJ - V14 N2 Page 58.pdf

Recommended Citation: Parks, R. F., Hall, C. (2016). Front-End and Back-End Database Design and Development: Scholar’s Academy Case Study. Information Systems Education Journal, 14(2) pp 58-63. http://isedj.org/2016-14/ ISSN: 1545-679X. (A preliminary version appears in The Proceedings of EDSIG 2015)