You are going to develop a database that will store information about journals.

Question

You are going to develop a database that will store information about journals. Each journal has a journal identification number and name. Each journal may have any number of issues (for example monthly issues or three-monthly issues etc). Each issue is identified by its number and date issued. Each issue contains a number of articles. The length in terms of a number of words is kept for each article, together with the number of diagrams in the article. One or more writers may write each article. The writer’s name and address, as well as the fee paid to a writer for an article, is also recorded. A writer may contribute as many articles to any journal. Identify the entities

1.Business Rules

2.Identify attributes - these are qualities/values associated with entities

3.Identify the relationships between the entities

Explanation / Answer

The entities are:
1. Journal
2. Issue
3. Article
4. Writer

Attributes for each entity.

1. Journal- attributes are: ID, Name
2. Issue- Issue number, Date of issue
3. Article- # of words, #of diagrams
4. Writer- Name, address, fee, article id

Relationship between entities

Journal contains Issues. Issues is a weak entity connected to a strong entity.
Similarly, Issue contains article where an article is a weak entity and Issue is a strong entity.
Article and Writer has one to many relation as one article can have one or more writers.
Journal articles have one to many relation, similarly journal and issue has one to many relations.

Business Rule

A jounal can have any number of articles from one writer.
One or more writers can contribute to a single article.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.