Project Problem Scenario:

You've been entrusted with enhancing the database design of the library management system. The current setup employs a denormalized table that combines information about books, authors, students, and book borrowings. Your mission is to apply the principles of normalization to foster data integrity and eliminate redundancy.

From the above problem scenario, we created only one table $($Figure$-01).$ Hence, we have lots of redundancies or duplication in the following denormalized table $($Figure$-01).$ Following is the snapshot of the denormalized table. Now our job will be to split the denormalized table into multiple tables $($Considering various entities exist in the problem scenario$).$

Denormalized Table:

The denormalized table encompasses various attributes $($fields$),$ such as ISBN, title, author, author nationality, publisher, genre, student ID$,$ student name, student phone number, borrowing date, and due date.