This star schema data model, is this the right relationship for 1 to many? Isn’t it the other way around?
If there are multiple rental reservations for one customer, then I thought the one to many relationship in the diagram would be the opposite. Can someone please enlighten me on this?
Hello @hiroaki9342
The model is actually useful for many to many relationships. You can map as many cars as you want to as many customers you want using the fact table since each row represents a car rental by some customer. You can have a customer renting multiple cars, or a car being rented by multiple customers.
I hope it helps.
Hi @Amir_Zare,
Thank you!
Does this mean that this relationships should be many to many after all?
You are welcome. Yes, in this case the relationship between the customers and the cars is many to many.
