Library Management System-Computer Sciences-Project Report, Projects for Applications of Computer Sciences
padmini
padmini

Library Management System-Computer Sciences-Project Report, Projects for Applications of Computer Sciences

PDF (1 MB)
53 pages
50Number of download
1000+Number of visits
94%on 38 votesNumber of votes
31Number of comments
Description
This report is for final year project to complete degree in Computer Science. It emphasis on Applications of Computer Sciences. It was supervised by Dr. Abhisri Yashwant at Bengal Engineering and Science University. Its ...
100 points
Download points needed to download
this document
Download the document
Preview3 pages / 53
This is only a preview
3 shown on 53 pages
Download the document
This is only a preview
3 shown on 53 pages
Download the document
This is only a preview
3 shown on 53 pages
Download the document
This is only a preview
3 shown on 53 pages
Download the document
Library Management System

x

List of Figures

Figure 1-1: Three Tiered Architecture................................................................................................. 2

Figure 3-1: Waterfall Life Cycle ......................................................................................................... 14

Figure 5-1: Entity Relationship Diagram of LMS............................................................................. 24

Figure C-1: Login Admin Page ........................................................................................................... 40

Figure C-2: Manage Books Page......................................................................................................... 41

Figure C-3: Manage Fine Page............................................................................................................ 41

Figure C-4: Manage Checks Page....................................................................................................... 42

Figure C-5: Manage Requests Page.................................................................................................... 42

Figure C-6: Manage Students Page .................................................................................................... 43

Figure C-7: Manage Members Page ................................................................................................... 43

Figure C-8: Manage Items Page.......................................................................................................... 44

Figure C-9: Manage Staff Page ........................................................................................................... 44

Figure C-10: Login Member Page ...................................................................................................... 45

Figure C-11: Home Page...................................................................................................................... 45

Figure C-12: Borrow Book Page ......................................................................................................... 46

Figure C-13: Check Status Page ......................................................................................................... 46

Figure C-14: Search Book Page .......................................................................................................... 47

Figure C-15: Search Magazine Page................................................................................................... 47

Figure C-16: Contact Us Page ............................................................................................................. 48

Figure C-17: Change Password Page.................................................................................................. 48

Figure C-18: Search Journal Page...................................................................................................... 49

Figure C-19: Due Books Page.............................................................................................................. 49

Figure C-20: Reports Page .................................................................................................................. 50

Figure C-21: Change Password Staff Page ........................................................................................ 50

docsity.com

xi

List of Tables

Table 2-1: Member Activities ................................................................................................................ 4

Table 2-2: Library Staff Activities ........................................................................................................ 4

Table 5-1 : Library_Item Attributes................................................................................................... 21

Table 5-2: Book Attributes .................................................................................................................. 21

Table 5-3: Magazine Attributes .......................................................................................................... 22

Table 5-4: Journal Attributes.............................................................................................................. 22

Table 5-5: Library_Staff Attributes ................................................................................................... 22

Table 5-6: Member Attributes ............................................................................................................ 23

Table 5-7: Student Attributes.............................................................................................................. 23

Table 5-8: Employee Attributes .......................................................................................................... 23

Table 5-9: Domain of Attributes ......................................................................................................... 29

Table 5-10: Member Table .................................................................................................................. 30

Table 5-11: Student Table ................................................................................................................... 31

Table 5-12: Employee Table ................................................................................................................ 31

Table 5-13: Library_Staff Table ......................................................................................................... 31

Table 5-14: Library_ Item Table ........................................................................................................ 32

Table 5-15: Books Table ...................................................................................................................... 32

Table 5-16: Magazine Table ................................................................................................................ 32

Table 5-17: Journal Table ................................................................................................................... 32

Table 5-18: Checks Table .................................................................................................................... 32

Table 5-19: Issues Table....................................................................................................................... 33

Table A-1: Abbreviations ................................................................................................................... 48

