This is an example of a real-world applicable case study, which includes background information on a small local business (i.e., TCS), description of functional business requirements, and sample data. Students are asked to design and develop a database to improve the management of the company's customers, products, and purchases by emphasizing…

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)