This table is the Master table for the binding types.This includes the binding ID and Binding Name.The Binding ID servers as a primary key. No_Of_Copies_Current: This column contains the total no of copies of each book that were currently available. No_Of_Copies_Actual: This column contains the total no of copies of each book that were initially present. Language : contains the language in which this book was published.Ĭategory_Type : This column contains the Category ID whose details can be fetched form the category_master table.The category ID is an Unique number given to each category.īinding _Type : This column contains the Binding ID whose details can be fetched form the Binding_Mst table.The Binding ID is an Unique number given to each type Binding.ĭescription : This column contains a short description for each book so that the librarian can understand about this book. Publication_year : Contains the year of publication in ‘YY’ format (eg:2009à09) Since there may be many no of books with same TITLE,this ISBN no will help us to distinguish between books of same title.īook_Title: Provides the name of the book. ISBN: This is unique ID given to every book. When ever a book was assigned to a borrower the the available count will be decremented by 1. This table contains the complete list of book that are available in the library.Each Book id provided with a Unique ISBN which serves as a primary key.The book details include the ISBN,Book Title,the year in which that particular book was published,the type of binding either soft cover or hard cover,the category to which a book belongs i.e short loan,long loan etc.This table also contains the stock details such as the no.of copies that are there actually and the no of copies available at any given point of time. This is the master table for all the books that are available in the Library.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |