Entity-relationship model: YouTube Music library database
Folien in diesem Satz (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, 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
-
- 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
-
- 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.
-
Informationen
- Beschreibung
- Folienset am Ohne Titel, erstellt von Aashish choudhary am 05/03/2024.
- Erstellt von
- Aashish choudhary · Mär 2024
- Aktualisiert
- 5 Mär 2024
- Aufrufe
- 2
- Bewertung
Mehr zu Entity-Relationship Model and Diagrams
