Identify Functional Dependencies

Please use the following information from my term projects to make the figure pictures: Ears Catalog$$:

$$

$1.$ Genre

o$$ Description: The category or style of music that a track belongs to$.$

o$$ Example:

$$ Genre: Pop

$2.$ Track Name

o$$ Description: The title of a specific song or piece of music.

o$$ Example:

$$ Track Name: $$Espresso$$

$3.$ Artist Name$($s$)$

o$$ Description: The name$($s$)$ of the artist$($s$),$ performer$($s$)$ or group$($s$)$ who recorded the track.

o$$ Example:

$$ Artist Name$($s$)$: Sabrina Carpenter

$4.$ Album Name

o$$ Description: The title of the album that the track is part of$.$

o$$ Example:

$$ Album Name: $$The Black Album$$

$5.$ Album Artist Name$($s$)$

o$$ Description: The name$($s$)$ of the artist$($s$),$ performer$($s$)$ or group$($s$)$ credited for the album.

o$$ Example:

$$ Album Artist Name$($s$)$: Beyonc$,$ The$-$Dream, Raphael Saadiq

$6.$ Album Release Date

o$$ Description: The date when the album was officially released.

o$$ Example:

$$ Album Release Date: $04/12/2024$

$7.$ Track Number

o$$ Description: The position of the track within the album.

o$$ Example:

$$ Track Number: $1($if it is the first track on the album$)$

$8.$ Track Duration $($ms$)$

o$$ Description: The length of the track in milliseconds. Easier to digest for music.

o$$ Example:

$$ Track Duration $($ms$)$: $210000($which is $3$ minutes and $30$ seconds$)$

$9.$ Explicit

o$$ Description: Indicates whether the track contains explicit content or language. True for yes and False for no$.$

o$$ Example:

$$ Explicit: True

$10.$ Popularity

o$$ Description: A measure of how popular the track is$,$ often based on streams, downloads, and other metrics.

o$$ Example:

$$ Popularity: $85($on a scale from $0$ to $100)$

Relationships among the Entities:

$1.$ Genre: Track Name$1$:M

o$$ A Genre can have many Track Names.

o$$ A Track Name belongs to one Genre.

$2.$ Track Name: Artist Name$($s$)$ M:N

o$$ A Track Name can have many Artist Names $($e$.$g$.,$ collaborations$).$

o$$ An Artist Name can be associated with many Track Names.

$3.$ Track Name: Album Name$1$:$1$

o$$ A Track Name is part of one Album Name.

o$$ An Album Name contains one Track Name.

$4.$ Album Name: Album Artist Name$($s$)$ M:N

o$$ An Album Name can have many Album Artist Names.

o$$ An Album Artist Name can be associated with many Album Names.

$5.$ Album Name: Album Release Date$1$:$1$

o$$ An Album Name has one Album Release Date.

o$$ An Album Release Date is associated with one Album Name.

$6.$ Album Name: Track Number$1$:M

o$$ An Album Name can have many Track Numbers.

o$$ A Track Number is associated with one Album Name.

$7.$ Track Name: Track Duration $($ms$)1$:$1$

o$$ A Track Name has one Track Duration.

o$$ A Track Duration is associated with one Track Name.

$8.$ Track Name: Explicit$1$:$1$

o$$ A Track Name has one Explicit status.

o$$ An Explicit status is associated with one Track Name.

$9.$ Track Name: Popularity$1$:$1$

o$$ A Track Name has one Popularity rating.

o$$ A Popularity rating is associated with one Track Name.

At this point you should have several tables in your design.

For each table create a functional dependency graph that shows what columns$/$fields are functionally dependent on what other fields. $$It should look something like this figure from the Chapter $6$ review questions: see attached photo

Note that the$$determinants may suggest your primary key, but they need not dictate it$.$

Make sure to look for transitive dependencies, that is$,$ where a field is most strongly dependent on another field but that field is not a key for the table.

If you have a drawing program that can do this, that's great. Save the files in JPG$,$ PNG$,$ or PDF$,$ or paste into Word.

You can also draw these diagrams freehand, and then scan it$.$ You can post a photo of your drawing. But$$make it neat and clear! If your drawing is unclear, or you upload a sloppy or tilted photo, I will mark you down.$$

Important: some fields are calculated from other fields. Don't include those in the diagram, but mark each with an asterisk and explain it$.$