Table A-2: Terms and Definitions ...................................................................................................... 48

Table B-1: Symbols ............................................................................................................................. 49

Table B-2: Notations ........................................................................................................................... 50

docsity.com

xii

Abstract

Web designing is the skill of creating presentations of content that is delivered to an

end-user through the World Wide Web, by way of a Web browser or other Web-

enabled software like Internet television clients, micro blogging clients and RSS

readers. The intent of web design is to create a web site—a collection of electronic

documents and applications that reside on a web server/servers and present content

and interactive features/interfaces to the end user in form of Web pages once

requested.

During pass few decades web designing is emerged so much that now almost

every organization and even an individual person has his own web page.

Library Management System is an online system intend to provide the

members with a portal to search the available books in the PIEAS Library and also to

check there status and access the system online and perform multiple tasks related to

PIEAS Library.

docsity.com

1

Chapter 1 : Introduction

PIEAS Information Portal Exchange (PIPE) intends to automate the entire operations

of the institute. It would allow multi-divisional, multi-department system handling

which includes activities such as admissions, curriculum management, course and

faculty scheduling, fee collection, library, examinations, career, hostel and

transportation. PIPE will include

 Web portals for Student, Faculty and Management Staff

 Management of multiple departments

 Preparation of program-wise catalogues

 Streamlined registration and admission activities

 Organized college management involved in scheduling program, course and

syllabus details

 Maintain student grades in GPA

 Define multiple fee policies for different programs/courses

 Automatic reminder and alerts via application, SMS and email

The module that has been developed is Library Management System.

1.1 Current System of PIEAS Library

Current system of the PIEAS Library provides basic functionalities of the library

which include.

 Issue of books.

 Fine calculation

 Search

 Reports

1.2 Problems of Current System

Some problems of current system are:

1. Users have no online access of the system.

2. User cannot check his status about fine and issued books.

3. Manual entry of issuance and return data.

docsity.com

2

1.3 Proposed System For better and efficient monitoring and enforcement, an online system is required to

streamline Library functions to result in more efficient, comprehensive and accurate

achievement of its objectives. It is proposed to develop an Online System for regulating the

library routine working and to assist the library staff and to reduce their complexity.

1.4 System Perspective

LMS will improve services for all the stakeholders of this system. This also reduces

the manual work of the persons in admin penal and the bundle of registers that were

search when to find the records of previous students. This application helps the

personal profile of all the current students quickly. The database of the system will

help you to check a particular one. Members of the LMS will be recognized from the

ID number allocated at the registration time. System will improve the management

work in the library. The proposed system includes:

 Article & Member history

 Internal & External library lending and transfers

 Issue/Return of books/Journals

 Annual Stock report

 Report of Lost/Injured books

1.4.1 Three Tier System

The prescribed system is a 3-Tier web application as shown in figure 1.1 below. [1]

Figure 1-1: Three Tiered Architecture

docsity.com

3

1. Presentation Tier:

The front end (Presentation Layer) is for user’s interaction with the system. This layer

will be implemented on client-side. The interaction with the system will be through

the web-site and also the library card reader.

2. Application Tier:

On the server side, there will be the Application Tier. It would have capabilities to

retrieve and store data from the back end database. The application logic and report

generation logic lies here.

3. Data Tier:

The database will store all sorts of data regarding the system. This would be the Data

Tier.

1.4.2 Error Rate Reduction

Currently the entry of issue and return record is manual which results in inconsistent

data recording. Such variances may lead to incorrect entry of the records.

As the most of the tasks are automated in proposed system so greater error rate

reduction.

1.5 Thesis Layout

The objective of this thesis is to provide the reader with an insight into how LMS

comes into reality from a mere idea to a running application. The thesis starts from the

motives behind choosing LMS and then gradually follows through the workflow of the

system development.

Chapter 1 is dedicated to provide a brief overview of this project. It explains

the problems in the current system and facilities not currently available in the library

