Database Documentation
The FSN database ER diagram project was started because of a lack of documentation for the FSN database schema. The database had been designed and created many years earlier, and had never enjoyed any type of documentation. Because the database schema was not a simple one, it made it difficult for me, as the only FSN developer, to write the ad-hoc queries that came along on a regular basis. Creating a detailed ER diagram would alleviate this issue.
Since no relational data existed in the database itself, it was necessary to analyze several hundred Java classes to determine relational data, including ids for the junction tables involved in the numerous many-to-many relationships. Other relational data was pulled from primary and foreign keys in the model classes.
