Abstract: This case consists of a business scenario of a small video rental store – Home Theater Video, which provides background information, a description of the functional business requirements, and sample data. The case provides sufficient information to design and develop a moderately complex database to assist Home Theater Video in solving their management problem. Students should be able to create an Access database, populated with data, develop a series of queries, forms, reports, a switchboard, and execute pivot tables that satisfy the functional requirements given by the video store. Teaching notes containing suggested implementation guidelines, suggested deliverables, and the resulting database containing the required queries, forms, reports, switchboard, and pivot tables are provided.

Keywords:

Download this article: ISEDJ - V10 N2 Page 55.pdf

Recommended Citation: Ballenger, R. M., Pratt, R. (2012). A Database Design and Development Case: Home Theater Video . Information Systems Education Journal, 10(2) pp 55-64. http://isedj.org/2012-10/ ISSN: 1545-679X. (A preliminary version appears in The Proceedings of ISECON 2011)