![]() ![]() The final format has a column for Staff Type and a column for Number of Staff. The table was pivoted across the Librarians, Library Technicians, and Library Assistants columns. ![]() The Library Profile table was originally formatted as an unpivoted table with a column for each staff type, below. ![]() The Library ID field is an ID also used in the Library Profile table.For example, if the Idle Hour Library has two paperback copies and one hardcover copy of a title, there will be two Loan IDs. LoanID is a unique identifier for the combination of ISBN and library that is used to track the Number of Copies a library has.Staff Type and Number of Staff together describe how many Librarians, Library Assistants, and Library Technicians work for each library.The Private field is a yes/no field that indicates if this is a members-only library or a public institution.The Consortium Member field is a yes/no field that indicates if the library is part of the larger network of libraries that offer inter-library loans and share other services.The Library ID field an ID also used in the Catalog table.The Library field is the name of the library.The Library Profiles table relates to the Catalog table as a many-to-many (n:n) relationship on LibraryID. The Catalog table relates to the Editions table on ISBN. The BookshopLibraries.xlsx file introduces new tables around libraries for the purpose of supporting many-to-many relationships. The easiest tables to leave out with minimal impact would be Checkoutsand Ratings, followed by Award, Publisher, Sales, or Info and Series. To simplify the data model, the core tables are Book, Author, and Edition.The sheet and table fields from the Union also don’t contain unique information and can be hidden.The Title field in the Award table can be hidden.The ISBN field in the unioned Sales table can be hidden. ISBN should be kept, ideally from the Edition table, as the identifier of each edition.Any field ending with ID can be hidden (the only “ID” fields that do are ReviewID and ReviewerID from Ratings and ItemID and OrderID from Sales).Most of the fields used to form relationships aren’t needed for analysis and can be hidden once the data model has been built.The four Sales tables can be analyzed independently, but if they are unioned, we recommend renaming the union “Sales” or something similar.We recommend renaming the logical table of Book joined with Info “Book” or something similar. Add books to librarian pro 4 series#
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |