@PaulVargas As for the logical data modeling (or database design, or database architecture) part, I suggest studying
Integrated Definition for Information Modeling (IDEF1X), which is a technique that was established as a standard by the United States National Institute of Standards and Technology (NIST).