CODEWITHSUNDEEP
databasedata-warehouse
Ali
Ali

Reputation: 33

Many to many dimension table Library Database

I need to find which category of books were the most borrowed. So, I have the following UML diagram.Library UML

So when making the dimension tables and fact table I've come up up with the following: Dimension tables and fact table

But the Auth (dimension)association table doesn't seem right. Is there a mistake and how can I correct it? Edit: Probably Category and Publisher dimension tables shouldn't be there. They should be attached with book.

Upvotes: 1

Views: 1221

Answers (1)

RADO
RADO

Reputation: 8148

your dimensional model needs to be redesigned.

Fact table must be "Auth" with the following fields:

  • Staff_ID
  • Student_ID
  • Book_ID
  • Issued_Date
  • Borrowed_Till

Then you need 4 dimension tables:

  • Staff (contains Staff key, Staff attributes, Library attributes)
  • Student (Student key, Student attributes)
  • Book (Book key, Book attributes, Publisher, Category)
  • Calendar (Date key, calendar attributes) you might need a second Calendar for Borrowed_Till.

Upvotes: 2

Related Questions