There are two type tables
1)Master table
2)Transaction Table
where PetientMaster is the table where the details of petient will be entered
then PetientVisitor table this table is transaction table where the connection between these two tables is id of PetientMaster table as PetientId in PetientVisitor table.
And the fields(columns for PetiendVisitors table you can add Following
1.Id
2.PetientId
3.NameOfVisitor
4.Gender
5.Age
6.TypeOfVisitor
7.RelationWithPetient
8.AddressOfVisitor
9.MobileNo
10.PhotoOfVisitor
11.IdentityNumber
where TypeOfVisitor :Doctor,Nurse,Relatives,officeBoy..etc.
The idea behind creating TransactionTable (PetientVisitor) is we can capture more information about visitors for safety.
So i believe by this you got little bit idea.
Good Luck