ERIC Number: EJ1136264
Record Type: Journal
Publication Date: 2016-Mar
Pages: 6
Abstractor: As Provided
ISBN: N/A
ISSN: EISSN-1545-679X
EISSN: N/A
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).
Descriptors: Database Design, Systems Development, Case Studies, Teaching Methods, Computer Science Education, Case Method (Teaching Technique), Design Requirements, Skill Development, Student Projects, Information Systems, Charter Schools, Elementary School Students
Information Systems and Computing Academic Professionals. Box 488, Wrightsville Beach, NC 28480. e-mail: publisher@isedj.org; Web site: http://isedj.org
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