and what features are included in the system being developed, project development

phase is also explained. Remainder of this document looks at the analysis, design and

implementation.

Chapter 2 describes the overall system architecture and Information System

function details. Chapter 3 focuses on the specification of Information System.

Chapter 4 describes the Business Logic Design for the Information System web-

application. Chapter 5 describes the Database design of the system. Chapter 6 is

dedicated to implementation and web-application

docsity.com

4

Chapter 2 : System Functions

This chapter describes the architecture of LMS which involves the users associated

with the System, the architecture of the System web-application and functions in

system and its back-end architecture.

2.1 System Users

LMS users and their activities are as follow.

2.1.1 Members

Members include employees and students which are using PIEAS Library. Member

tasks are listed below in table 2.1. Table 2-1: Member Activities

Actor Activities

Member

Login/Logout Reserve Books Check Status Search Items Return Request

2.1.2 Library Staff

Library Staff include management staff of the Library which handles all the activities

in the PIEAS Library. The activities for the Library Staff are listed below in table 2.2. Table 2-2: Library Staff Activities

Actor Activities

Library Staff

Login/Logout Update Fine Records Add Items Manage Members Manage Account Check Items Accept/Ignore Request Generate Reports

2.2 Functions

Important functions of LMS are listed below. These are categorized by users of the

Information System. Functions included in administrator module are explained below.

docsity.com

5

2.2.1 Library Staff Login Page The main page of administrator module is the administrator login page. When the

web-application is accessed through the web browser software and administrator

module is accessed the main page available to user is administrator login page. If the

user is administrator of the system having the user name and password of

administrator account is able to login to the IS. For the security of the system and ease

of use three options are provided to the administrator regarding login.

 Auto Login until I Logout

If user select this option and log in to the system and if the user is authenticated, the

next time user doesn’t have to provide login details until user explicitly logout from

the system.

 Remember Username

This option saves the username of last user logged in to the IS and user only have to

provide the password to login.

 Always Ask

If this option is selected by the user then each time user has to provide username and

password to login the system.

2.2.2 Books Options After the successful login to the administrator module, all the functions provided to

administrator are available on the web-application interface. On the left side of the

web browser window and the first page that opens after login to the administrator

module is Book Options. As the main feature of the system is to manage then

information regarding the books presents in library so the main focus of our web-

application is to manage the activities related to book. All books options are available

to logged in staff is able to manage books using available functions. Following

functions are provided to staff for books management.

 Add new book

Using this option the staff is able to create new books in the system and all the books

related information is saved into the database.

 View Existing Books

Using this option the IS staff is able to view already existing books information

available in the database of the system.

docsity.com

6

 Edit Existing Book Information

This option is provided to staff to modify existing books information already entered

in the database.

 Delete Selected Books.

If the staff wants to delete a book or multiple books, staff can use this option to delete

the selected books(s).

2.2.3 Member Options

Another important option available is Member Options. Using this option staff is

able to manage the System members, by clicking Member Options all the members

available in the system database are shown to the staff and all the member related

options are available. Following functions are provided to the staff on member

options web page.

 Add New Member

By using this option the new system member is added to the system and all the

member related information is entered by the staff using the member registration form

and as the new member is created the information is saved in system database.

 View Member Information

This option is available to view the information of already existing member in the

system database, if staff wants to view any member information this option is

available for this purpose.

 Edit Existing Member Information

This option is provided to modify any existing member information already available

in the database. One of the important functionality staff can perform. Staff can reset

password of member without the need of old password. Just have to click Edit

Member option and change replace the old password with new password.

 Delete Selected Members

Using this option staff is able to delete member in view page or multiple members in

main member options by selecting them and using option delete selected member(s).

2.2.4 Checks Options

Another functionality provided in the system is the check option. This is for staff to

check the item and enter the record into the database for keeping record of the

Lost/damaged items. Following functions are provided to staff

docsity.com

7

 Add New record

