Hi All,
I need to create a star schema data model with all dimension table, could any one of you please suggest me .
I have tables like
Trial is table which contain all trials information Trial_ID, CreateDate, UpdatedDate.
Trial_Risk is table it contains data which trial had created the risks or issues Trial_ID, Risk_ID ,CreateDate, UpdatedDate
Trial_Action table has contain the data, if the users are entered any actions with Action CreateDate,actionduedate,Action complete date,Risk_ID,Action_ID.
Like this i have 4 Categories tables along with these tables Division,Category, Du Tables are there
how to create a good data model
Could any one you please suggest. Thanks a lot
