Shiluka's Blog

  LMS   Library Management System for Imaginary University    2nd year Database Project Data Definition Language (DDL) of the database. create table items     (      id                  INT PRIMARY KEY,      borrowed            boolean,      received_as         varchar(50)             );     create table book_details     (      ISBN                varchar(15) PRIMARY KEY,      title               varchar(50) not null,      edition             varchar(15),      publisher           varchar(50),      category            varchar(50),      price               float(7,2)         );         create table books     (      item_id         int PRIMARY KEY,      ISBN            varchar(15) ,         foreign key (item_id) references items(id),      foreign key (ISBN) references book_details(ISBN)         );    create table cd_details     (      ISSN                 varchar(15) PRIMARY KEY,      title                varchar(50) not null,      edition              varchar(15),      publishe

  LMS   Library Management System for Imaginary University    2nd year Database Project There are Four main entities Item : a book or as CD which can be borrow from the library Member : a registered member of the library who will be a student or a staff member Location : the physical location where an item is stored in the library Operator : a library staff member who will interact with members of the library. That is they will add/update data about members, transactions and items in the library Entity Relationship Diagram (ER Diagram) ER diagram There can be many copies of the same item (Book or CD). However since we need to identify each item separately so that each of them are given a unique id which is the 'item_id'. Storing common details of the same copies of items make redundancy, the details of items are decomposed into separate tables named 'book_details' and 'CD_details'. A member can borrow four books (or CDs) at a time and

  LMS   Library Management System for Imaginary University    2nd year Database Project Functional Requirements Administrator Add/delete/update details of a member for the library staff. Add/remove/change privileges of library staff to access the system All functionalities of an operator ( mentioned below ) Operator Add/delete/update book details (location) Issue/accept lent books Issue fine receipts Member Search books (for location, availability, other related books, etc.) Check user history Guest  only allowed to view data about resources available in the library Non Functional Requirements Data validation Data validation is having valid data for a given type of variable. Data must be validated to ensure the consistency of data. Security The security to the data base from unauthorized access is prevented by proper authentication giving access privileges for users. In addition security from SQL injection is prevented at the impleme

  LMS   Library Management System for Imaginary University    2nd year Database Project Database management is a wide area of computer science which is essential in most of the applications in order to store and handle data proper and efficient way. Library management system is one of a most frequently used application of database management systems where there is a chunk of information to store and record daily. Background University of ABC is a imaginary university of about 12000 students and 1000 of staff. The library system of the university facilitates all students, academic and non academic staff by providing access to the library. Anyone of the university can read books or other documents at the library, but in order to borrow them one should register and get the membership. The membership is valid only for a year and that should be updated afterwards. After getting the membership, a member can borrow 4 books at a time and maximum burrowed period is 2 weeks. Users