Considering the ER diagram provided, answer questions $1-4$

$1)$ Write CREATE TABLES statements needed to implement the corresponding relational databse

$2)$ Write INSERT INTO statements to fill each created table with $2$ tuplets

$3)$ SQL $1$: Write SQL squery to find names of all students who are enrolled in a course with courseid equals to ICS$311$

$4)$ SQL $2$: Write SQL query to find the number of students enrolled in each classid