CD Lending Library

Problem description:

You have built up quite a collection of music CDs, and word has gotten out to your friends (and their friends). While you like sharing your CDs with others—you get satisfaction out of exposing others to your music tastes—you don’t like the hassle of tracking down a long-ago borrowed CD or recommending a CD only to find it missing.

Developing the database:

Often, the greatest challenge of developing a relational database system is deciding how to store the data to avoid redundancy (which maximizes efficiency and prevents many future data inconsistencies) while still providing all the ingredients for the information you might need.