Please complete the Library Practice Database Design Problem at the bottom of page 11

Imagine that your town library wants to keep track of its business in a database, and that you have been called in to build the database. You talk to the town librarian, review the old paper-based records, and watch people use the library for a few days. You learn the following about the library: 1. Any resident of the town can get a library card simply by asking for one. The library considers each cardholder a member of the library 2. The librarian wants to be able to contact members by telephone and by email. She calls mem- bers when books are overdue or when requested materials become available. She likes to email a thank-you note to each patron on his or her anniversary of becoming a member of the library. Without a database, contacting members efticiently can be difficult; for example, multiple mem- bers can have the same name. Also, a parent and a child might have the same first and last name, live at the same address, and share a phone. 3. The librarian tries to keep track of each member's reading interests. When new books come in, the librarian alerts members whose interests match those books. For example, long-time member Sue Doaks is interested in reading Western novels, growing orchids, and baking bread. There must be some way to match her interests with available books. One complication is that, although the librarian wants to track all of a member's reading interests, she wants to classify each book as being in just one category of interest. For example, the classic gardening book Orchids of France would be classified as a book about orchids or a book about France, but not both.