Solve this

Project Title: Design and Implementation of a Database System for a University Library

Objective:

$-$ Design a database schema for a university library system

$-$ Implement the database using a suitable DBMS $($e$.$g$.,$ MySQL$,$ Oracle$)$

$-$ Develop a user interface $($e$.$g$.,$ web$-$based or desktop application$)$ to interact with the database

$-$ Demonstrate data management and querying capabilities

Requirements:

$-$ Database design should include entities and attributes for books, authors, borrowers, loans, and fines

$-$ Database should support queries for searching books, borrower information, and loan history

$-$ User interface should allow for data entry, update, and deletion

$-$ System should demonstrate data consistency, integrity, and security measures

Deliverables:

$-$ Database design document $($entity$-$relationship diagram, schema definition$)$

$-$ Database implementation $($SQL scripts, database files$)$

$-$ User interface application $($web or desktop$)$

$-$ User manual and guide

$-$ Demonstration of system functionality and queries