this is a database for hospital management system there are 7 tables followed by their attributes in a parenthesis please create the tables in mysql and show the primary key and foreign key relationship and show some examples by doing queries that table work

Patient(SSN, fullName, gender, dateofeirth, address, honeNumber emereenc ContactNumbeo Emergency Contact (SSN, fullname, phonenumber) Doctor DectorlD, fullname, SSN) RatientRecordISSN, addmissionDate, ReleaseDate, fees) PatientDiagnosis(SSN, diagnosislD, diagnosisName dateOfDiagnosis) PatientDruETreatment(SSN, diagnosisD, druBID, drugName) PatientSurgeries(SSN, surgery Name, surgerylD, beginDate, endDate, results