Hello All,
I have a database that has a few tables and I was wondering if anyone would be able to tell me if I am close to having a Normalized Database.
I have attached a pic of my table relationships.
I think I need to have a FK for CFD Witnesses, Focus, Complainant, and Civilian Witnesses (but I am not exactly sure of this).
Also, would I need to create a seperate table for the complaints? I also thought of a creating a seperate table for the time line, but not sure how to give this a FK to the main table.
I have a database that has a few tables and I was wondering if anyone would be able to tell me if I am close to having a Normalized Database.
I have attached a pic of my table relationships.
I think I need to have a FK for CFD Witnesses, Focus, Complainant, and Civilian Witnesses (but I am not exactly sure of this).
Also, would I need to create a seperate table for the complaints? I also thought of a creating a seperate table for the time line, but not sure how to give this a FK to the main table.