Web Library

The design and implementation of a library database accessible via the web

With emphasis on relational algebra, database design, query optimisation, and responsive web design.

Tech Stack

• Modeling language: entity-relationship model (Chen notation)

• Server-side: PHP 8.0.9 and Oracle SQL 19c

• Client-side: HTML5, CSS3, Bootstrap 5

• Data generation: Java with JDBC

Deployment

1. set up a local database using Oracle's RDBMS and modify your database credentials in the databasehelper file accordingly

2. run the drop.sql and create.sql files in that order on your local server in order to instantiate all the necessary relations along with their integrity and reference constraints

3. either run the dml.sql file to populate the database you've now created with some test data or run the [REMOVED] (eg. in bash: java -jar TestdataGenerator.jar) for a larger set of tuples (thousands of rows)

4. open the index.php file in your browser

Diagram

entity-relationship diagram

Specifications

Conceptual design

Screenshot of the Final Website

The website is designed with responsiveness in mind and thus maintains visual clarity regardless of the device it is viewed on.

Desktop

Tablet

Smartphone