Question
-
Topic
-
Help with normalisation
LockedHello,
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
sexTableName: Test
testID
patientRef
staffID
screeningSitecode
testDateRequestedTableName: TestDetails
testID
patientRef
reasonForTest
SpecimenType
testResults
testStatus
stisymptoms
testResultsdateCompletedTablename: Staff
staffID
Staffname
staffdepartment
staffrole
staffloginID
staffpassword
access_levelTable – ScreeningLocation
screeningSitecode
screeningSiteNameTable – Drugs
drugID
drugName
DoseTable – Partner
partnerID
patientRef
partnername
partnerphonenumberTable: Drug Prescription
drugID
testID
patientRefMany thanks
steven