Consider the following data requirements. There are a set of Journals. Each Journal has unique Print-ISSN, unique Online-ISSN, unique name. Each Journal has many subjects such as "Artificial Intelligence, Computer & Communication Sciences, Computer Science, Electronics/Mechanics, Mathematics". Each subject has unique ID and Description. Each subject can be shared between multiple journals. Each journal has many volumes and issues. Each volume has volume number, year. Volume number is an integer that distinguishes one volume from another for the same journal. Each issue has and issue number. Issue number is an integer that distinguishes one issue from another for the same volume. Each issue has set of articles, each article has unique DOI, title, from page, to page and number of pages. Article is written by many authors. Each author has unique ORCID, name as first name and family name, email, and multiple phone. Each article is published in one issue, but each issue has many articles. Author can write many articles, and article may be written by many authors There are set of publishers. Each publisher has unique ID, Name, address (country, city, P.o.Box), multiple email, multiple phone and Unique url for his website. Draw ER model for the above scenario Mapping ER model to database schema.
Consider the following data requirements. There are a set of Journals. Each Journal has unique Print-ISSN, unique Online-ISSN, unique name. Each Journal has many subjects such as "Artificial Intelligence, Computer & Communication Sciences, Computer Science, Electronics/Mechanics, Mathematics". Each subject has unique ID and Description. Each subject can be shared between multiple journals. Each journal has many volumes and issues. Each volume has volume number, year. Volume number is an integer that distinguishes one volume from another for the same journal. Each issue has and issue number. Issue number is an integer that distinguishes one issue from another for the same volume. Each issue has set of articles, each article has unique DOI, title, from page, to page and number of pages. Article is written by many authors. Each author has unique ORCID, name as first name and family name, email, and multiple phone. Each article is published in one issue, but each issue has many articles. Author can write many articles, and article may be written by many authors There are set of publishers. Each publisher has unique ID, Name, address (country, city, P.o.Box), multiple email, multiple phone and Unique url for his website. Draw ER model for the above scenario Mapping ER model to database schema.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Transcribed Image Text:Consider the following data requirements.
There are a set of Journals. Each Journal has unique Print-ISSN, unique Online-ISSN, unique
name. Each Journal has many subjects such as "Artificial Intelligence, Computer &
Communication Sciences, Computer Science, Electronics/Mechanics, Mathematics". Each subject
has unique ID and Description. Each subject can be shared between multiple journals.
Each journal has many volumes and issues. Each volume has volume number, year. Volume
number is an integer that distinguishes one volume from another for the same journal. Each issue
has and issue number. Issue number is an integer that distinguishes one issue from another for the
same volume.
Each issue has set of articles, each article has unique DOI, title, from page, to page and number of
pages. Article is written by many authors. Each author has unique ORCID, name as first name and
family name, email, and multiple phone.
Each article is published in one issue, but each issue has many articles. Author can write many
articles, and article may be written by many authors
There are set of publishers. Each publisher has unique ID, Name, address (country, city, P.o.Box),
multiple email, multiple phone and Unique url for his website.
Draw ER model for the above scenario
Mapping ER model to database schema.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 4 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education