Abstract: In this project, students use a real-world, complicated database and experience firsthand the consequences of inadequate data modeling. The database used in this project was the result of a multimillion dollar data collection effort undertaken by the U.S. Environmental Protection Agency in order to set limits on emissions of air pollutants from electric power plants. First, students explore the database to identify design limitations from the perspective of a data analyst. Second, students create a new database design which overcomes identified problems. In this case study, students will develop the skill to infer usage implications by studying the design of an existing database. We believe that this skill is valuable but is different from the skill of designing a database from scratch.
Keywords: database design, Systems Analysis and Design
Download this article: ISEDJ - V12 N5 Page 4.pdf
Recommended Citation: Donalds, K., LIU, X. (2014). Cleaning Data Helps Clean the Air. Information Systems Education Journal, 12(5) pp 4-15. http://isedj.org/2014-12/ ISSN: 1545-679X. (A preliminary version appears in The Proceedings of ISECON 2013)