Please Help!

Exercise 1: Two operational database schemata are given: RESEARCH_DB AUTHORS (AuthCode, FirstName, LastName, Position, IdNumber) ARTICLES (ArtCode, Title, MainAuthor:AUTHORS, JournalName, JournalPublisher) NEW_RESEARCH_DB RESEARCHERS ( IdNumber , ResearcherFirstName, ResearcherLastName, Position, Recruitment Date) JOURNALS (JournalCode, JournalName, Language, classification, PublisherCode, PublisherName, PublisherCountry) RESEARCH_PRODUCTS ( Prodcode, Title, Type, JournalCode: JOURNALS) // research products may be of type "journal paper" or "patent" AUTHOR_PRODUCT ( Prodcode: RESEARCH_PRODUCTS, IdNumber:RESEARCHERS, Ismain) The first database stores the articles written by researchers of the University of Bologna till 2000; the second database stores the articles and the patents since 2000 (a patent has one or more authors but it is not associated to any journal; the Ismain attribute is Boolean). Attributes with the same name in different schemata are assumed to have the same meaning. Inspect and normalize both databases, making reasonable assumptions on the multiplicity of relationships, then integrate them to draw a reconciled Entity-Relationship schema