Draw an entity-relationship diagram

Assignment Help Other Subject
Reference no: EM13185152

Draw an entity-relationship diagram (ERD) for a publishing company that produces indexes of magazine and periodical articles. The following describes the relationships among the entities:

• Each article may have many authors, and each author may write many articles.
• An article may be found in only one periodical, but each periodical will usually contain many articles.
• Each article may have many topics, and each topic may be in many articles.

a. Draw an ERD for the articles, authors, periodicals, and topics based on the above described relationships. Identify relationships among the diagram entities as “one-to-one”, “one-to-many”, “many-to-one”, or “many-to-many”. Identify entities as “entity”, “associative entity”, or “attribute entity.”

b. Draw an ERD in the third normal form for the articles, authors, periodicals, and topics. Identify relationships among the diagram entities as “one-to-one”, “one-to-many”, or “many-to-one”. Identify entities as “entity”, “associative entity”, or “attribute entity”.

Reference no: EM13185152

Questions Cloud

Pros and cons of filing a discrimination action : What are some of the "pros" and "cons" of filing a discrimination action, if you are the one being discriminated against or harassed? Is filing with the EEOC worth it?
Relevant facts in the case-analysis of the legal issues : A statement of the relevant facts in the case, an analysis of the legal issues that were raised in the case, a statement of the courts response to those legal issues, and an analysis of the reason for the court's ruling in the case.
Apply the appropriate level ii hcpcs code modifier : Apply the appropriate Level II HCPCS code modifier for each of the following examples. Explain your rationale for each selection.
Should you get a different perspetive : When it comes to risk...should you seek input from someone who views risk the same as you, or should you get a different perspetive? Should that perspective come from someone who is more of a risk taker than you are, or should it be someone who is mo..
Draw an entity-relationship diagram : Draw an entity-relationship diagram (ERD) for a publishing company that produces indexes of magazine and periodical articles. The following describes the relationships among the entities:
Neighbor whom you rarely see places for sale sign on her car : Assume that a neighbor whom you rarely see places a "for sale" sign on her car, offering to sell it for $6,000. You learn that she is moving to another state and needs the extra cash to help finance the move.
Strategic relevance-criterion deficiency and reliability : Select two aspects of a performance appraisal from the following list. In at least 250 words, explain the following: what are the special challenges in each area and what would be the effects on employees and employers if the challenges were not addr..
Contribute to the body''s daily expenditure of energy : List the major components that contribute to the body's daily expenditure of energy and Compare the relative contributions of a sedentary person with a marathon runner of the same body weight
Perspective in psychology : Interest in the reasoning process that contributes to effective problem solving is most characteristic of which perspective in psychology?

Reviews

Write a Review

 

Other Subject Questions & Answers

  What kind of disorder does employee illustrate

He hates routine also boredom more than anything else. Thrill-seeking also impulsive actions have gotten him fired from this job. It will get him fired at many ors." What kind of disorder does employee illustrate.

  Components and functions of god myths

Critically discuss the elements and functions of god myths. also summarize the elements and functions shared by the female and male divine

  Evolution of title vii

What is the history and evolution of title VII.

  Marshall's interest in the history of art influence

How does Marshall's interest in the history of art influence his work?

  Emotional aspect

Is the emotional aspect (e.g. sharing, support) of love in Sternberg’s trian  gular theory of love.

  Question regarding corporate restructuring

How would Joe find out the base rate of successful employees at the company?

  Ethical practice and ethical working environment

Maintaining an ethical practice and an ethical working environment does appear to be painful; however, it is the less of two evils.

  Female buyer

A female buyer is looking at two used cars; one has good gas mileage, and the other leather seats. The buyer has always wanted a car with a leather interior.

  Types of insurance available for the van

The office has a van for transporting supplies, patients to a local medical center, and groups to conferences, etc. Discuss the types of insurance available for the van. Recommend one type and justify your recommendation.

  Impact of environment and experience on gene expression

Write down the two ethical considerations when using the genetic screening for medical and psychological disorders.

  What is sustainable development

What is sustainable development? Why is it important? Provide examples of how architecture has been adapted to promote sustainable development.

  Cutaneous leishmaniasis

Consider the 'community' of individuals serving our country in the Middle East. Many are returning home with an affliction termed Baghdad Boil, or cutaneous leishmaniasis.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd