Hello,
I am a medic and trying a develop a small database for our clinic. The purpose of the design is to accept pathology test request from patients and pass these details to labs who will update the status and results accordingly. Please let me know if the following tables are normalised.
TableName: PatientDetails
patientRef
surname
firstname
dob
address1
address2
address3
postcode
consentpost
mobile
consentMobile
telephone
consentTelephone
ethnicity
sex
TableName: Test
testID
patientRef
staffID
screeningSitecode
testDateRequested
TableName: TestDetails
testID
patientRef
reasonForTest
SpecimenType
testResults
testStatus
stisymptoms
testResultsdateCompleted
Tablename: Staff
staffID
Staffname
staffdepartment
staffrole
staffloginID
staffpassword
access_level
Table – ScreeningLocation
screeningSitecode
screeningSiteName
Table – Drugs
drugID
drugName
Dose
Table – Partner
partnerID
patientRef
partnername
partnerphonenumber
Table: Drug Prescription
drugID
testID
patientRef
Many thanks
steven