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

Diapositivas

Sin título

Aashish Choudhary cs21b002 Inglés 5 diapositivas

ER- diagram

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(primary key), Password, Gender, Date of Birth, Address(street, city, province, postal code)
    • Artist: Refers to musicians, bands, or music creators whose content is available on YouTube Music.
    • Attributes: Artist ID (primary key), Name, Country, Description
    • Album: Represents a collection of songs released by an artist or a band.
    • Attributes: Album ID (primary key), # of Songs, Year, aGenre, aLength, aName
    • Song: Denotes individual music tracks available on YouTube Music.
    • Attributes: Song ID (primary key), Name, Length, Stream, Genre
    • Playlist: A curated collection of songs created by users.
    • Attributes: Playlist ID (primary key), Name, # of songs, pLength
    • Account: Represents the account status of users to premium features.
    • Attributes: Account ID (primary key), Subscription pan, Payment info
  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
    • 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-Account: A user can have one account , forming a one-to-one relationship
  3. Diapositiva 3

    • ER- diagram
    • Pie de imagen: ER- diagram
  4. Relational schema:

    • 1. userAccount (UserID (PRIMARY KEY), Email ,UserPassword ,Dob ,Gender, Subscription)
    • 2. addressUser(UserID (PRIMARY KEY), Street, City, Province, PostalCode)
    • 3. Artist (ArtistID (PRIMARY KEY), ArtistName );
    • 4. Album (AlbumID (PRIMARY KEY), AlbumName, AlbumYear, Genre);
    • 5. Release (AlbumID (PRIMARY KEY) ,ArtistID (PRIMARY KEY))
    • 6. song (SongID (primary key), ArtistID, AlbumID, Streams, SongName,, SongLength, Genre)
    • 7. playlist (UserID, PlaylistID (Primary key), PlaylistName )
    • 8. contains(PlaylistID SongID)
    • 9.follows (UserID, ArtistID)
  5. Diapositiva 5

    • Relational schema
    • Pie de imagen: Relational schema

Información

Descripción
Diapositivas sobre Sin título, creado por Aashish Choudhary cs21b002 el 06/03/2024.
Visitas
15
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?