I must admit that I am somewhat new to effective database normalization. I currently doing a site that lists all historical monuments in Tennessee. Here is my situation I have several fields - The basic ones are not a problem.
Main Table
- Monument ID
- Name
- Theme
- Condition
- Form
- Material
- County (?)
- Grand Division of State (?)
Image Table
- Image ID
- RelMonument ID
- Image Name
- Image Path
Inscriptions
- Inscription ID
- Rel Monument ID
- Inscription Name
- Inscription Text
This is my basic Design. However I will have a lot of repeating elements in the County and Grand Division fields of the main table. How do I solve that? Also I have not addressed the many - to - many relationship (fourth nominal form) in this database schema. Is my current design ok, does it need improvements? Let me know.
Main Table
- Monument ID
- Name
- Theme
- Condition
- Form
- Material
- County (?)
- Grand Division of State (?)
Image Table
- Image ID
- RelMonument ID
- Image Name
- Image Path
Inscriptions
- Inscription ID
- Rel Monument ID
- Inscription Name
- Inscription Text
This is my basic Design. However I will have a lot of repeating elements in the County and Grand Division fields of the main table. How do I solve that? Also I have not addressed the many - to - many relationship (fourth nominal form) in this database schema. Is my current design ok, does it need improvements? Let me know.