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)