You will need to look closely at patient and patient charges tables to determine the type of relationship. Can a patient have a charge without being in the patient table? Should a patient have a single charge or can the patient have multiple charges? This will help you in determining the relationship between the tables. When you are talking about a diagram are you talking about UML?