A small new agency located in KSA called KSANews, has decided to install a database system in order to manage its picture (photo and article library). Here are the requirements describing what information needs to be stored in the database: • A picture has a number that is unique for each picture, a date (when the picture was taken), and a height and a width (which determine the size of picture). • Information about persons mentioned in an article or who are shown on a picture is stored separately. For a person, we store the name, the data of birth and his/her "area" (c.g., politics, sports, movie,...). • For a picture we store which person are shown on the picture. • For an article, we store the title, the list of authors, and the volume and number of the issue the article appeared in, along with the number of articles. authors are stored separately with their name (First Name, Second Name and Last Name) and the name of the department (within JordanNews) along with the social security number unique for each author and the author phone and email (while authors may have several numbers and emails). For each article, we furthermore want to store which persons are mentioned in the article and which pictures are shown together with the article. Finally, the system keeps track of the date when the author finish writing the article. Design an ER Schema Diagram to represent the above database. State clearly any assumptions that you make.
A small new agency located in KSA called KSANews, has decided to install a database system in order to manage its picture (photo and article library). Here are the requirements describing what information needs to be stored in the database: • A picture has a number that is unique for each picture, a date (when the picture was taken), and a height and a width (which determine the size of picture). • Information about persons mentioned in an article or who are shown on a picture is stored separately. For a person, we store the name, the data of birth and his/her "area" (c.g., politics, sports, movie,...). • For a picture we store which person are shown on the picture. • For an article, we store the title, the list of authors, and the volume and number of the issue the article appeared in, along with the number of articles. authors are stored separately with their name (First Name, Second Name and Last Name) and the name of the department (within JordanNews) along with the social security number unique for each author and the author phone and email (while authors may have several numbers and emails). For each article, we furthermore want to store which persons are mentioned in the article and which pictures are shown together with the article. Finally, the system keeps track of the date when the author finish writing the article. Design an ER Schema Diagram to represent the above database. State clearly any assumptions that you make.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
100%
Transcribed Image Text:A small new agency located in KSA called KSANews, has decided to install a database
system in order to manage its picture (photo and article library). Here are the requirements
describing what information needs to be stored in the database:
• A picture has a number that is unique for each picture, a date (when the picture was
taken), and a height and a width (which determine the size of picture).
• Information about persons mentioned in an article or who are shown on a picture is
stored separately. For a person, we store the name, the data of birth and his/her "area"
(e.g., politics, sports, movie, ...).
• For a picture we store which person are shown on the picture.
• For an article, we store the title, the list of authors, and the volume and number of the
issue the article appeared in, along with the number of articles. authors are stored
separately with their name (First Name, Second Name and Last Name) and the name
of the department (within JordanNews) along with the social security number unique
for each author and the author phone and email (while authors may have several
numbers and emails). For each article, we furthermore want to store which persons
are mentioned in the article and which pictures are shown together with the article.
Finally, the system keeps track of the date when the author finish writing the article.
Design an ER Schema Diagram to represent the above database. State clearly any
assumptions that you make.
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 1 images
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY