Using the data model and the database design created in the second project assignment which depicts the following entities * PATIENTINFO table with the following column:s 3. LastName 4. Address 5. City 6. State 7. ZipCode 8. Phone 9. Email 10. MemberlD Select the proper data type, size and the proper nullot null constraints as needed. In addition you need to assign primary key PATIENTMHIS table with the following columns . 2. 3. CardioHist 5. AlergyHist 6. BloodHist 7. Hospitalization 8. 9. SurgerxHis Select the proper data type, size and the proper nullot null constraints as needed. In addition you need to assign primary key IMAGINGORDER table with the following columns . 3. Organ 4. Reason 5. Diagnosis Select the proper data type, size and the proper nullot null constraints as needed. In addition you need to assign primary key . LABORDER table with the following columns: La 4. Reason