Many of the tips that I am going to give are from this excellent book that I want to recommend: Fundamentals of Database Systems, 7th Edition
Ramez Elmasri, University of Texas at Arlington Shamkant B.www.pearson.com Informal guidelines for relation design: