(Solved) : Exercise 1 Two Operational Database Schemata Given Research Db Authors Authcode Firstname Q44028780 . . .
Exercise 1: Two operational database schemata are given: RESEARCH DB AUTHORS (AuthCode,FirstName, LastName, Position, IdNumber) ARTICLES (ArtCode, Title, MainAuthor: AUTHORS, Journal Name, Journal Publisher) NEW_RESEARCH_DB RESEARCHERS (IdNumber, ResearcherFirstName, Researcher Last Name, Position, Recruitment Date) JOURNALS (Journal.code, JournalName, Language, classification, Publishercode, PublisherName, PublisherCountry) RESEARCH_PRODUCTS (Prodcode,Title, Type, Journal Code : 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. Show transcribed image text Exercise 1: Two operational database schemata are given: RESEARCH DB AUTHORS (AuthCode,FirstName, LastName, Position, IdNumber) ARTICLES (ArtCode, Title, MainAuthor: AUTHORS, Journal Name, Journal Publisher) NEW_RESEARCH_DB RESEARCHERS (IdNumber, ResearcherFirstName, Researcher Last Name, Position, Recruitment Date) JOURNALS (Journal.code, JournalName, Language, classification, Publishercode, PublisherName, PublisherCountry) RESEARCH_PRODUCTS (Prodcode,Title, Type, Journal Code : 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.
Expert Answer
Answer to Exercise 1: Two operational database schemata are given: RESEARCH DB AUTHORS (AuthCode,FirstName, LastName, Position, Id…
OR