please answer this question asap, thank you

QUESTION 1 Scholarship Application Database's stores data about each individual application that the Teen Bowlers Foundation receives. As a database designer, you are assigned to design the new database system according to the following requirements: . Each student can submit one or more applications (one application per year). Each application is submitted by only one student. Each application has a unique application ID number, application date, class level, GPA, GPA scale, academic honours, extracurricular activities, community activities, other scholarships awarded, and financial need. . The student's record contains student ID, student's last name, first name, date of birth, address, city, state, zip code, phone number and email. Each school can be associated with one or more applications. Each application is associated with only one school. Each school has a unique school ID, school name, type, address, city, state, zip code and phone number. . Each application must include two or more recommendations. Each recommendation is included with only one application. Each recommendation has a recommendation ID, recommendation date, recommender first name, last name, and relationship of recommender to student. Each bowling centre can be associated with one or more applications. Each application is associated with only one bowling centre. The bowling centre table contains a unique bowling centre ID, bowling centre name, address, city, state, zip code, and phone number. a) Draw a complete Entity Relationship Diagram based on the information given above. Show all entities, attribute, relationships and connectivities involved. (16 marks) b) List TWO (2) examples of report that can be produced from this database system. (4 marks)