Data Clean-Up and Management

List of figures

3.1. LibStats data entry form 16

3.2. Entity and relationship model 20

3.3. Possible relationships between entities 21

3.4. Librarians and patrons are related a minimum of zero and a maximum of many to reference service 21

3.5. Entity relationship diagram for LibStats database 23

4.1. Excel spreadsheet summarizing COUNTER Database 3 data 34

4.2. Excel spreadsheet summarizing non-COUNTER- compliant Database 3-type data 35

4.3. Example download showing ISSNs with a space and quote or 'no data' in the field 38

4.4. Example download showing comma delimitation on the title 38

4.5. Example showing scientific notation for a number in a field 38

4.6. Example of downloaded data skewing into multiple columns 39

4.7. Example of XML  ...