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

  Strategic decision-making in public administration

Illustrat your opinion on the statement which the subjectivity of administrators is at work in their decision making?

  Existentialism by soren kierkegaard

Soren Kierkegaard claimed that all truth (in particular, religious truth) is subjective, inward, and immediate, not objective and universal.

  Characteristics of hero

etermine this hero's characteristics. This discussion should not be limited to his or her personal character, but should include some discussion of how he or she influences the larger context: family, community, workplace, and society.

  Leaders of band societies

Leaders of band societies-  rule by edict,  are similar to communist dictators in that they have absolute power over the people, lead by persuasion, example, and personal influence

  Health care administration work environment

Discuss your research findings in health care and how you will apply them to a health care administration work environment? 100-200 words please.

  Govern employment and ethical practices

Imagine that you are a manager of the HR department of a company and you are required to lay off one of your employees. Propose two ways that you can ensure you are abiding by the laws that govern employment and ethical practices. Respond and evaluat..

  Override an individual value system

Can you help me determine a situation in which you have used script processing in a work or other life situation? Do you believe that scripts can override one's value system?

  Develop message before you wrote email message

Write down the decisions you made for DECIDE: Step 1. State goal, Step 2. Estimate receiver / situation and Step 3. Develop message before you wrote email message.

  Cognitive-behavior and short-term psycho-dynamic therapies

What are some similarities and differences between cognitive-behavior and short-term psycho-dynamic therapies?

  Risk of long term affects of poor choices

Explain how you can help teenagers and adults get through these adolescent years without the risk of long term affects of poor choices.

  Case study of bill

Bill hired Smith, a well-known artist, to paint his portrait for $3,000. The portrait is to be given to Bill's mother as a gift, and Smith agrees that the final product is subject to Bill's "personal satisfaction."

  Stream of particles leaving a black hole

When particle-antiparticle pairs are created just outside the event horizon of a black hole, one member can escape while the other enters the black hole. What is the name of this stream of particles leaving a black hole?

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