 There is a one-to-many relationship between records in codice_2 and records in codice_3 because patients can have many encounters and each encounter involves only one patient.A "one-to-one" relationship is mostly used to split a table in two in order to provide information concisely and make it more understandable.In the hospital example, such a relationship could be used to keep apart doctors' own unique professional information from administrative details.