Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started