Using this option new record can be added to the web application. Staff using this

function provides the information about the item, its status and date. When checked,

the information is saved in system database.

 View Existing records

To view the information of already existing record staff can use this function

provided. By using this option all the related information about the record saved in

system database is shown on the web page.

 Modify Existing Gallery

If the staff needs to modify existing record, this option is available. After changing,

update button is clicked. The new information is saved in the system database.

 Delete Selected Galleries

Staff is able to delete a single record or multiple by selecting multiple record at one

time and using the Delete Selected Records option.

2.2.5 Issues Options

This functionality provided in LMS is associated with members of the system. Issues

are a compilation of all the books issues to the members. The staff is provided with

issues options and with the help of these options staff is able to perform the following

functions given below.

 Add Issue Record

Using this option staff can add a new issuance record for the members which haven’t

sent online request for the book.

For that staff click on add issuance record and then add the member id and

item id and current date is added automatically.

 View Existing issued books

To view the information available in system database of already issued books against

some members; this option is provided to the staff.

 Modify Issue Information

As per requirement information available in system database about issued books can

be modified by the staff using this option. Book member association can also be

changed depending on the requirement.

docsity.com

8

 Delete Selected Issue Records

This option can be used to delete a single issue record in the view page or can be

used to delete multiple issue records by selecting them in main issue list page options

and clicking on Delete Selected Issue Record(s) option.

2.2.6 Library Item Options

This functionality provided in the LMS is for the managing of the Items present in the

library. Staff is provided with the following functionalities.

 Add New Item

Staff has the option to add new item in the system. This is done by clicking the option

Add New Item. After entering the information staff click the add button and record is

entered into the system database.

 View Existing Item Information

Staff is able to view the already existing items available; this option is very useful if

staff wants to generate some report about all the items in the library.

 Edit Existing Item

If staff wants to change of modify any item this option can be used to do this task, the

provided item is loaded on the web page with HTML editor and staff is able to change

or modify the item information.

 Delete Selected Comment(s)

Using this option a single item can be deleted and multiple items at the same time can

also be deleted by selecting them and using the option Delete Selected Item(s)

option.

2.2.7 Library Staff Options

This option is for the management of the record of the staff of the library including

librarian, assistant librarian and other staff.

 Add New Staff

This option is for Librarian. If Librarian is logged in then he can view this option. If

other staff is logged in the system he/she cannot add or edit new staff into the system.

If librarian is logged in than he can add new staff into the system. He also needs to

specify the role of the staff whether the new staff is administrator or staff.

docsity.com

9

 Edit Existing Staff

This option is only for the Librarian to edit the existing staff of the system.

 View Staff

This option is for all the staff to view his information.

 Delete Selected Staff

This option is for the Librarian to delete one staff or multiple staff by selecting

multiple records and then clicking Delete Selected Staff option.

2.2.8 Search

This option is included in all list pages of the system to find concerned page records

in system database. There are two types of search options included in the System

explained below.

 Quick Search

Quick search feature is very important for System staff to quickly find records in

system database. Quick search function is available on top of web-application

interface for all functions provided to administrator with the following options.

a. Exact Phrase

Staff can select this option to search the exact phrase entered in the search bar.

b. All words

Staff can select this option for searching into the system database all the words

entered in the search bar.

c. Any word

Staff can select this option for searching if any word entered into the search bar is to

be matched.

 Advance Search

Another important function included into System administrator module is advance

search feature, with advance search administrator can find specific record in system

database by providing different type of inputs for search.

2.2.9 LMS Login Page

The main page that opens when the LMS website is accessed over LAN is LMS is

Login page. Anonymous users cannot login just go to contact us page and the

docsity.com

10

registered user after providing correct username and password is redirected to Home

page.

2.2.10 Home Page

After the successful login of member into the Information System, all the functions

provided to members are available on the web-application interface below the bar in

