Forum Discussion
Solved
I am stuck on budling relationship between date different table
I have say 4 tables Sales register,purchase,salary,production i have data in day basis in some table and month basis in some table so i have created month column in all table and trying to build re...
see if you can classify your tables as dimension tables or fact tables. How do they control each other?
Ideally you have a star schema with 1:* single direction relationships.
You may want to add a calendar table to your data model.
lbendlin
Super User
Super Usersee if you can classify your tables as dimension tables or fact tables. How do they control each other?
Ideally you have a star schema with 1:* single direction relationships.
You may want to add a calendar table to your data model.