Using what you have learned, create a SongCollection database.

Each song has

name,

a publication date,

a genre

a writer

Relationships

each writer may have multiple songs

each song has a single writer.

each genre will have multiple songs

each song has only one genre.

Create and use foreign keys to make the proper linkages between tables.

You will need to create data for testing and insert$/$import it into your tables. You may choose to use INSERT commands or create the data in a CSV and Import it$.$ As you create data, be sure to create data that includes

$6$ or more songs

$3$ or more genres

$3$ or more writers

$2$ or more songs in each genre

$2$ or more songs by each writer

After you insert$/$import the data in each table, show the results of a SELECT $*$ FROM each table to verify the number of rows added.

SUBMIT:

SQL of all table creates

SQL of all inserts $($if using$)$

SQL of all select statements

ERD diagram

screen shot of the results of all select statements.

Be sure to read requirements for submitting assignments in Start Here and Syllabus!