header. Now user have menus i.e. search(submenus : search books, search magazine,

search journal) , tasks(Submenus: reserve books, return request, check status).

2.2.11 Search

When user move mouse cursor on the search tab a dropdown menu opens include

following options.

 Books

This option is provided to member to search the books in the Library. System will

provide you with Three Options: Title, Author and ID. Based on these criteria, the

Search word is search and will let you know the results.

 Journal

This option is provided to member to search the journals in the Library. System will

provide you with Two Options: Title and ID. Based on these criteria, the Search word

is search and will let you know the results.

 Magazine

This option is provided to member to search the magazines in the Library. System

will provide you with Two Options: Title and ID. Based on these criteria, the Search

word is search and will let you know the results.

2.2.12 Tasks

When user move mouse cursor on the search tab a dropdown menu opens include

following options.

 Reserve Books

This option is provided to member to reserve the book for borrowing. Member is

provided with the dropdown list showing title and id of the books. After selecting one

user will click the reserve button and request will be sent to library staff for that book.

docsity.com

11

 Return Books

This option is provide to member to send return requests to the library staff. Member

is provided with the dropdown list showing items title and id issued to that member.

After selecting one user click the return button and a request will be sent to the staff.

 Check Status

Member is provided with this option to check his/her status that how many items are

issued to him and when they are returned (if returned) and how much fine on some

specific item.

2.3 Non-Functional Requirements

The non-functional requirement are statement of how a system must behave, it is a

constraint upon the systems behavior. The main non functional requirements of LMS

are defined below. [2]

2.3.1 Performance

The system allows about 50 users to login at a time.

2.3.2 Reliability

The system shall be reliable. If the server crashes, the data will not be lost because a

backup will be maintained. The server would take 5 minutes on the average for re-

starting. The lost data would be restored within 2 hours.

2.3.3 Availability

The system shall be accessed globally over the Internet (for registered users). It would

be available for 24 hrs.

2.3.4 Security

This is a very sensitive aspect of this project. The system should be secure as

malicious users should be prevented from accessing and updating other users’

accounts and records. The password would not be less than 12 characters.

2.3.5 Maintainability

System shall be designed in a way that is easy to maintain in the future.

docsity.com

12

2.3.6 Usability

The system will be easy to use, so that anyone with the basic knowledge of computer

and anyone who has little experience of using internet browser would be able to use

this system. This system will also be friendly for its maintaining and administration

staff.

2.3.7 Scalability

The system shall be designed in a way that it can be extended in future.

docsity.com

13

Chapter 3 : Specification

In software development project has great impact on its specifications like the

technology used and the tools that are used to develop the product. Client side

modules also affect the product. This chapter goes through the specifications for the

LMS. These specifications are as follow:

3.1 Requirement Capturing

For the requirement capturing the interviews and observation techniques were used.

[3]

3.1.1 Interview

Interviews of librarian, assistant librarian, some students and some staff personals

were taken. Things discussed are that what they want to be in library. Also what they

like and dislike in that system.

3.1.2 Observation

I visited library many times and observed the overall process and flow of the data and

other procedures which are routinely adopted in PIEAS library. I also observed the

method of the placing the specific item in specific location.

3.2 System Interfaces

The system interfaces and their brief description are given below:

3.2.1 Software Interfaces

A Web Server and DBMS will be required to install this product. A version of SQL

will be used as a DBMS. IIS (Internet Information Services) will be used as Web

Server. On the Client Side, a browser is needed for interacting through the web-site

which may be any of the famous browsers such as Mozilla or IE (Internet Explorer)

3.2.2 Communications Interfaces

LMS is Web based system. Some standard protocols will be required.

 TCP/IP: It is the only protocol used to send data all around the

Internet/Intranet.

docsity.com

14

 HTTP: (Hyper Text Transfer Protocol): It is a protocol used by the WWW

(World Wide Web) service to make communication possible between a web

server and a Web browser.

3.3 Project Life Cycle

