We intend to create a 'Data Warehouse' for a management system for a library network.

The database must store information about books, libraries, loans made, readers and book reserves.

Books: must have an identifier, title, author, genre and year of publication.

Libraries: must record the identifier, capacity and location.

Loans: must record the identifier, the loan date, the return date, the book and reader identifier.

Readers: must have an identifier, name, and date of birth.

Reservations: must register the identifier, the date of the reservation, the reserved book and the library where it will be collected.

Define the fact table first. Next, define dimensions for the 'Data Warehouse' and display the associated fact table.

After that $,$ answer this question

How do dimension tables and fact tables differ in terms of structure and purpose? Give an example using the tables from the previous question.