The Area being Modelled is :-
A Library Asset Register

Detailed Requirement :-
Question: I would like to get assistance with designing the database for my company's asset registering system.
The library does not only store books, also audio and video material belong to the library.

I have to catalog the library items, also keep record of book circulation and reservation details.