NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
PDF on ERIC Download full text
ERIC Number: EJ1136264
Record Type: Journal
Publication Date: 2016-Mar
Pages: 6
Abstractor: As Provided
ISSN: EISSN-1545-679X
Front-End and Back-End Database Design and Development: Scholar's Academy Case Study
Parks, Rachida F.; Hall, Chelsea A.
Information Systems Education Journal, v14 n2 p58-63 Mar 2016
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).
Information Systems and Computing Academic Professionals. Box 488, Wrightsville Beach, NC 28480. e-mail:; Web site:
Publication Type: Journal Articles; Reports - Research; Tests/Questionnaires
Education Level: Higher Education; Elementary Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A