You are building a database system for a new unified college application software system. Each applicant needs to register on the system by providing their basic information, including his/her full name, email address, phone number, date of birth, and address in terms of region, city and country. After registering, the applicant can then view all the available colleges in the system, presented by their names, location in terms of city and country, ranking, and the list of their faculty, including their email addresses, research area, tenure, and number of publications. The applicant can then choose to apply for any number of colleges s/he wishes to. For each application, the candidate must indicate the semester and year s/he is applying for, his/her current GPA, the application date and the email addresses of at least 3 references to provide recommendation letters, which are not necessarily from the same college the candidate is applying to. Finally, each college doesn't accept more than one application for each applicant in a given semester / year. Design a database for the college application system described above, illustrating both the ERD and the resulting Relational Model