please, answer the question

4. (30 points)Now scientific interest class management database system will be developed in a Middle school according to the situation in real mini-world as follows: Every student can attend at most 2 interest classes or no class,each class has at least 10 students and at most 20 students. Each class is exactly managed by one group, and one group can manage at most 3 classes and at least one class. Students participate in each class to count the hours. There are more kinds of no-overlapping interest classes according to sport type: Mathematics, computer, and english. You are required to manage students' parents information. Each activity must be a kind of them. Each entity has the attibutes as follows: group: groupcode, groupname,grouplocation, grouptel ; stduent: studentcode, studentname, sex, birthday; inter: sportcode, sportname, sporttype; parent: name,birthday,parenttel; Please complete the following design, you can give simple name for each attribute name and relation anme. (1)Design EER diagram and indicate entities, attributes, relationships between them and participation constrains of them. In the EER model, there must include one weak entity and one specialization according to the description above (10 points) (2)List the strong (nonweak) entity types in the EER diagram.(4 points) (3)List the weak entity in your EER model and give the partial key and primary key of it.(4 points) (4)Explain the specialization constraints according to sport activity type you designed above(Disjoint or Overlapping, Full or partial).(4 points) (5)Map to relational schemaes based on EER above, for each relation, define the relation name, attribute names and corresponding datatype, primary key, and foreign key( if any). (8 points)