Library Management Systems: An Introduction to Concepts and Implementation, Lecture notes of Computer science

Download Library Management Systems: An Introduction to Concepts and Implementation and more Lecture notes Computer science in PDF only on Docsity!

LIBRARY MANAGEMENT

GROUP MEMBERS:- ANKIT RANJAN ANUSHREE NARAIN POOJA VERMA

INTRODUCTION

• (^) A library is the collection of organised information and resources which is made accessible to a well-defined community for borrowing or reference sake.
• (^) Library Management System allows the user to store the book details and the customer details
• (^) The implementation of the system in the organisation will considerably reduce data entry, time and also provide readily calculated reports.

DATA TYPES

• (^) INTEGER:- One optional sign character(+ or-) followed by at least one digit(0- 9). Leading and trailing blanks are ignored. No other character is allowed.
• (^) VARCHAR:- It is used to store alpha numeric characters. In this data type we can set the maximum number of characters upto 8000 ranges by defaults SQL server will set the size to 50 characters range.
• (^) DATE:- The DATE data type accepts data values. No parameters are required when declaring a DATE data type. Date values should be specified in the form: YYYY-MM-DD. However, PointBase will also accept single digits entries for month and day values.
• (^) TIME:-The TIME data type accepts time values.No parameters are required when declaring a TIME data type. Data values should be specified in the form- HH:MM:SS. An optional fractional value can be used to represent nanoseconds.

ENTITIES

• BRANCH

• EMPLOYEE

• CUSTOMER

• ISSUE STATUS

• RETURN STATUS

• BOOKS

ATTRIBUTES

• (^) RETURN STATUS- 1)Return_id 2)Return_date 3)Customer_id 4)Return_book_name 5)ISBN
• (^) BOOKS- 1)ISBN 2)Title 3)Category 4)Rental_price 5)Author 6)Publisher 7)Status

RELATIONSHIPS

• (^) MANAGER manages the BRANCH (1-N)
• (^) CUSTOMER registers in the respective BRANCH(N-1)
• (^) CUSTOMER issues BOOKS (1-N)
• (^) CUSTOMER returns BOOKS (N-1)
• (^) EMPLOYEE updates BOOKS (N-N)