Volume 8

Volume 8, Number 25

June 10, 2010

27 pages2021 K bytes

A Database Design and Development Case: NanoTEK Networks

Robert M. Ballenger
Washington and Lee University
Lexington, VA 24450 USA

Abstract: This case provides a real-world project-oriented case study for students enrolled in a management information systems, database management, or systems analysis and design course in which database design and development are taught. The case consists of a business scenario to provide background information and details of the unique operating characteristics of the Marketing Department of NanoTek Networks, a description of the functional business requirements, and sample data. What is unique about this case study is that most of the functional requirements and sample data are presented to the students through a series of business emails. The main business issue presented in the scenario is a rather typical management accounting problem: NanoTek Network’s financial accounting system does not supply sufficient data for the Marketing Department to manage the financial details of their day-to-day operations. The Marketing Department’s functional requirements are somewhat similar to a cost accounting system that a manufacturing job shop would employ. The Marketing Department needs to be able to track costs by the marketing activities associated with specific product promotional campaigns. The case provides sufficient information to design and develop a moderately complex database to assist NanoTek Network’s Marketing Department in solving their management accounting problem.

Keywords: database design, database development, project case

Download this issue:   ISEDJ.8(25).Ballenger.pdf   (Adobe PDF, 27 pages, 2021 K bytes)

Preview the contents:   Ballenger.j.txt   (ASCII txt, 36 K bytes)

Additional Teaching Notes:   http://isedj.org/restricted/

Recommended Citation: Ballenger (2010). A Database Design and Development Case: NanoTEK Networks. Information Systems Education Journal, 8 (25). http://isedj.org/8/25/. ISSN: 1545-679X. (Abstract appears in The Proceedings of ISECON 2009: §2336. ISSN: 1542-7382.)