Database Schema $(50$ pts$)$

You are given the following description of the entities that need to be stored in the database. Your task is to design a database schema $($set of tables$)$ to store these entities.

Your schema must be minimally redundant in storing data. In other words, you should build a set of tables that minimize the repetition of data, by using foreign keys $-$ credit will be in accordance with this.

Artist: An individual or a group$/$band$,$ uniquely identified by their name. An artist might release albums, as well as songs that are not in albums $($singles$).$ artist $($the same artist records a song exactly once$),$ but the title may be shared by multiple artists $($i$.$e$.$ covers$).$ need not all be in the same genre. name and artist name is unique.

Playlist: A user can make any number of playlists of songs. Note: A playlist may not include an entire album, only individual songs. Each song is either from some album, or a single that's not in any album.

Every playlist has a title, and a date$+$time when it was created. A playlist may be modified any number of times after creation by adding or removing songs, but the title and date$+$time will not change.

The title of a playlist is not unique since different users might create playlists with the same title. However, a user's playlists will have unique titles.

Rating: A user could rate an album, a song $($even if it's in an album$),$ or a playlist. A rating is limited to $1,2,3,4,$ or $5($numeric$),$ and is made on a specific date. reduce redundancy.

Your database structure should have the most appropriate data type and size for each column in each table. of foreseeable values.

Make sure you define and specify all primary keys, foreign keys, unique valued columns or unique valued combination of columns, and null$/$non$-$null properties for columns.

In the document you will submit, type in the create table statement for each of the tables you create in the database. If you don't have the full create statement for a table, you will not get credit for it$.$