Abstract: The Remote Services, Inc. (RSI) case is designed as an extensible, database design and implementation project. The case is designed in two primary components: design and implementation. The design component of the case allows students to evaluate a scenario that is similar to a real-world business situation and create an appropriate design strategy. The implementation component of the case provides the students with a related scenario that gives them a completed design to be implemented. Implementation tasks include the creation of tables, loading data, creating views, creating triggers, and coding stored procedures. This allows the instructor to easily separate the design and implementation activities so that students that struggle with the design aspect of the project can start with a "clean slate" for the implementation activities, thus giving the instructor a better chance to assess the students' implementation-oriented skills. The case can be used as a group project exercise. It can also be easily extended to include additional human resources and accounting functions for a more complex case.
Keywords: Database design, Database implementation, Teaching case, SQL, Entity relationship diagram
Download this article: JISE - Volume 19 Number 2, Page 147.pdf
Recommended Citation: Morris, S. A. (2008). Teaching Case: Remote Services, Inc., 19(2), pp. 147-156.