Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 1: Artists and Songs Review the following structural business rules regarding artists and songs to complete this part. An artist sings many songs. A

Part 1: Artists and Songs Review the following structural business rules regarding artists and songs to complete this part.

An artist sings many songs.

A song is sung by one or more artists.

A song has a duration.

A genre applies to at least 15 songs.

1. The business rules above specify all of the relevant entities needed for this exercise. To get started, list the names of all entities provided in the business rules above.

2. The rules also specify all of the relevant relationships. Identify each relationship along with the entities it relates.

3. Some rules are not well formed in that they either do not describe both directions of the relationship, or they combine multiple relationships or entities into one statement. This can result in missing or ambiguous optionality and plurality constraints. Correct these rules by modifying them or adding new statements as necessary. You may make reasonable assumptions when doing so and there is no provably right list of assumptions; however, please state your assumptions.

4. Combine the original list of rules with your modifications to create a complete list of business rules. This combined list will not add additional entities, but will specify the optionality and plurality constraints for both sides of all relationships.

5. Create a conceptual entity-relationship diagram using Crows Foot notation that reflects your list of business rules. You may use Microsoft Visio Pro, Lucidchart, or another similarly capable drawing application to produce your ERD. Note that cardinalities are not required in the diagram, though relationship connectivity notations are required.

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

Oracle 11G SQL

Authors: Joan Casteel

2nd Edition

1133947360, 978-1133947363

Students also viewed these Databases questions

Question

How the acquisition method is different from the purchase method?

Answered: 1 week ago

Question

=+10. How are inflation and unemployment related in the short run?

Answered: 1 week ago

Question

=+8. Why is productivity important?

Answered: 1 week ago