The design of any application depends on the foundation of its data model. We must all accept the simple fact that the decisions made during the data modeling phase will determine the overall success of the application.   Before we address any specific data modeling topics or problems, we must talk about the philosophy that will provide the [...]

Enity relationship diagrams are your calling. Making sure the data fits the physical structures and all is optimize to leverage the database technology to its fullests. Welcome to the craft, you are a data modeler.