The Proceedings of the Information Systems Education Conference 2009: §2336 Home Papers/Indices prev (§2334) Next (§2342)

Fri, Nov 6, 11:30 - 11:55, Crystal 3 case

Recommended Citation: Ballenger, R M. A Database Design and Development Case: NanoTEK Networks. In The Proceedings of the Information Systems Education Conference 2009, v 26 (Washington DC): §2336. ISSN: 1542-7382.

A Database Design and Development Case: NanoTEK Networks

Handout

1 page

Robert M. Ballenger    [a1] [a2]
Williams School of Commerce, Economics, and Politics
Washington and Lee University    [u1] [u2]
Lexington, Virginia, USA    [c1] [c2]

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. The case is divided into two deliverables. In the first deliverable students are asked to design a database, convert their conceptual design into a physical database, and populate it with data. Students develop a series of queries, forms, reports and a navigational menu system that satisfies the stated functional requirements of the Marketing Department in deliverable two. Teaching notes contain specific learning objectives, suggested courses in which to use the case, associated MIS and database theory, research methodology, suggested implementation guidelines, a possible entity-relationship model, the resulting physical database structures, and the solution to the queries, forms and reports. An actual Access database is provided.

Read this presentation handout (non-refereed) in Adobe Portable Document (PDF) format. (1 page, 35 K bytes)
Preview this presentation handout (non-refereed) in Plain Text (TXT) format. (2 K bytes)

CDpic
Comments and corrections to
webmaster@isedj.org