Houston Community College System School Library Website Worksheet

Project Description

A student and faculty can borrow books/media/devices/etc. Different limits for number of items that a student and faculty can borrow. Also, the number of days will be different in case of students and teachers. Each item will have an ID. Consider the library may have multiple copies of the same item. Details of fines due when item are not returned on time should also be considered. Need the capability to put request/hold items.

Provided functionality

See the catalog of what resources the library has to offer, including books, media, and devices. Ability to search catalogs for keywords. Each listing includes an image (book cover, movie cover, DVD cover, generic stock image, etc) of the item in question along with necessary details such as ISBN, name, author, publication date, etc. (if applicable). Students and faculty are allowed to borrow differing numbers of items, and also have different loan terms. The system includes the ability to levy fines and request/hold items. When a book is checked out, a transaction is generated, including details such as transaction ID, date generated, date due, and the like.

Software and frameworks

MySQL – database

Node.js – backend

React.js – frontend

The project chart is attached as a picture below ( the attributes stated in the picture must be used.)

• Library database: A student and faculty can borrow
books/media/devices/etc. Different limits for number of items that a student
and faculty can borrow. Also, the number of days will be different in case of
students and teachers. Each item will have an ID. Consider the library may
have multiple copies of the same item. Details of fines due when item are not
returned on time should also be considered. Need the capability to put
request/hold items.Book
Users
PK ISBN13
Key ISBN10
Title
Author
int(13)
PK
PSID
PK PSID
Faculty
numeric(7)
int(10)
First Name
varchar(35)
First Name
varchar(255)
Last Name
varchar(255)
Key
Contact number
varchar(35)
char(10)
Publication Year
int (4)
Late fee
decimal(,2)
Genre code
varchar(4)
Account status
Bool
Field
Last Name
Contact Number Type
Department varchar(4)
Type
int(7)
varchar(35)
varchar(35)
Language code
varchar(2)
Holds/transactionID?
Binding type code
int
Quantity
int
Key IsFaculty
Edition
PK ISSN
PK Library Serial
int
ItemsBorrowed
multivalue
int(13)
bool
int
int (8)
Unique Email
Password
varchar(35)
varchar(135)
1
Cover Image
BLOB
Decision
Transaction
PK Transaction ID
int(13)
Register#
int(1)
Key Date and Time
DATETIME
PSID
int(7)
Manage
Staff
ISBN
multivalue
int(13)
Key Staff ID
First Name
Expected Return
Date(8)
Last Name
int(7)
varchar(35)
varchar(35)
date
Key Staff ID
int(7)
Item Amount
int
Date/time
Expected
return
Transaction
ISBN
Transaction ID
Staff ID
PSID
Staff
First Name
Staff ID
Last Name