Being a newbie to access, I have been given a task of creating a db for the
patient management and tracking. This DB will have around 50 patients per
year. It will contain the history of patient's contact info, pediatrician,
case manager,Genetic center info, Insurance info and so on. I have created
the tables. pls review them and suggest me your ideas to improve the DB, as
mine maynot be best.

tblPatients
RegID - PK
PatientID,FirstName,LastName,DOB,Gender,Hospital,M A,CaseStatus,Diagnosis,Address,City,Zip,county,MFi rstName(mom),MLastName,MAddress,MCity,MState,MZip, MHomePhone,MCellPhone,MWorkPhone,FFirstName(Father ),FLastName,FAddress,FCity,FState,FZip,FHomePhone, FcellPhone,CurrentPed,FormerPed,GenCenter,Genetici st,CaseManager,CaseManagement

tblPediatrician_1 and also tblPediatrician_2
PedID-PK,LastName,FirstName,MI, Practicie,Address,City,State,Zip,Phone,Fax

tblGenCenter
center_Id-PK,Name,Address,City,state,zip,phone,Fax

tblGencounselor
CounselorID-PK,FName,LName,Phone,Pager,Fax

tblCaseMgr
MgrID-Pk,FName,LName,Phone,Pager,Fax

tblCaseMgmt
MgmtId-Pk,Name, address,........

tblInsurance
InsuranceID-Pk,Type,AgencyName,ContactFName,ContactLName,phone ,fax,insuranceName,policyno,CS_Phone

tblInsuranceType
InsuranceType-ID-Pk,RegID,InsuranceID

tblGuardian
guardianId-pk,Refdate,type,fName,LName,address,state,city,zip ,hPhone,Cphone,wphone

tblpatientguardian
patguardianID-Pk
Regid
GuardianID