DATABASE SQLCREATE TABLE PATIENT_RECORD(RECORD_ID INT PRIMARY KEY,PATIENT_ID INT NOT NULL,TREAT_ID INT NOT NULL,MED_ID INT NOT NULL,QUANTITY_MED VARCHAR(64) NOT NULL,DATE DATE,COMPLAINT TEXT NOT NULL,MEDICAL_FINDINGS TEXT NOT NULL,DOC_INCHARGE VARCHAR(64) NOT NULL,FOREIGN KEY(PATIENT_ID)REFERENCES PATIENT(PATIENT_ID),FOREIGN KEY(TREAT_ID)REFERENCES TREATMENT(TREAT_ID),FOREIGN KEY(MED_ID) REFERENCES MEDICINE(MED_ID));INSERT PATIENT RECORD DATA RECORD_IDPATIENT_IDTREAT_IDMED_IDQUANTITY_MEDDATECOMPLAINTMEDICAL_FINDINGSDOC_INCHARGE100011003232 10mg2020-12-10Food allergyPatient allergic to seafoodJoseph Liam10101100223410mg2020-12-10High Blood TestThe blood test result is high and abnormalNurhidayat Bin Anuar 10202100323310mg 2020-12-10CoughProductive cough. Yellow mucus detectedJoseph Liam103031002235100mg2020-12-10Chest pain and nauseaPatient suffer from high cholesterolNurhidayat Bin Anuar 104041002235100mg2020-12-10Headache and irregular heartbeatPatient blood pressure high and abnormalNurhidayat Bin Anuar 105051004238500mg2020-12-11Minor burns on left arm Second degree burns on patient's left armAiden Benjamin Poon 106061003231500mg2020-12-11Headache and fluPatient body temperature high Joseph Liam107071002234 10mg 2020-12-11Experienced chest pain and nauseaPatient blood pressure and pulse rate are abnormalNurhidayat Bin Anuar 10808100223640mg2020-12-11Experienced chest pain and nauseaPatient cholesterol level is high and abnormalNurhidayat Bin Anuar 109091003237120 doses2020-12-11Shortness of breath and coughingPatient have asthma attack Joseph Liam11009100324424 tablets2020-12-11Watery eyes, itching and hivesPatient have allergy reaction to bee stingsJoseph Liam111101002235100mg2020-12-12Chest pain and nauseaPatient suffer from high cholesterolNurhidayat Bin Anuar 112111004239200mg2020-12-12Pain and swelling on right handFirst degree burn on patient’s right handAiden Benjamin Poon 113121002241850mg2020-12-12Massive headache and nauseaBlood pressure is high and low sugar levelNurhidayat Bin Anuar114131002242500mg2020-12-12Sudden increased of thirst,hunger and urinationPatient suspected to suffer diabetes Nurhidayat Bin Anuar11513100323310mg2020-12-12Cold and coughPatient suffer from severe cold and coughJoseph Liam116021003243500mg2020-12-13Massive headache and nauseaPatient suffer from migraineJoseph Liam117031004240200mg2020-12-13Severe pain on index fingerSmall glass fragments detected on patient fingerAiden Benjamin Poon 11805100223410mg2020-12-13Severe headache and chest painPatient blood pressure is high and abnormalNurhidayat Bin Anuar11902100323210mg2020-12-13Sneezing and watery eyesPatient suffer from pollen allergyJoseph Liam12006 1002235100mg2020-12-13Massive headachePatient blood pressure is high and abnormalNurhidayat Bin Anuar ATTRIBUTESRECORD_IDDESCRIPTIONDATA TYPE LENGTH CONSTRAINTStore the patientINT11Primary Keyrecord ID number• Required attribute• Store the patient IDPATIENT_IDINT11Foreign Keynumber• Required attribute• Store the patientTREAT_IDINT11Foreign Keytreatment IDnumber• Required attribute• Store the medicineMED_IDINT11Foreign KeyID of the patient• Required attribute• Store the quantity ofMED QUANTITYINT11Foreign Keymedicine receivedby the patientDATE• Store the date ofDATENot NULLpatient check-upCOMPLAINT• Store the complaintTEXTNot NULLfrom the patient• Multivalued attributeMEDICAL_FINDINGSStore the medicalTEXTNot NULLfindings of thepatient• Multivalued attribute• Store the name ofDOC_INCHARGEVARCHAR64Not NULLthe doctor incharged for thepatient

