Forum Discussion
Power ParticipantHow can I best create a data model from these tables?
I am trying to create a data model from these tables but I'm not sure of the best way to split the tables and reorganize them would be. I'm familar with the star schema and normalization. However I'm just not sure what principal to apply when spltting and regrouping columns. Any suggestions would be greatly appreciated.
3 Replies
- lbendlin
Super User
You are missing a couple of dimensions. Customer/delinquent; Officer/agent; Dates and probably a few more.
You have multiple facts (arraignments, appeals etc) that you likely need to treat as independent facts (ie not linked to each other, only linked from the dimensions
For yor modeling you only need to focus on the linking (key) columns, you can collapse the rest
HamidBeeThanks for your reply. I'll definitely give it a go and see where it takes me. I tried using Table Analyzer in Access just to normalize one of the tables:
Using 'Table Analyzer' in Access this is what it broke it down to:
I'm new to normalization but something tells me this is wrong.
- lbendlin
There are many levels of normalization (from First Form to Sixth Form) - it's up to you to find a balance between them depending on your actual business scenario. No need to go all scientific on this.
