Відео

@@donghachung I will share the code later wait for it in the description but up till now it's predefined frequencies to play a song. Thx for your idea I would do it by the time the code's available.

I've already made the changes! Check out the new video or the updated code in the description for the multi-input feature. Thanks for the suggestion!

اهم من الشغل تظبيط الشغل

drive.google.com/file/d/1GF-FynkMseVaFjs0UHZp4OkshIW1DIBO/view?usp=sharing اهم معلومات المشروع موجودة هنا جداول كاملة لا تقدر تكملها لكن خلقت إمكانية انك تدخل في الجداول الي محتاجها

www.dropbox.com/scl/fi/z5do1mxx1o2866f3m68oj/DataBase-4-compressed-1.pdf?rlkey=h48uujbvox2wj5d7apcro3q6a&dl=0 الlink شغال بس يمكن المشكلة من الdrive فرفعته dropbox

% Define the database connection properties driver = 'com.mysql.jdbc.Driver'; url = 'jdbc:mysql://localhost:3306/mydatabase'; username = 'myusername'; password = 'mypassword'; % Create the database connection conn = database('mydatabase', username, password, driver, url); % Execute the SQL commands to create the tables exec(conn, 'CREATE TABLE Patient (SID_P INTEGER NOT NULL, PatientID_P INTEGER, PatientName CHAR(20), Gender CHAR(20), Addres CHAR(20), PhoneNumber_P INTEGER NOT NULL, UNIQUE (SID_P), PRIMARY KEY (PatientID_P), UNIQUE(PhoneNumber_P))'); exec(conn, 'CREATE TABLE Room (RoomID INTEGER, Type_of_room CHAR(20), NoOfDayes CHAR(20), PRIMARY KEY (RoomID))'); exec(conn, 'CREATE TABLE Staff (SID_S INTEGER, AreaHandle CHAR(20), Name_S CHAR(20), PhoneNumber_S INTEGER NOT NULL, PRIMARY KEY (SID_S), UNIQUE(PhoneNumber_S))'); exec(conn, 'CREATE TABLE Nurse_Belongs_To (SID_S INTEGER, Age INTEGER, NO_OF_DAYS_WORKED INTEGER, PRIMARY KEY (NO_OF_DAYS_WORKED,SID_S), FOREIGN KEY (SID_S) REFERENCES Staff ON DELETE NO ACTION)'); exec(conn, 'CREATE TABLE Ward_boy_Care_Belongs_To (SID_S INTEGER, Age INTEGER, NO_OF_DAYS_WORKED INTEGER, PRIMARY KEY (NO_OF_DAYS_WORKED,SID_S), FOREIGN KEY (SID_S) REFERENCES Staff ON DELETE NO ACTION)'); exec(conn, 'CREATE TABLE Treatment (Treatmentcode INTEGER, DiseaseName_T CHAR(20), Description_T CHAR(20), PRIMARY KEY (Treatmentcode))'); exec(conn, 'CREATE TABLE Bill_Payed_By (PatientID_P INTEGER, Bill_ID INTEGER, NoOfDayes CHAR(20), fees REAL, PRIMARY KEY (Bill_ID,PatientID_P), FOREIGN KEY (PatientID_P) REFERENCES Patient ON DELETE NO ACTION)'); exec(conn, 'CREATE TABLE Disease (DiseaseName INTEGER, Symptoms CHAR(20), PRIMARY KEY (DiseaseName))'); exec(conn, 'CREATE TABLE Doctor (DoctorID_D INTEGER, Speciallization CHAR(20), Doctor_Name CHAR(20), Qualification CHAR(30), Phone_Number INTEGER NOT NULL, UNIQUE(Phone_Number), PRIMARY KEY (DoctorID_D))'); exec(conn, 'CREATE TABLE Assigned (RoomID INTEGER, PatientID_P INTEGER, PRIMARY KEY (RoomID), FOREIGN KEY (RoomID) REFERENCES Room, FOREIGN KEY (PatientID_P) REFERENCES Patient)'); exec(conn, 'CREATE TABLE Care (SID_S INTEGER, PatientID_P INTEGER, PRIMARY KEY (SID_S,PatientID_P), FOREIGN KEY (SID_S) REFERENCES Staff, FOREIGN KEY (PatientID_P) REFERENCES Patient)'); exec(conn, 'CREATE TABLE Maintain (SID_S INTEGER, RoomID INTEGER, PRIMARY KEY (SID_S,RoomID), FOREIGN KEY (SID_S) REFERENCES Staff, FOREIGN KEY (RoomID) REFERENCES Room)'); exec(conn, 'CREATE TABLE Treats (DoctorID_D INTEGER, PatientID_P INTEGER, PRIMARY KEY(DoctorID_D), FOREIGN KEY (DoctorID_D) REFERENCES Doctor, FOREIGN KEY (PatientID_P) REFERENCES Patient)'); exec(conn, 'CREATE TABLE Super_Form (DiseaseName INTEGER, PatientID_P INTEGER, PRIMARY KEY(PatientID_P), FOREIGN KEY (DiseaseName) REFERENCES Disease, FOREIGN KEY (PatientID_P) REFERENCES Patient)'); exec(conn, 'CREATE TABLE Gets (Treatmentcode INTEGER, PatientID_P INTEGER, PRIMARY KEY(PatientID_P), FOREIGN KEY (Treatmentcode) REFERENCES Treatment, FOREIGN KEY (PatientID_P) REFERENCES Patient)'); % Close the database connection close(conn);

كيف بدي ادخل ع مات لاب @@ahmedmohamedabdelmonaemmoh3508

Done