|
Development and implementation of a data model, with analysis of the process and the likely success of your approach. ...
Assumptions:
The following assumptions were made about the data after discussions with the Head of Medicines Management. ... It has been assumed that all the attributes will be populated with data, this may not happen initially but as recommendations and/or guidelines are produced the memNotes will be updated at a later stage, and will not contain null values. ... - limited to values: Yes, No
tblUserGP (intUsr_id, strGPCode, strSurgeryCode)
tblUserGP (Subtype of tblUser)
intUsr_ID Numerical Id of Person PRIMARY KEY
strGPCode National GP Code (individual to each person)
strSurgeryCode National GP Surgery Code (individual to each GP Surgery)
tblUserPharm (intUsr_id, strPharmIDCode, strPharmacyCode)
tblUserPharm (Subtype of tblUser)
intUsr_ID Numerical Id of Person PRIMARY KEY
strPharmIDCode National Pharmacist code (individual to each person)
strPharmacyCode National Pharmacy code (individual to each business)
tblDrugMan (strDrugMan_ID, strManContactName, strManAddress1, strManAddress2, strManPostcode, strManTel, strManFax)
tblDrugMan Drug Manufacturers
strDrugMan_ID Name of Company PRIMARY KEY
strManContactName Contact Namevat Manufacturers
strManAddress1 First line of address
strManAddress2 Second line of address
strManPostcode Postcode
strManTel Telephone number
strManFax Fax Number
tblBodyMedCare (strBodyMedCare_ID, memNotes, memLocalPolices)
tblBodyMedCare - Body of Medical Care
strBodyMedCare_ID Body of Medical Care PRIMARY KEY
memNotes Notes Relating to Body of Medical Care will never be a null value
memLocalPolices Local stance on Body of Medical Care will never be a null value
tblDrugSection (strDrugSection_ID, strBodyMedCare_ID, memNotes, enteredBy)
tblDrugSection - Family of Drugs
strDrugSection_ID Family of Drugs PRIMARY KEY
strBodyMedCare_ID Body of Medical Care Foreign Key (tblBodyMedCare)
memNotes Notes Relating to Drug Family will never be a null value
enteredBy User who entered the data Foreign Key (tblUser)
tblSubSection (strSubSection_ID, strDrugSection_ID, memNotes, enteredBy)
tblSubSection - Sub Family of Drugs
strSubSection_ID Sub Family of Drugs PRIMARY KEY
strDrugSection_ID Drugs Section Foreign Key (tblDrugSection)
memNotes Notes Relating to Drug Sub Family will never be a null value
enteredBy User who entered the data Foreign Key (tblUser)
tblDrugs (strDrugName_ID, strDrugMan_ID, strSubSection_ID, strGenericName, strAltGenericName, strProprietryName, memNotes, enteredBy)
tblDrugs Drug information
strDrugName_ID Drug Name PRIMARY KEY
strDrugMan_ID Drug Manufacturer Foreign Key (tblSubSection)
strSubSection_ID Sub Section Foreign Key (tblSubSection)
strGenericName Generic Drug name will not be null due to local polices on prescribing generic drugs
strAltGenericName Alternative Drug Name name will not be null due to local polices on prescribing generic drugs
strProprietryName Proprietry Name may be null on rare occasions
memNotes Notes on the specific drug
enteredBy User who entered the data Foreign Key (tblUser)
tblDocu (intDocRef_ID, strDrugName_ID, strDocLink, strDocTitle, memDocu)
tblDocu Drug documentation where applicable
intDocRef_ID Documentation ID PRIMARY KEY
strDrugName_ID Related to which Drug Name Foreign Key (tblDrugs)
strDocLink Document Link (web address, book title, jornal etc)
strDocTitle Title of document
memDocu Brief overview of documentation
tblSpecialMonitoring (strSpecMon_ID, strDrugName_ID, strTstBeforeTherapy, strTstDuringTherapy, memFrequency, memNotes)
tblSpecialMonitoring Drugs requiring special monitoring
strSpecMon_ID Id of special monitoring advice PRIMARY KEY
strDrugName_ID Drug Name Foreign Key (tblDrugs)
strTstBeforeTherapy Tests before drug therapy
strTstDuringTherapy Tests during drug therapy
memFrequency Frequency of drug intake
memNotes Any other info side-effects, special circumstances etc
tblFeeback (intFeedback_ID, intUsr_ID, dtmDateEntered, memComment)
tblFeedback Website feedback
intFeedback_ID Id of feedback item PRIMARY KEY
intUsr_ID User who entered the data Foreign Key (tblUser)
dtmDateEntered Date of Feedback entry
memComment Feedback text
Normalisation
Once the ER Model had been completed, top down normalisation was applied to the list of relations and attributes.
Approximate Word count = 1191
Approximate Pages = 4.8
(250 words per page double spaced)
|
|
