CHAPTER 2
Business Processes and Information Systems
To check out a book from the library first you look for the book in the correct section
or in the computer system in the library. You can search by book title or by author.
Then you go to the section specified in the computer. Once the book is found, take the
book to the self checkout computer and scan library card. once the card is scan, it
shows whether or not you have a balance or a delinquent account. If the account is
delinquent over RS 10.00, then you will not be able to check out any books unless the
balance is brought below Rs 10.00. To make a payment call over the librarian and make
a payment. Then proceed to checking out your books.
CHAPTER 3
SYSTEM DESIGN
3.1 TABLE DESIGN
VARIOUS TABELS TO MAINTAIN
INFORMATION
BOOK TABLE FOR KEEPING TRACK OF BOOKS
Field Data type Default Key Extra
Code INT(11) Not Null Primary Auto
increment
Bookname VARCHAR(255) Null
Author VARCHAR(255) Null
Publication VARCHAR(255) Null
Subject VARCHAR(255) Null
No of INT(10) Null
copies
STUDENT TABLE FOR STUDENT INFORMATION
Field Data type Default Key Extra
libid INT(11) NOT NULL Primary key Autoincrement
regno INT(10) NULL
branch VARCHAR(255) NULL
section VARCHAR(255) NULL
semester VARCHAR(255) NULL
section VARCHAR(2) NULL
yearofadm INT(5) NULL
TEACHER TABLE TO KEEP TEACHER INFORMATION
Field Data Type Default Key Extra
Tid INT(11) NOT NULL Primary key Auto
increment
Name VARCHAR(255) NULL
Designation VARCHAR(255) NULL
Branch VARCHAR(255) NULL
Contactno INT(13) NULL
Lectures LONG BLOB NULL
Issue table to keep track of books issued
Field Data Type Default Key Extra
bookid INT(11) NOT NULL Foreign key References
book
stuid INT(11) NOT NULL Foreign key References
Student
issuedate DATE NULL
returndate DATE NULL
STUDENT LOGIN TABLE
Field Data type Default Key Extra
logid INT(11) NOT NULL Foreign key References
Student
Username VARCHAR(255) NULL
Password VARCHAR(255) NULL
numbooks INT(1) NULL
EVENT TABLE FOR EVENT INFORMATION
Field Data type Default Key Extra
Name Varchar(255) NULL
Date Date(yyyy/mm/dd) NULL
Time VARCHAR(255) NULL
Mname VARCHAR(255) NULL
Contactno. Int(30) NULL
Email VARCHAR(255) NULL
Venue varchar(255) NULL
TEACHER LOGIN TABLE
Field DataType Default Key Extra
Loginid INT(11) NOT NULL Foreign References
key teacher
Username VARCHAR(255) NULL
Password VARCHAR(255) NULL
3.2 DATA FLOW DIAGRAMS
DATA FLOW DIAGRAM FOR TEACHER LOGIN
TEACHER
DATABASE
ENTER
ENTER USERNAME CHECK
TEACHER URL & VALIDITY
PASSWORD
IF VALID
TEACHER
WEB SERVER LOGIN
PAGE
After entering to the home page of the website , teacher can choose the TEACHER LOGIN
option where they are asked to enter username & password , and if he/she is a valid user
then a teacher login page will be displayed.
DATA FLOW DIAGRAM FOR STUDENT LOGIN
STUDENT
DATABASE
ENTER
ENTER USERNAME CHECK
STUDENT URL & VALIDITY
PASSWORD
IF VALID
STUDENT
WEB SERVER LOGIN
PAGE
After entering to the home page of the website , student can choose the STUDENT LOGIN
option where they are asked to enter username & password , and if he/she is a valid user
then a student login page will be displayed.
DATA FLOW DIAGRAM FOR BOOK SEARCH
IF
SELECT ENTER
ADVANCE BOOK BOOK
HOME FOUND
SEARCH DETAIL DETAILS
BOOK
DATABASE
After the home page login there will be an option of the book search where after entering
book detail like author name, publication, book name etc book details will be displayed.
DATA FLOW DIAGRAM FOR ACCOUNT CREATION
ADMIN
SELECT ENTER MESSAGE
HOME ACCOUNT STUDENT VERIFY
SENT
CREATION DETAIL STUDEN TO
T STUDENT
IF ALL REG. IS IF VALID
PARTIALLY FILLED
ADMIN STUDENT
DATABASE DATABASE
After the home page login there will be an option of CREATE AN ACCOUNT where after
entering student detail ,if all the fields are filled then a request will be sent to the librarian who
will approve him as a registered member of the library.
