Please I'm struggling with the conception this is the Relational diagram of my database:
so production order has only one machine, and it has its start and end date and quantity to produce. the step has the production each day for a specific order.
what I did is
I create a Dimension called production order that has (Start date, end date, quantity, and id)
-dimension machine
-dimension date to design production date
-dimension etat (yes or no) yes if the production is ended (today's date > enddate)
-dimension failed (yes or no) if we produced all the quantity before end date
-fact is stepProduction has id_machine and id_ordreprod and id_date and the quantity.
But someone told me I should relate my fact 3time with the date dimension so I shouldn't put the start date and end date dimension.
so please could someone tell me what I did is right !! Thank you