Normalization Question

[Elysium]

Can someone check my logic here? I have two tables and they are as follows:

Table: Factors
-------------------------
   Factor_RID (PK) =============
   Factor_Name                 +
-------------------------      +
                               +
Table: Elements                +
-------------------------      +
   Element_RID (PK)            +
   Factor_RID  (FK) ============
   Element_Name
   Element_Point_Value
-------------------------

You can see how the Factors table relates to the Elements table. My question is the following. I have a Factor called "Loyalty" which has 19 Elements. However, 3 of the Elements are such:

Corp Initiatives #1
Corp Initiatives #2
Corp Initiatives #3

Customer Relations Event #1
Customer Relations Event #2
Customer Relations Event #3

Center Manager Visit - Q1
Center Manager Visit - Q2
Center Manager Visit - Q3
Center Manager Visit - Q4

It doesn't make sense to me to have the three Elements split like this. I'm thinking they should be listed as:

Corp Initiatives
Customer Relations Event
Center Manager Visit

Every month, we are going to look at our customers to see which elements apply to them and then score them on these elements. I plan on using a seperate table to hold the Element_RID field from which I can calculate a score by Factor type. This will be done by multiplying the sum of each element-type count stored in this third table by the Element_Point_Value field in the Elements table.

I need some guidance on how to properly store the three fields listed above. Do I put them in a seperate table from the Elements table, or do I make space for them like they already have?

Randy

 

[SkipVought]

Hi

Some questions.

These 3 initiatives, 3 events and 4 visits -- are they related to each other in any way?

Will there ever be more initiatives or more events or more visits?

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[Elysium]

They are not related in any way, and yes, I would assume that there could be more (because it always works out that way here!). That's why I'm more of the mind that they need to reside in another table.

Randy

 

[SkipVought]

Ah, the Socratic method! ;-)

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[Elysium]

No answer?

Randy

 

[SkipVought]

YOU answered the question.

That's why I'm more of the mind that they need to reside in another table.

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}