Consider the following relations defined in a university database:

Student $($sid: integer, sname: string, major: string$)$

Course $($cid: integer, cname: string, credits: integer, dept: string$)$

Section $($sec$\_$id: integer, cid: integer, semester: string, year: integer, instructor: string$)$

Grade $($sid: integer, sec$\_$id: string, Grade: string$)$

Write SQL queries for the following:

$1.$Retrieve the name and transcript of each student majoring in CS$.$ Transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student.

$2.$For each section taught by Prof. Einstein, retrieve the course number, semester, year, and number of students in the section.

$3.$Retrieve the names and major departments of all $10-$point students $($students who have a grade of A in all their courses$).$

$4.$List the names of courses along with the number of students who joined the course during each semester and year.