Sin título
Diapositivas del conjunto (5)
-
- 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
-
- 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
-

- Pie de imagen: ER- diagram
-
- 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)
-

- Pie de imagen: Relational schema
Información
- Descripción
- Diapositivas sobre Sin título, creado por Aashish Choudhary cs21b002 el 06/03/2024.
- Creado por
- Aashish Choudhary cs21b002
- Visitas
- 16
- Valoración
Más sobre Entity-Relationship Model and Diagrams