College

We appreciate your visit to What is the ERD for this scenario Store Name Jukebox Records Customers Can be members or non members of the Music Club Non members Pay. This page offers clear insights and highlights the essential aspects of the topic. Our goal is to provide a helpful and engaging learning experience. Explore the content and find the answers you need!

What is the ERD for this scenario?

- **Store Name**: Jukebox Records

- **Customers**: Can be members or non-members of the Music Club.
- **Non-members**: Pay $10 per CD purchased.
- **Members**: Pay different prices depending on membership level.
- **Member Details**: Records of member addresses are maintained for marketing.
- **Membership Levels**:
- **Pearl Members**: Yearly fee of $25, $7 per CD.
- **Silver Members**: Yearly fee of $50, $5 per CD.
- **Gold Members**: Yearly fee of $100, $4 per CD.
- **Platinum Members**: Yearly fee of $200, $2 per CD.

- **Employees**: 7 employees; only one employee can handle each customer sale.

- **Products**: Music CDs
- **Sales to Store**: Vendors can sell single or multiple CDs.
- **Purchases**: Customers can buy single or multiple CDs.

- **Customer Example**: Mark Liberman is a Pearl level customer with several purchases, including at least one multiple CD purchase.

- **CD Categorization**:
- **Categories**: Each CD is categorized by style, artist, and decade recorded.
- **Single Decade, Artist, and Style**: Each CD must fall into one decade, one artist, and one style category.
- **Styles**: Examples include rock, jazz, rap, and country.
- **Artists**: Each CD has a specific artist or artist group.

- **Songs**:
- **Tracking**: Tracks individual songs on each CD.
- **Multiple CDs**: Some songs occur on multiple CDs.

- **Inventory**:
- **In-stock Items**: Customers often request lists by artist or style.
- **Song Title Search**: Database allows for song title searches to find matching CDs.
- **CD Entry**: Once a CD is added, it doesn't need re-entry, even if inventory runs out.

Answer :

The Entity-Relationship Diagram (ERD) for the given scenario includes entities like Customer (with Membership), Employee, Vendor, CD, Artist, Style, Decade, and Song, along with their respective attributes and relationships.

In the given scenario, we can identify several entities and their relationships. The main entities include Customer, Employee, Vendor, CD, Artist, Style, Decade, and Song.

Customers can be members or non-members of the Music Club. Non-members pay a fixed price of $10 per CD, while members have different membership levels and corresponding prices based on their level. The membership levels are Pearl, Silver, Gold, and Platinum, each with different annual fees and CD purchase prices.

The store keeps detailed records of member addresses and sends flyers to customers in certain zip codes. This suggests a relationship between Customer and Zip Code entities.

The store has multiple employees, and only one employee can make each customer sale. Hence, there is a one-to-one relationship between Employee and Customer entities.

The store sells CDs, and vendors supply them. Vendors should be capable of selling single or multiple CDs in a single sale. Additionally, multiple vendors may sell the same used CD. Therefore, we have a relationship between Vendor and CD entities.

Each CD falls into a single decade, artist, and style category. This implies relationships between CD and Decade, CD and Artist, and CD and Style entities.

The database tracks individual songs on each CD, and some songs occur on multiple CDs. This suggests a relationship between CD and Song entities.

The store categorizes CDs by style, artist, and decade recorded. Sometimes, customers request a list of in-stock items by a particular artist or style, or they may need to find a CD based on a song title. However, the database does not track the writers of songs.

To ensure data integrity and avoid redundant entries, once a CD is added to the database, it never needs to be entered again, even if its inventory runs out temporarily.

In summary, the ERD for this scenario includes entities such as Customer, Employee, Vendor, CD, Artist, Style, Decade, and Song, with various relationships between them.

Learn more about Entity-Relationship Diagram

brainly.com/question/33440190

#SPJ11

Thanks for taking the time to read What is the ERD for this scenario Store Name Jukebox Records Customers Can be members or non members of the Music Club Non members Pay. We hope the insights shared have been valuable and enhanced your understanding of the topic. Don�t hesitate to browse our website for more informative and engaging content!

Rewritten by : Barada