Question: A small news agency needs a database system ( EER diagram ) to maintain information about its collection of photos and articles. Each photo has
A small news agency needs a database system EER diagram to maintain information about its collection of photos and articles. Each photo has a code, date and dimension width and height Some photos are internal eg taken by a photographer employed by the agency and for them the database should store the name of the photographer. Other photos are external purchased from other sources and it is necessary to store the name of the source and the price. Each article is about one or more persons. The database should store the following information about each person: a unique id name not unique date of birth, and hisher area eg politics, music or sports Note that there may be more than one area per person. For a photo, the database stores which persons are shown on it For an article, we store its code unique title, the authors it was written by including the position for each author and the volume and the issue it appeared in Each author has a unique number, name, and hisher department. For an article, we also need the persons it is about and the photos published with the article.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
