I need help with steps 1 , 2 and 3!

I need to see what the final ER Diagram and Relational Schema will look like for step 1

I need to see what the database , tables and database "Diagram" will look like.

And finally, Create one SQL statement to show PATIENTNAME, PRESCDATE,PRESCQTY,DOCTONAME,SPECIALTYNAME,MEDICATIONNAME, DOSAGE

Thank you so much, I appreciate anything you can do to help me with this!

Statewide Health Prescriptions Database PATIENT DOCTOR SPECIALTY MEDICATION PRESCRIPTION LATE SUBMISSION WILL NOT BE ACCEPTED AND WILL RECEIVE ZERO This Final Project demonstration will have THREE () ) recordings / 3 attachement in ONE SUBMISSION Recording \#1: MUST NOT exceed 20 minutes. Recording \#2: MUST NOT exceed 35 minutes. Recording \#3: MUST NOT exceed 5 minutes. Students must practice and complete this project at least one time before starting the recording. Your ZOOM Recording must include your Video (Student Face), NO AUDIO, and Desktop Recording of your demonstration of ERDPlus and SSMS. Use the attached document to complete the following steps: Step 1: Recording Video \#1: Use ERDPlus to create the ER Diagram and Relational Schema Step 2: Recording Video \#2: Use SSMS to create the Database, Tables, Database Diagram, and Insert all the Data. You May Copy Data Values BUT NOT SQL CODES Step 3: Recording Video \#3: - Create one SQL Statement to show PatientName, PrescDate, PrescQty, DoctoName, SpecialtyName, MedicationName, Dosage Statewide Health Prescriptions Database PATIENT DOCTOR SPECIALTY MEDICATION PRESCRIPTION LATE SUBMISSION WILL NOT BE ACCEPTED AND WILL RECEIVE ZERO This Final Project demonstration will have THREE () ) recordings / 3 attachement in ONE SUBMISSION Recording \#1: MUST NOT exceed 20 minutes. Recording \#2: MUST NOT exceed 35 minutes. Recording \#3: MUST NOT exceed 5 minutes. Students must practice and complete this project at least one time before starting the recording. Your ZOOM Recording must include your Video (Student Face), NO AUDIO, and Desktop Recording of your demonstration of ERDPlus and SSMS. Use the attached document to complete the following steps: Step 1: Recording Video \#1: Use ERDPlus to create the ER Diagram and Relational Schema Step 2: Recording Video \#2: Use SSMS to create the Database, Tables, Database Diagram, and Insert all the Data. You May Copy Data Values BUT NOT SQL CODES Step 3: Recording Video \#3: - Create one SQL Statement to show PatientName, PrescDate, PrescQty, DoctoName, SpecialtyName, MedicationName, Dosage