DatabaseHere is an entity-relationship diagram of the database used in the Healthcare E-Prescription App.DRUGintIDPKintFORMFKstringNAMEfloatPRICEstringACTIVE_SUBSTANCEstringDESCRIPTIONstringSIDE_EFFECTSstringSTORAGE_CONDITIONSDRUG_FORMintIDPKstringNAMEINSURANCE_COMPANYintIDPKintCODEstringABBREVIATIONstringNAMEstringSTREETintHOUSEstringCITYintPSCPATIENTintIDPKintINSURANCE_COMPANY_IDFKstringFIRST_NAMEstringMIDDLE_NAMEstringLAST_NAMEdateDATE_OF_BIRTHstringPHONEstringEMAILstringSTREETintHOUSEstringCITYintPSCDOCTORintIDPKintSPECIALIZATION_IDFKstringTITLEstringFIRST_NAMEstringMIDDLE_NAMEstringLAST_NAMEdateDATE_OF_BIRTHstringPASSWORD_HASHstringPHONEstringEMAILSPECIALIZATIONintIDPKstringNAMEPRESCRIPTIONintIDPKintPATIENT_IDFKintISSUED_BY_DOCTOR_IDFKDATEISSUED_DATEDATEVALID_UNTILENUMSTATUSENUMTYPEPRESCRIPTION_ITEMintIDPKintPRESCRIPTION_IDFKintDRUG_IDFKintQUANTITYstringDOSAGEstringINSTRUCTIONSbooleanPICKED_UPhashasspecializeshasincludesissued forissued byLast modified: 04 February 2024AnalysisRequirements