Diagnostics DiagNo O Description Cost Admissions AdmitNo Patid Diag_code Admit_Doct Admission Date Discharge Date Patients Patid...

 

Transcribed Image Text:

Diagnostics DiagNo O Description Cost Admissions AdmitNo Patid Diag_code Admit_Doct Admission Date Discharge Date Patients Patid first_Name last Name DOB Address City State Zip Phone Doctors Doctor_ld first_Name last_Name speciality 1. Describe the type of relationship (One-to-Many, Many-to-Many, One-to-One) between the following tables, using the Database Diagram (SolTClinic) as a guide: Patients and Admissions (please supply the primary key as well as any foreign key if applicable) Admissions and diagnostics (please supply the primary key as well as any foreign key if applicable) Doctors and Admissions (please supply the primary key as well as any foreign key if applicable). Diagnostics DiagNo O Description Cost Admissions AdmitNo Patid Diag_code Admit_Doct Admission Date Discharge Date Patients Patid first_Name last Name DOB Address City State Zip Phone Doctors Doctor_ld first_Name last_Name speciality 1. Describe the type of relationship (One-to-Many, Many-to-Many, One-to-One) between the following tables, using the Database Diagram (SolTClinic) as a guide: Patients and Admissions (please supply the primary key as well as any foreign key if applicable) Admissions and diagnostics (please supply the primary key as well as any foreign key if applicable) Doctors and Admissions (please supply the primary key as well as any foreign key if applicable).