This applied database exercise utilizes a scenario-based case study to teach the basics of Microsoft Access and database management in introduction to information systems and introduction to database course. The case includes background information on a start-up business (i.e., Carol's Travel Club), description of functional business requirements,…

Describes a case study approach to teaching database design principles to undergraduate students that is based on a library database. Topics discussed include database management systems, relational models, entity relationship models, many-to-many relationships, normalization, and producing a working database. (three references) (LRW)