Hi I am having some trouble on how to normalize some tricky tables.
Basically it is a recurrence event table that can either be daily, weekly, monthly or yearly.
I have made it so each recurrence row in the header table can have one id for either daily, weekly, monthly or yearly. This id corresponds to the appropriate table. Each table has different structures.
So here is an example of what I have.
Columns: RecurrenceId (PK), RecurrenceDailyId(FK), RecurrenceWeeklyId (FK),
RecurrenceMonthlyId (FK), RecurrenceYearlyId (FK)
Columns: RecurrenceDailyId(PK), EveryDays, DayOfWeek etc
Columns: RecurrenceWeeklyId(PK), EveryWeeks, TimesAWeek etc
What is the best way to create this structure so it is normalized? am I on the right path?