O GoConqr está de visual novo! Conte para nós o que você achou.

Slides

Sem título

Aashish Choudhary cs21b002 Inglês 5 slides

Slides do 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. Slide 3

    • ER- diagram
    • Legenda: 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. Slide 5

    • Relational schema
    • Legenda: Relational schema

Informações

Descrição
Slides sobre Sem título, criado por Aashish Choudhary cs21b002 em 06-03-2024.
Criado por
Aashish Choudhary cs21b002 · mar 2024
Atualizado
6 mar 2024
Visualizações
15
Avaliação

Mais sobre Entity-Relationship Model and Diagrams

Fale Conosco

Sobre o que é sua mensagem?

O que você acha do novo visual?

Você gostou?