Consider following given database design.

1. Write a query to display the course_name and respective author_tutor_ATB.

2. Write a query to display date_of_registration, personal_name (student table), course_id and course_name.

3. Write a query to display course_name, author_tutor_atb, personal name where gender_mf is female.

4. Write a query to display the student_id, date_of_enrollment, test_result sorted by date_test_taken.

5. Write a query to display course_name, course_description and respective subject_name.

Subjects PK subject_id subject_name eg Database Design Students PK student_id date_of_registration date_of_latest_logon login_name password personal name middle_name family_name other_details Courses PK course_id FK author_id FK subject_id course_name course_description other_details Course_Authors_and_Tutors PK author_id author_tutor_ATB login_name password personal name middle_name family_name gender_mf address_line_1 address_line_2 address_line_3 other_details Student_Course_Enrolment PK registration_id FK student_id FK course_id date_of_enrolment date_of_completion other_details Student_Tests_Taken PF registration_id test_result date_test_taken other_details