Book List

I have a list of books that I want to import into a DB, so I can sort them, group them, and just generally use them as sample data. This doesn't seem like it should be that big of a deal.

Right?

Okay, well, perhaps the list is a little unscrubbed because I both pulled some entries from the Internets and hand entered some others into this list. Still, it shouldn't be that big of a deal, right?

Ha! You'd like to think so, wouldn't you?

So, the simple version of the project plan looks like this:

1. Take multiple files, filled with some combination of

• Author
• Title
• Other Spacing / Whitespace

1. Import said files into a SQL 2008 DB
2. Validate that authors are really authors, titles are really titles
3. Run a single select to indicate the distinct list of books in the set
4. BONUS: Add a column indicating ownership status
5. BONUS: Add a column indicating "have read" status