Assignment Summary

Use LucidChart and ERD to complete the practice database design problem at then end of Tutorial A, Page 11, Problem Solving Cases When Your ERD model is complete, post a shareable link (URL) to your LucidChart document Use the text tool in LucidChart to narrate or describe any assumptions or design information you feel appropriate Note clarity, organization and easy legibility are important to this exercise and will be part of your grade No printouts are required for this assignment Assignment Details and Requirements

At the top left of your ERD document Line 1 - LastName, FirstName Line 2- Your SLU-based email Line 3 - BTM2500-01 Following the discussion and example from lecture, build a representative model of the library data model using ERD Create a New LucidChart Document Create an ERD diagram to model the data provided Identify and Properly Name Entities Identify and Properly Name Attributes (Fields) of the Entities Identify Primary Keys Identify Foreign Keys Establish Relationships showing maximum and minimum cardinalities On your document include, include concise text annotations sufficient to document your assumptions, decisions, etc. When complete, use File / Share Document, Choose Link Upload the shareable URL to the assignment link

PRACTICE DATABASE DESIGN PROBLEM

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 efficiently 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 members 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 members 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.