Create an ERM diagram from a business problem listed below. Go to the document

$$Assignment $1$ business problem and student roster$$ locate your name and the business problem

you$$ve been assigned.

Ensure your ERM has at least six$(6)$ entities. We recommend that you use Lucidchart to create

your ERM. Within the Lucidchart website, select ERD as the template. There are a lot of

premium features that come with your BU email. Leverage them in the future in your other

courses. $($max$.1$ point$)$

Task $1-2$: Ensure to identify the Primary Key for each entity. Identify the foreign keys where

needed. $($max$.1\mathrm{.}5$ point$)$

Task $1-3$: Identify the relationship between entities using a triangle or diamond shape. Please

describe this relationship. $($max$.1$ point$)$

Task $1-4$: Identify the cardinalities for each relationship. $($max$.1\mathrm{.}5$ points$)$

Task $1-5$: Write $24$ pages describing the transaction that you$$ve modelled, relationship

between entities and the cardinalities identified. All submissions must use the APA format.

Taylor Swift's Eras Tour is a captivating musical odyssey that invites audiences to embark on a

journey through the diverse and transformative phases of Taylor Swift's illustrious career. This

Page $6$ of $6$

tour offers an immersive experience that celebrates Taylor Swift's evolution as an artist,

showcasing her distinct eras marked by different musical styles, personal growth, and chart$-$

topping hits.

Each concert within the Eras Tour encapsulates a specific period of Taylor Swift's musical

catalog, from her country roots to her pop$-$infused melodies, and onwards to her more

experimental sounds. With each era comes a unique stage design, setlist, and visual storytelling

that transports fans to the heart of the music that defined those moments.

You have been given the exciting task of designing a comprehensive database system for Taylor

Swift's highly anticipated "Eras" concert tour. Your mission is to design a robust database that

efficiently manages and stores information related to the various eras, concerts, venues,

tickets, merchandise, and fan engagement.

This database should allow Taylor Swift$$s management team to perform the following tasks:

$$ Store era details such as era ID$,$ era name, album releases, and tour start$/$end dates.

$$ Allow fans to explore Taylor Swift's musical evolution and the highlights of each era.

$$ Record concert details including concert ID$,$ date and time, era ID $,$ and venue ID$.$

$$ Store information about the setlist, special guests, and any unique features of each

concert.

$$ Maintain a list of venues with venue ID$,$ name, location, capacity, and amenities.

$$ Allow organizers to plan tours efficiently by selecting suitable venues for each concert.

$$ Handle ticket information such as ticket ID$,$ concert ID$,$ ticket type, price, and availability.

$$ Manage online ticket sales, pricing tiers, and VIP packages.

$$ Store merchandise details, including merchandise ID$,$ item name, description, price, and

availability.

$$ Enable fans to purchase tour$-$specific merchandise and memorabilia.

$$ Capture fan interactions and engagement, including fan ID$,$ concert ID$,$ fan feedback,

and social media interactions.

$$ Allow fans to share their experiences and contribute to the tour's online presence.

Design a database to store the above information, ensure that you follow tasks $1-1$ to $1-5.$

Please note that you need to create at least six $(6)$ entities, no points will be deducted if you

decide to create more than six entities.