Question

DATABASE SQLCREATE TABLE PATIENT_RECORD(RECORD_ID INT PRIMARY KEY,PATIENT_ID INT NOT NULL,TREAT_ID INT NOT NULL,MED_ID INT NOT NULL,QUANTITY_MED VARCHAR(64) NOT NULL,DATE DATE,COMPLAINT TEXT NOT NULL,MEDICAL_FINDINGS TEXT NOT NULL,DOC_INCHARGE VARCHAR(64) NOT NULL,FOREIGN KEY(PATIENT_ID)REFERENCES PATIENT(PATIENT_ID),FOREIGN KEY(TREAT_ID)REFERENCES TREATMENT(TREAT_ID),FOREIGN KEY(MED_ID) REFERENCES MEDICINE(MED_ID));INSERT PATIENT RECORD DATA RECORD_IDPATIENT_IDTREAT_IDMED_IDQUANTITY_MEDDATECOMPLAINTMEDICAL_FINDINGSDOC_INCHARGE100011003232 10mg2020-12-10Food allergyPatient allergic to seafoodJoseph Liam10101100223410mg2020-12-10High Blood TestThe blood test result is high and abnormalNurhidayat Bin Anuar 10202100323310mg 2020-12-10CoughProductive cough. Yellow mucus detectedJoseph Liam103031002235100mg2020-12-10Chest pain and nauseaPatient  suffer from high cholesterolNurhidayat Bin Anuar 104041002235100mg2020-12-10Headache and irregular heartbeatPatient blood pressure high and abnormalNurhidayat Bin Anuar 105051004238500mg2020-12-11Minor burns on left arm Second degree burns on patient's left armAiden Benjamin Poon 106061003231500mg2020-12-11Headache and fluPatient body temperature high Joseph Liam107071002234 10mg 2020-12-11Experienced chest pain and nauseaPatient blood pressure and pulse rate are abnormalNurhidayat Bin Anuar 10808100223640mg2020-12-11Experienced chest pain and nauseaPatient cholesterol level is high and abnormalNurhidayat Bin Anuar 109091003237120 doses2020-12-11Shortness of breath and coughingPatient have asthma attack  Joseph Liam11009100324424 tablets2020-12-11Watery eyes, itching and hivesPatient have allergy reaction to bee stingsJoseph Liam111101002235100mg2020-12-12Chest pain and nauseaPatient  suffer from high cholesterolNurhidayat Bin Anuar 112111004239200mg2020-12-12Pain and swelling on right handFirst degree burn on patient’s right handAiden Benjamin Poon 113121002241850mg2020-12-12Massive headache and nauseaBlood pressure is high and low sugar levelNurhidayat Bin Anuar114131002242500mg2020-12-12Sudden increased of thirst,hunger and urinationPatient suspected to suffer  diabetes Nurhidayat Bin Anuar11513100323310mg2020-12-12Cold and coughPatient  suffer from severe cold and coughJoseph Liam116021003243500mg2020-12-13Massive headache and nauseaPatient suffer from migraineJoseph Liam117031004240200mg2020-12-13Severe pain on index fingerSmall glass fragments detected on patient fingerAiden Benjamin Poon  11805100223410mg2020-12-13Severe headache and chest painPatient blood pressure is high and abnormalNurhidayat Bin Anuar11902100323210mg2020-12-13Sneezing and watery eyesPatient suffer from pollen allergyJoseph Liam12006 1002235100mg2020-12-13Massive headachePatient blood pressure is high and abnormalNurhidayat Bin Anuar ATTRIBUTESRECORD_IDDESCRIPTIONDATA TYPE LENGTH CONSTRAINTStore the patientINT11Primary Keyrecord ID number• Required attribute• Store the patient IDPATIENT_IDINT11Foreign Keynumber• Required attribute• Store the patientTREAT_IDINT11Foreign Keytreatment IDnumber• Required attribute• Store the medicineMED_IDINT11Foreign KeyID of the patient• Required attribute• Store the quantity ofMED QUANTITYINT11Foreign Keymedicine receivedby the patientDATE• Store the date ofDATENot NULLpatient check-upCOMPLAINT• Store the complaintTEXTNot NULLfrom the patient• Multivalued attributeMEDICAL_FINDINGSStore the medicalTEXTNot NULLfindings of thepatient• Multivalued attribute• Store the name ofDOC_INCHARGEVARCHAR64Not NULLthe doctor incharged for thepatient

