¡GoConqr estrena diseño! Cuéntanos qué te parece.

Diapositivas

Entity-relationship model: YouTube Music library database

Aashish choudhary Inglés 5 diapositivas

Diapositivas del conjunto (5)

  1. Assignment-1 group-17

    • Entities:
    • User: Represents individuals who interact with the YouTube Music Library. Users have profiles containing information such as username, email,password...
    • Attributes: User ID (primary key), Username, Email, Password, Profile Picture, Date of Birth, Subscription Status
    • Artist: Refers to musicians, bands, or music creators whose content is available on YouTube Music.
    • Attributes: Artist ID (primary key), Name, Genre, Country, Description
    • Album: Represents a collection of songs released by an artist or a band.
    • Attributes: Album ID (primary key), Title, Release Date, Genre, Artist ID (foreign key)
    • Song: Denotes individual music tracks available on YouTube Music.
    • Attributes: Song ID (primary key), Title, Duration, Release Date, Artist ID (foreign key), Album ID (foreign key), Genre
    • Playlist: A curated collection of songs created by users.
    • Attributes: Playlist ID (primary key), Title, Description, Creator ID (foreign key), Creation Date
    • Genre: Represents different categories or styles of music.
    • Attributes: Genre ID (primary key), Name
    • Subscription: Represents the subscription status of users to premium features.
    • Attributes: Subscription ID (primary key), User ID (foreign key), Subscription Type, Expiry Date
  2. Relationships:

    • User-Artist: Many users can follow many artists, establishing a many-to-many relationship. It indicates the artists a user follows and the users who follow an artist
    • Artist-Album: An artist can release many albums, creating a one-to-many relationship
    • Artist-Song: An artist can create many songs, forming a one-to-many relationship
    • Album-Song: An album can contain many songs, establishing a one-to-many relationship
    • User-Playlist: A user can create many playlists, creating a one-to-many relationship
    • Playlist-Song: A playlist can contain many songs, forming a many-to-many relationship as a song can belong to multiple playlists
    • User-Subscription: A user can have one subscription at a time, forming a one-to-one relationship
  3. ER Model-

  4. Relational Schema:

    • Relational Schema:
    • User(UserID, Username, Email, Password, ProfilePicture, DOB, SubscriptionStatus)
    • Artist(ArtistID, Name, Genre, Country, Description)
    • Album(AlbumID, Title, ReleaseDate, Genre, ArtistID)
    • Song(SongID, Title, Duration, ReleaseDate, ArtistID, AlbumID, Genre)
    • Playlist(PlaylistID, Title, Description, CreatorID, CreationDate)
    • Genre(GenreID, Name)
    • Subscription(SubscriptionID, UserID, SubscriptionType, ExpiryDate)
    • User_Artist(UserID, ArtistID)
    • Playlist_Song(PlaylistID, SongID)
    • Primary keys are bolded, and foreign keys are italicized.
  5. Relational schema:

    • Relational schema:

Información

Descripción
Diapositivas sobre Sin título, creado por Aashish choudhary el 05/03/2024.
Creado por
Aashish choudhary · mar 2024
Actualizado
5 mar 2024
Visitas
2
Valoración

Más sobre Entity-Relationship Model and Diagrams

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué te parece el nuevo diseño?

¿Te gusta?