The waterfall life cycle model has been selected as the project life cycle model for

LMS. Waterfall development has a few shortcomings, but if you have got a new role

to fill, a new team to work with, and a solution that will support this style, it is the

best solution rather than to use advanced techniques. Waterfall development is an

approach to software development that breaks a project into finite phases. Each phase

is performed in order, and each depends on the completion of preceding phases.

Under the waterfall development method, each portion of work is evaluated separately

and performed separately. [4]

Figure 3-1: Waterfall Life Cycle Here is a common breakdown of the waterfall development process as shown

in the figure 3.1: [5]

 Evaluate the problem:

This is where the concept is born. Identify deficiencies with existing solutions and

gather information.

docsity.com

15

 Propose a solution:

Present a detailed description of the solution, including pros and cons and the

problems. Finalize timelines, budgets, work breakdown structures, and other

supporting documentation. Most importantly, identify and analyze requirements.

 Design the architecture:

Once the proposal has been accepted, create models of the solution, including

workflow and dataflow diagrams, module and functionality layouts, and any other

descriptions required by the solution.

 Develop the code:

Use the blueprints created in previous phases to write, debug, and unit-test the code.

In next phase integrate the code and test portions of the system. Finally, test the entire

system. This cycle isn’t complete until all tests have passed.

 Deploy and use the system:

Roll out the resulting functionality and provide training and documentation to users as

needed.

 Maintain the solution:

Support and upgrade the software when necessary and fix post-production bugs.

3.4 Equipments Required

For complete and correct functioning of the LMS following Hardware and Software

equipment is required that is as follow:

3.4.1 Minimal Hardware Requirements

PC and compatibles used had the following configurations:

 Intel Pentium 4 processor

 512 MB RAM

 1.5 GB Hard disk space

 Internet / intranet connection for web based interface.

 Data Storage Servers.

3.4.2 Software Requirements

The software tools used to build the application are as follows and also the software

requirements to run the software at the client end.

docsity.com

16

 Windows XP

 Apache Server

 PhpMyadmin

 IIS (Internet Information Services) v 7.5

 Smart Draw 7

 MS Office Project 2007

 MS Office 2007

The HTML has been used to implement interfaces. The code behind of all

interfaces has been written in PHP and JScript. The project time line has been

designed in MS Office 2007. Smart Draw 7 has been used to design use case diagrams

and flow charts.

Client Side

a. Web browser, like Internet explorer, Mozilla Firefox, Google Chrome, Opera,

etc.

b. Windows 2000/NT/XP Workstation

3.5 Project Schedule

The project work was divided into several different phases and each phase was

scheduled in certain specific time, project was divided into following phased given

below.

 Project Idea Exploration

 Software Requirements and Specifications

 Design

a. Business Logic Design

b. Database Design

c. Architectural Design

d. User Interface Design

 Implementation

e. Database Implementation

f. Administrator Module implementation + Testing

g. Anonymous Users and Guest Users modules implementation + Testing

docsity.com

17

 Deployment

3.6 Project Deliverables

The list of project deliverables is given below.

a. SRS document

b. Proposal presentation

c. Progress reports

d. Progress presentations

e. Project demo

f. Final project presentation

g. Thesis report

h. Required Software

docsity.com

18

Chapter 4 : Business Logic Design

Information System web application is supposed to obey a certain business logic. This

chapter discusses the Business Logic Design for LMS in detail. [6]

4.1 Introduction

Business logic design incorporates the business logic into the system and should

preferably be designed prior to Database Design, Database Implementation,

Application Software Design and Implementation.

Business Logic Design comprises of a set of business rules which the system

is supposed to obey. These rules are specified in the following section.

4.2 Business Rules and Constraints

This section describes the business rules that information system database and

information system web-application need to obey.

The business rules are categorized according to different sections in the

information system. These business rules are described in the following section.

4.2.1 User Account Rules and Constraints

