The Proceedings of the Information Systems Education Conference 2002: §354a Home Papers/Indices prev (§354) Next (§354b)

Paper (refereed) IT Education: Best Practices

Recommended Citation: McCoy, R and J Gibson. A Case Study and Model for Database Design for Cost Analysis in Manufacturing. In The Proceedings of the Information Systems Education Conference 2002, v 19 (San Antonio): §354a. ISSN: 1542-7382.

A Case Study and Model for Database Design for Cost Analysis in Manufacturing

Refereed

Randall McCoy    [a1] [a2]
Information Systems Department
Morehead State University    [u1] [u2]
Morehead, Kentucky, USA    [c1] [c2]

John Gibson    [a1] [a2]
Information Systems Department
Morehead State University    [u1] [u2]
Morehead, Kentucky, USA    [c1] [c2]

This paper presents a case study dealing with an actual database development process which was employed by an information systems class to solve a "real-world" manufacturing cost analysis problem. The purpose was to evaluate the manufacturing process and to develop and implement a database application that analyzed production costs. The development process of the application was incorporated into a college-level systems analysis and design course. The outcomes provide a learning experience that demonstrates business problem solving and the use of information technology to answer the problems faced in the manufacturing business world. The paper presents a qualitative case which demonstrates how microcomputer productivity tools are used to store, find, and retrieve information in a manufacturing environment through the use of tables, queries, reports, forms and macro design. The problem and scenario used offers an example case problem that may be utilized in a similar information systems course dealing with database design and development.

Keywords: case problems, database management, database development

Read this refereed paper in Adobe Portable Document (PDF) format. (111 K bytes)
Preview this refereed paper in Plain Text (TXT) format. (15 K bytes)

CDpic
Comments and corrections to
webmaster@isedj.org