I am new to data warehouse modelling so please bear with me.
In database warehouse modelling, the star schema is typically a fact table with multiple dimensions connected directly to it. However, what if there are two or more fact tables in the schema and some of the dimensions are related? Please see below as an example:
Is it allow to draw a line to relate the dimension tables in star schema database warehouse modelling? For example, assume
customers, can I draw the line between the two table in the star schema since a hotel room has many customers staying?
In all the examples I searched online, the star schema is always connected to dimension tables and these tables are not drawn with a line to connect it.