QUESTION 2 The academic world is an interesting example of international cooperation and exchange. This problem is concerned with modelling of a database that contains information on re-searchers, academic institutions, and collaborations among researchers. A researcher can either be employed as a professor or a lab assistant. There are three kinds of professors: Assistant, associate, and full professors. The following should be stored: - For each researcher, hisher name, year of birth, and current position (if any). - For each institution, its name, country, and inauguration year. - For each institution, the names of its schools (c.g. School of Law, School of Business, School of Computer Science, ...). - A school belongs to exactly one institution. - An employment history, including information on all employments (start and enddate, position, and what school). - Information about co-authorships, i.e., which researchers have co-authored a research paper. - The titles of common research papers should also be stored. - For each rescarcher, information on his/her highest degree (BSc, MSc or PhD), including who was the main supervisor, and at what school. - For each professor, information on what research projects (title, start date, and enddate) he/she is involved in, and the total amount of grant money for which he/she was the main applicant. (a) Draw an E/R diagram for the data set described above. Make sure to indicate all cardinality constraints specified above. The E/R diagram should not contain redundant entity sets, relationships, or attributes. Use relationships whenever appropriate. If you need to make any assumptions, include them in your answer. Hint: list the entitics, relationships \& constraints of the deseribed system. Follow the nine-step process practiced in class. - Identify the entities in the above specification. - Identify the relationships among the entities. - Identify the attributes of the entities. - Identify keys - Define the relationships - Deseribe Cardinality of the relationships - Find the constraints between entities and relationships. - Check the Specification to see if you have missed anything (15 marks) (b) Map your ERD to database tables (10 marks) Total (25 marks)