Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Make an ER diagram that could store information about articles on a sports website. We keep track of articles. An article has a date written,

Make an ER diagram that could store information about articles on a sports website.

We keep track of articles. An article has a date written, the sport the article was about, an article number, and the text of the article.

We keep track of authors. For each author, we keep track of the name and the email.

An author could write many articles, and an article could be written by more than one author.

An article must have an author but not all authors write articles.

We keep track of sports teams. For each team, we keep track of its sport, the team name, the team city, and the league of the team.

Articles are written about sports teams. A sports team can have many articles written about them but do not have to but an article is for only one sports team and must be for one sports team.

Some teams have arch-rivals. If a team has an arch-rival, we keep track of that. A team can only have one arch-rival but a team can be an arch-rival to many teams.

We keep track of games. A game has a game number, a date, a location, and a time.

A team can play a game as a home team. For each game we keep track of the score of that team. A team can only be a home team for many games but each game can only have one home team playing. A team can play a game as an away team. For each game we keep track of the score of the away team. A team can be an away team for many games but each game can only have one away team.

Need help please I have to make this in ERD Assistant tool so please explain it clearly like madatory/optional or one to many etc

thanks

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases DeMYSTiFieD

Authors: Andy Oppel

2nd Edition

0071747990, 978-0071747998

More Books

Students also viewed these Databases questions

Question

Why is the System Build Process an iterative process?

Answered: 1 week ago