LMS web application needs to obey following rules relating to user accounts.

 Member must already be registered.

 Default administrator account shall exist at the time of deployment of

Information System.

 User name for other system users should be the registration card ID.

 Guest cannot use the system.

 User ID should be integer.

 Staff roles should be assigned by the information system administrator and can

only be one of the roles mentioned above.

4.2.2 Data Format Rules and Constraints

LMS needs to obey following rules relating to data formats.

 Date format should be dd-mm-yyyy for example 29-06-2008.

docsity.com

19

 Date and Time format should be dd-mm-yyyy hour: minute: second for

example 01-08-2008 12:20:50.

All possible email addresses with maximum of 40 characters should be specified

as email address.

docsity.com

20

Chapter 5 : Database Design

Database design process includes following tasks given below.

 Database Analysis

 Logical Database Design

 Entity Relationship Diagram

 Relational Schema

 Database Implementation

Each section is described in detail below.

5.1 Database Analysis

Following are the database analysis processes.

5.1.1 Entity Relationship model

An Entity-Relationship Model (ERM) is a model providing a high-level description

of a conceptual data model. Data modeling provides a graphical notation for

representing such data models in the form of Entity-Relationship Diagram (ERD). [7]

The first stage of information system design uses these models to describe

information needs or the type of information that is to be stored in a database during

the requirement analysis.

In the case of the design of an information system that is based on a database,

the conceptual data model is, at a later stage (usually called logical design), mapped to

a logical data model, such as the relational model; this in turn is mapped to a physical

model during physical design.

5.1.2 Definitions

This section gives the definitions of some of the important terms used in the later

section.

 Entity

It is described as any object that exists and can be distinguished from other objects. It

is a person, place, event, object, or concept in real world that we wish to represent in

database. A collection of entities of the same type is called an entity set. An entity set

is represented in E-R diagram by a rectangle having name of the entity set inside. [8]

docsity.com

21

 Attributes

The attributes of any entity set are the defining properties or qualities of the entity

type. It is represented by an ellipse with name of the attribute inside.

 Domain

The set of values permitted for each attribute is called the domain of that attribute

 Key

Key is a data item that allows us to tell record apart. This is used as index to the

particular instance of the table.

5.2 Logical Database Design

Logical database design of Information System for LMS is presented in this section.

Following are the entities in the LMS and there attributes.

 Library_Item

This entity set stands for all library items in PIEAS Library including books,

magazine, and journal. Attributes are shown in Table 5.1. Table 5-1 : Library_Item Attributes

Entity Attributes

Library_Item

LI_ID Rack_no

Classification Title Type Date Price

 Book

This entity set stands for all books in PIEAS Library. Attributes are shown in Table

5.2. Table 5-2: Book Attributes

Entity Attributes

Book LI_ID ISBN

Authors Status

 Magazine

docsity.com

22

Entity set magazine stands for all magazines available in PIEAS library. Attributes are

shown in Table 5.3. Table 5-3: Magazine Attributes

Entity Attributes

Magazine LI_ID

Magazine_Type

 Journal

Entity set magazine stands for all journals available in PIEAS library. Attributes are

shown in Table 5.4. Table 5-4: Journal Attributes

Entity Attributes

Journal LI_ID

Volume Number

 Library_Staff

Entity set “Library_Staff” stands for all employees working in library which include

attendants, librarian, assistant librarian and other managing personals. Attributes are

shown in Table 5.5. Table 5-5: Library_Staff Attributes

Entity Attributes

Library_Staff

LS_ID Password

Picture First_Name Mid_Name Last_Name

Type Gender Street City Zip

Province Country

Designation Contact_Personal

Contact_Home E-Mail

 Member

A person who is a member of PIEAS library. Attributes are shown in Table 5.6.

docsity.com

wow nice documentation
Firstly let me use it then i will rate
it very interesting thanks
1-5 of 31
This is only a preview
3 shown on 53 pages
Download the document