$1)$ Develop an application using MySQL$,$ HTML & CSS$,$PHP$.$and javascript.

$2)$ Test the complete application as per the Rubric Requirements.

Scenario:

You have been tasked with developing an Online Library Management System $($OLMS$).$

This project aims to create a comprehensive system that enables students, faculty, and staff to easily access and manage the library's resources. The system will include features for searching and borrowing books, managing user accounts, and maintaining a secure and user$-$friendly interface.

The proposed app should have the following functionalities:

The application should allow the admin user $($Librarian$)$ to add, update, delete, process book Ioan request $($accept or decline$),$ create and manage user accounts.

If the book is out for loan, the admin user $($Librarian$)$ must decline the request otherwise, accept it$.$

Project Outcome:

By the end of the project, you will have developed a functional Online Library Management System app that meets the requirements the library. The system will provide a userfriendly interface, efficient book management processes, secure user authentication, and a robust

database design. Your work will showcase your understanding of various analysis and design

techniques, in$-$depth understanding of Javascript coding $($Classess and Inheritance, error handling, form handling etc.$),$ database programming using MySQL$,$ as well as your ability to apply principles of

user interface design and system controls to create a well$-$rounded and effective software solution. Follow the rubric:

RUBRIC

Criteria Maximum

Inheritance $$ Demonstrate understanding of the concept of inheritance.

$$ Properly extend classes to create a class hierarchy.

$4$ marks

Method

Overriding and

Superclass

Access

$$ Successfully override superclass methods to customize

behaviour.

$$ Appropriately call superclass methods when necessary.

$2$ marks

Constructor

Utilization

$$ Demonstrate proper usage of constructors during

inheritance.

$$ Understand and implement constructor chaining within the

class hierarchy.

$1$ marks

Information

Hiding

$$ Implement appropriate access modifiers to encapsulate

data and methods.

$$ Demonstrate an understanding of encapsulation and its

benefits.

$3$ marks

Abstract

Classes and

Interfaces

$$ Create and uses abstract classes and interfaces where

appropriate.

$$ Implement abstract methods and utilizes interface

implementation.

$3$ marks

Dynamic

Method

Binding

$$ Demonstrate the use of dynamic method binding to

achieve polymorphism.

$$ Properly selects and executes methods based on object

type.

$3$ marks

Array Handling

$$ Create arrays of subclass objects and manages them

effectively.

$$ Demonstrate understanding of array manipulation and

iteration.

$1$ marks

Use of Object

Class

$$ Utilise methods from the Object class where needed.

$$ Demonstrate understanding of the Object class and its

common methods.

$2$ marks

Database Interaction

Connecting to

the DBMS

$$ Utilise methods from the Object class where needed.

$$ Demonstrate understanding of the Object class and its

common methods.

$3$ marks

CRUD

Operations

$$ Utilise methods from the Object class where needed.

$$ Demonstrate understanding of the Object class and its

common methods.

$3$ marks

Connection

Pooling

$$ Utilise methods from the Object class where needed.

$$ Demonstrate understanding of the Object class and its

common methods.

$4$ marks

Data Security

and Encryption

$$ Utilise methods from the Object class where needed.

$$ Demonstrate understanding of the Object class and its

common methods.

$2$ marks

Error Handling and Testing

Exception

Handling

$$ Utilise methods from the Object class where needed.

$$ Demonstrate understanding of the Object class and its

common methods.

$3$ marks

Common

Errors

$$ Utilise methods from the Object class where needed.

$$ Demonstrate understanding of the Object class and its

common methods.

$2$ marks

Testing and

Deployment

$$ Utilise methods from the Object class where needed.

$$ Demonstrate understanding of the Object class and its

common methods.

$2$ marks

Web Development

HTML Forms

and PHP

Integration

$$ Utilise methods from the Object class where needed.

$$ Demonstrate understanding of the Object class and its

common methods.

$4$ marks

Client$-$Side

Validation with

JavaScript

$$ Utilise methods from the Object class where needed.

$$ Demonstrate understanding of the Object class and its

common methods.

$5$ marks

Advanced

CSS$3$ Features

$$ Utilise methods from the Object class where needed.

$$ Demonstrate understanding of the Object class and its

common methods.

$5$ marks

JavaScript

Functionality

$$ Utilise methods from the Object class where needed.

$$ Demonstrate understanding of the Object class and its

common methods.

The app should allow a user to search, borrow books. See the figures below: