Q$1.$ Consider the following relational schemas.

student $($ id$,$ name, programe$)$

course $($ sourredd, titie, department$)$

enrolliment $($ id$,$ course id$,$ year, semester$)$

texthook $($IS$84,$ author$\_$nane, title, edition, publisher, year $)$

book$\_$adoption $($Id$,$ course id$,$ year, semster, ISBN$)$

Draw an $E-R$ diagram that produces the schemas listed above. $(20pts)$