Accepted Answer

PATIENT, MEDICINE, TREATMENT are the parent tables whereas PATIENT_RECORD is the child table
So,…

RECORD_ID	PATIENT_ID	TREAT_ID	MED_ID	QUANTITY_MED	DATE	COMPLAINT	MEDICAL_FINDINGS	DOC_INCHARGE
100	01	1003	232	10mg	2020-12-10	Food allergy	Patient allergic to seafood	Joseph Liam
101	01	1002	234	10mg	2020-12-10	High Blood Test	The blood test result is high and abnormal	Nurhidayat Bin Anuar
102	02	1003	233	10mg	2020-12-10	Cough	Productive cough. Yellow mucus detected	Joseph Liam
103	03	1002	235	100mg	2020-12-10	Chest pain and nausea	Patient suffer from high cholesterol	Nurhidayat Bin Anuar
104	04	1002	235	100mg	2020-12-10	Headache and irregular heartbeat	Patient blood pressure high and abnormal	Nurhidayat Bin Anuar
105	05	1004	238	500mg	2020-12-11	Minor burns on left arm	Second degree burns on patient's left arm	Aiden Benjamin Poon
106	06	1003	231	500mg	2020-12-11	Headache and flu	Patient body temperature high	Joseph Liam
107	07	1002	234	10mg	2020-12-11	Experienced chest pain and nausea	Patient blood pressure and pulse rate are abnormal	Nurhidayat Bin Anuar
108	08	1002	236	40mg	2020-12-11	Experienced chest pain and nausea	Patient cholesterol level is high and abnormal	Nurhidayat Bin Anuar
109	09	1003	237	120 doses	2020-12-11	Shortness of breath and coughing	Patient have asthma attack	Joseph Liam
110	09	1003	244	24 tablets	2020-12-11	Watery eyes, itching and hives	Patient have allergy reaction to bee stings	Joseph Liam
111	10	1002	235	100mg	2020-12-12	Chest pain and nausea	Patient suffer from high cholesterol	Nurhidayat Bin Anuar
112	11	1004	239	200mg	2020-12-12	Pain and swelling on right hand	First degree burn on patient’s right hand	Aiden Benjamin Poon
113	12	1002	241	850mg	2020-12-12	Massive headache and nausea	Blood pressure is high and low sugar level	Nurhidayat Bin Anuar
114	13	1002	242	500mg	2020-12-12	Sudden increased of thirst,hunger and urination	Patient suspected to suffer diabetes	Nurhidayat Bin Anuar
115	13	1003	233	10mg	2020-12-12	Cold and cough	Patient suffer from severe cold and cough	Joseph Liam
116	02	1003	243	500mg	2020-12-13	Massive headache and nausea	Patient suffer from migraine	Joseph Liam
117	03	1004	240	200mg	2020-12-13	Severe pain on index finger	Small glass fragments detected on patient finger	Aiden Benjamin Poon
118	05	1002	234	10mg	2020-12-13	Severe headache and chest pain	Patient blood pressure is high and abnormal	Nurhidayat Bin Anuar
119	02	1003	232	10mg	2020-12-13	Sneezing and watery eyes	Patient suffer from pollen allergy	Joseph Liam
120	06	1002	235	100mg	2020-12-13	Massive headache	Patient blood pressure is high and abnormal	Nurhidayat Bin Anuar