$1.$ Create an ERD model based on this figure$2.$ Create another table called SUBJECT that reflects that a tutor can tutor more than one subject. This may require you to add a SubjectID column in the Match History table. Also, include a domain constraint to indicate that the only subject names allowed are Reading, Math, and ESL. $3.$ Update your ERD model to include the Subject table$4.$ Implement your ERD model in SQLite $4.$ Write a query to identify all students who have been matched with a tutor whose status is Temp Stop or Dropped. Save your view as Query$\_1\mathrm{.}5.$ Count the number of lessons by the tutor status. Save your view as Query$\_2\mathrm{.}6.$ Which tutors did not submit the report in June? Save your view as Query$\_3.$TUTOR $($TutorID$,$ CertDate, Status$)$

$\backslash$table$[[$TutoriD$,$CertDate,Status$],[100,\frac{1}{05}\frac{?}{2018},$Active$],[101,\frac{1}{05}\frac{?}{2018},$Temp Stop$],[102,\frac{1}{05}\frac{?}{2018},$Dropped$],[103,\frac{5}{22}\frac{?}{2018},$Active$],[104,\frac{5}{22}\frac{?}{2018},$Active$],[105,\frac{5}{22}\frac{?}{2018},$Temp Stop$],[106,\frac{5}{22}\frac{?}{2018},$Active$]]$

STUDENT $($StudentID$,$ Group, Read$)$

$\backslash$table$[[$StudentID$,$Group,Read$],[3000,3,2\mathrm{.}3],[3001,2,5\mathrm{.}6],[3002,3,1\mathrm{.}3],[3003,1,3\mathrm{.}3],[3004,2,2\mathrm{.}7],[3005,4,4\mathrm{.}8],[3006,3,7\mathrm{.}8],[3007,4,1\mathrm{.}5]]$

MATCH HISTORY $($MatchID$,$ TutorID, StudentID, StartDate, EndDate$)$

$\backslash$table$[[$MatchID$,$TutorID,StudentID,StartDate,EndDate$],[1,100,3000,\frac{1}{10}\frac{?}{2018},],[2,101,3001,\frac{1}{15}\frac{?}{2018},\frac{5}{15}\frac{?}{2018}$